02 Get the file name from file path in SSIS and insert into SQL table | SSIS real time scenarios

Get the file name from file path in SSIS and insert into SQL table | SSIS real time scenarios
Dts.Variables["FileName"].Value = System.IO.Path.GetFileName(Dts.Variables["FilePath"].Value.ToString());

Download the file\script used in the Video from below link

Get the file name from file path in SSIS and insert into SQL table
How do I find the filename in SSIS?
How do I import a filename into SSIS?
How do I get the filename in SQL?
How would you save file names from different folders in a SQL Server table?

[manikantthakur]

These are really Wonderful example & helping a lots taking concept also working perfectly.

[FehmiHamiti]

Thank you for a short and clean tutorial

[SuperKerr]

Excellent video! As always, very clear, precise and concise.

[OleYoule]

Hi Aqil, Great tutorial as always 👍 Thank you for sharing your knowledge!

[jagmohansolanki]

Excellent video!
Suppose, we are getting multiple file in FTP in .zip format and have to copy into local and unzip it and load files to SQL with different tables based on files name .
please make a video on that

[palivelasatishbhasker]

I faced errors on 2nd video practical as well. On 1st video you clarified and i also cleared by altering the table. Here im failing while fething the file . And a popup is been raised

[jorgeesparza]

Hello Aqil, I need your help! In the minute 5:5 to 5:45 you talk about connection manager. Do you have any videos on this topic?
I don't have any connections available in the dropdown "OLE DB Connection Manager"
Thanks!

[sriniwaaskorampalli]

sir in variable settings in script task... ur just created two variable and one to read and another to write the result from foreach loop and put into v2. ?

[pareshyadnik]

This is really helpful. if we have to load 50 files in 50 different tables what should be the steps..please share that video if you have

[AH-jnts]

Thank you For the Video I followed the steps and inserted the CSV file but when i tried to insert an Excel File it is giving me this Error "The connection string must contain one or more components of the form X=Y, separated by semicolons." And it only inserts one File eventhough i have two In the folder.

[ChaimaHermi-zipq]

I'm having an issue with extracting the Excel file name in SSIS. I've used a Foreach Loop and a Derived Column, but it always defaults to the first file instead of the desired one. What is the solution to this problem?

[roxvmri]

Hi Aqil, really awesome explanation. I was wandering what the steps would look like if you're loading those multiple CSV into multiple tables in SQL server and you a alter a column/ record in each CSV file ? Thanks as always.

[FlareSoul]

This video is gold! So if you run the SSIS a second time will the "Email" Table still exist or do we have to rename the CREATE TABLE OLEDB Destination to "Email" again? If the "Email" table does exist then all we need to do is Truncate the table for a clean run? Thanks!

[solomong.gebrhana]

I have these text files that come in every day and I need to import that to a specific table that is already created in the database(I got that part figured out). Now I need to know how to automate the process so that I don't have to do it manually every day (Like I have to change the file location every day in the SQL query to get to the new file. I also have to find and replace the " quotation because they don't want that in the table). So, I need to figure out how I can ignore that "quotation when importing to my table and how to do that daily. Schedule some kind of job so it can run daily. I am using Microsoft SQL server management studio.

[sriniwaaskorampalli]

sir script task is compulsory? do we need to have knowledge on c# or .net to learn ssis. i dont have knowledge on that with min of time i cannot learn them. should i go forward and learn ssis alone...to get a job?

[sriniwaaskorampalli]

cant we directly use the varaiable name in derived col transformation...

[sriniwaaskorampalli]

hi sri,
without using script task, can i directly insert the filename into sql table?

[NebroProg]

Dear Ahmed,

I hope you are well,

Can you please create a video to consume the data from APIs?

Best regards,
Alnebras.

[ahtishamsattar]

if want to upload from MYSQL to SQL server and want table name then how i can do that?

[radhac]

Hi, how is the file path fetched and assigned to file path variable in for loop. Please explain