Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Exporting data and dynamically changing the destination file name
I have a DTS script that runs a stored procedure into a new table and then exports that data to a specific file. I now need to change that file name by incrementing the suffex. ie: myfile_0001.txt, myfile_0002.txt etc.. I can create a table to store the incremented number but I don't know how...- kscheeler
- Thread
- Replies: 10
- Forum: Microsoft SQL Server: Data Transformation Services
-
DB Watch Program for SQL
After reading the last few threads, I realized I had been using something in SQL that tells you what tables/fields get updated during a particular process. There's a program called DBWatch at the website below ($25 per copy) which I had found through the Microsoft SQL Magazine...- kscheeler
- Thread
- Replies: 3
- Forum: Macola ERP solutions
