Extract Date From Filename and Load into Database Table along with Data | SSIS

[@adamjamadar9213]

Muje ms sql to ssis se file kaise generate karte hai ispar 1 vedio karege ky

[@KCchamp007]

Thanks ,worked like a charm

[@SatyarthProgrammingHub]

You're welcome!

[@Vaibhavibarahate]

Hello, I want to extract the week number from the date, Can you tell me how to do that?

[@SatyarthProgrammingHub]

DATEPART( "ww", GETDATE()) You can pass your target date in place of GETDATE() function.

[@Vaibhavibarahate]

@@SatyarthProgrammingHub I want to extract the week number from the file modified date. By this method I am getting week number of the current date

[@SatyarthProgrammingHub]

This method is for example only. To get the file modified you have to write a script inside script task and hold that date in a variable and then pass that variable in place of getdate() in above example and you will get the week number based on the file modified date.

[@virtualtibet]

Hi Satyarth, I have a stored proc which takes a date as an input parameter. We have to grab the date from a simple text file. The file has only two lines - ReportingMonth (header) and an actual date. I am not able to make it work. Please help. Thanks!

[@SatyarthProgrammingHub]

Hello there, sure I will help you. can you please explain in little more detail the issue you are facing. Are you not able to pass the parameter to the store procedure? Are you not able to read data from the text file? Or any other issues.

[@virtualtibet]

@@SatyarthProgrammingHub I created a dataflow task, connected to the txt file and grabbed the date as ReportingMonth. The next task where I have the execute stored procedure, I am not able to pass the date ReportingMonth as an input parameter. Thank you!

[@akki4718]

hi. how to extract file using file name and file id in excel file and save in another folder that extracted file

[@SatyarthProgrammingHub]

Hello Akash, thank you for comment. Can you please help me understand if your talking about "name and id" in file name or it is inside the excel file on some worksheet in the form of column (name, id).

[@akki4718]

@@SatyarthProgrammingHub Thanks for your response. Actually there are some files in a folder that consists no. Of pdf’s along with an excel file. In which there is three columns are file id, file name (pdfs) & source destination. So first task is to load all the files (excel for exa- a.xlsx & rest all pdf) into sql server database in a table that have file id, name, source path with content (additional column) & second package we have to create which read the file name from excel file (a.xlsx) and that file name(pdf file or what all the names in this file) that file/files should b loaded into destination source given in that particular file