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 |
|
benking9987
Posting Yak Master
124 Posts |
 Posted - 2010-04-15 : 19:12:22
|
| I have a package that imports a specified file (or group of files within a particular folder), and then moves the files to an archive folder. I have been able to get this to work just fine. For testing purposes, I have no problems. HOWEVER, when I go to production, the file that will be placed in the directory is ALWAYS called the same thing (CustomerPO.csv). Given that, I need to append the date/time to the beginning or end of the file before it is moved into the archive folder.If you are going to suggest a tutorial created on a blog by Rafael Salas, please don't. I've already exhausted all of his suggestions, read all of the notes, downloaded his sample package. There is something about his setup that will not work on my environment.Can anyone help? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
benking9987
Posting Yak Master
124 Posts |
Posted - 2010-04-16 : 11:29:22
|
| I was hoping to use SSIS, since I have no working knowledge of VBScript......Can anyone help out with this? |
 |
|
|
|
|
|
Problems with ForEach Loop File Task