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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-11-10 : 07:37:22
|
| i need to move file from c:\Source\File1.text to d:\Destination\File1.textit is need to run every 5 minutes,but each time i need to grow my counter i meen next run it will be like thatd:\Destination\File1.textd:\Destination\File2.textand after 5 minuted:\Destination\File1.textd:\Destination\File2.textd:\Destination\File3.text |
|
|
smeeluv
Starting Member
20 Posts |
Posted - 2009-11-10 : 10:34:20
|
| You need to have your variable built outside of SSIS that way you can run the package multiple times without refreshing your counter. As easy as a flat file with a number in it or a table in a database. Then pull that value into a variable inside SSIS and use it to declare your filename. |
 |
|
|
|
|
|
move file