Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sharu_tan
Starting Member
11 Posts |
 Posted - 2008-04-11 : 06:05:50
|
| I have CSV file as source for SSIS package every time the filename will be changing like trd_1990M1_1990M12.csv,trd_1991M1_1991M12.csv , trd_1992M1_1992M12.csv etc.,so it will vary as per user selection . i need to run the same SSIS package to execute the different file name with the same structure.Please let me know the solution for that how to pass the file name dynamically to SSIS package. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-11 : 12:28:59
|
| Use a variable for holding your Filename and map the filename proiperty of flat file source to this variable. B/w where will the user be selecting this value? |
 |
|
|
|
|
|
Dynamic File Name for Flatfile source in SSIS