It turns out that one of the dts tables was missing. As this was a new server build, we have been able to re-install SQL 2000 - all's now well.
Thanks to all those who tried to help.
Simon
Eeek. I've just re-read my reply and it's a bit ambiguous.
When I said 'Sorry, not much help really' I meant my reply to yksvaan was not much help, not yksvaan's reply to my initial message.
Sorry for the confusion.
Simon
Thanks for your help yksvaan. I can save the script as a .dts file without any trouble whatsoever.
Unfortunately, as this is a new server build, there aren't any other packages so I can't verify whether I can open any existing files.
Sorry, not much help really.
I need to create DTS packages for importing data from UNIX to SQL Server 2000. We are using a proprietory ODBC bridge between the two which appears to be working OK - validated by the fact that my DTS packages run properly and import data into tables as there supposed to. I can't, however, save...
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.