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 |
|
amrindia
Starting Member
8 Posts |
 Posted - 2008-04-22 : 01:16:27
|
| HiI currently have an SSIS package which looks for an excel file and uploads its. The connection is set up to look for a file upload.xls in a folder called Upload on the C drive. So each time a file needs uploaded, the upload.xls is copied into C:\Upload. This all works fine. However now I need to change it so that the files that are uploaded take the format Upload10012007.xls, so they will have the date appended onto the end of the Upload.How do I go about setting up my connection to look for Upload10012007.xls? The file name will be dynamic as it will change each day but it will always contain Upload at the start of the filename.Thanks for your help,MichaelMichaelRaj Arokiyasamy |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-22 : 01:42:21
|
| Put the upload task in a for each loop container.Use the variable file name in the task.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
How do I go about setting up my connection to look