Thanks for the tips! I went ahead and wrote an ASP page, then parsed through it to convert it to an ActiveX script.
Good idea about exporting to multiple csv files, however I didn't want so many objects cluttering my DTS.
Thanks.
Function Main()
Dim conn, strConn
Dim RS, RS2, RS3, RS4
Dim...
Hello,
I need to export data from two tables into a single CSV file from SQL Server 2000. This needs to happen inside a DTS package for automation purposes.
TABLE1 has 8 fields and will be the first line of the CSV file.
TABLE2 has 7 fields and will be the 2nd line of the CSV file.
I belive...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.