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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 load package from .bas file

Author  Topic 

-Dman100-
Posting Yak Master

210 Posts

Posted - 2006-09-06 : 21:13:37
I created a couple of dts packages at work and need to load them onto my home server for further development.

I saved the packages as visual basic .bas files, zipped them up and brouht them home.

I'm now trying to load them on my instance of sql server. I haven't done this before.

How do I load them?

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-09-06 : 21:45:33
It's been a while since I played with them, but from memory you just execute them in the VB IDE and it will create the packages from scratch.
Have a look at the contained code and it should give you some pointers.

btw I normally find it easier to export/import using the .dts files.

HTH,

Tim
Go to Top of Page
   

- Advertisement -