Groups | Blog | Home
all groups > sql server dts > june 2007 >

sql server dts : Restoring DTS saved as .bas in SQL 2000


Kevin Mazzone
6/14/2007 8:35:18 AM
Hi,
I have a SQL 2000 DTS package that I saved as a .bas file that I need to
import back into SQL server. Does anyone know how I can do this?

Thanks!
Allan Mitchell
6/14/2007 9:04:22 PM
Hello Kevin,


There should be an option in the code to either execute the package or to
Save te Package to SQL Server. You simply comment/Uncomment as required

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Kevin Mazzone
6/18/2007 9:34:03 AM
I ended up having to import the .bas file into a standard EXE project in VB6
and execute it. It ended up going to SQL server then.

What a mess. I guess I'll only save as .DTS files from now on.

Regards,
Kevin

[quoted text, click to view]
AddThis Social Bookmark Button