how to open dts saved as bas file

Question

how to open dts saved as bas file

crazy4sql

SSCoach

Points: 19590
More actions
March 17, 2010 at 2:31 pm

#100715

Hi,
I have copied one DTS from one sql 2000 server and saved it as bas file.
I am moving it to totally different domain and would like to use it in the new sql server 2000/2005 environment.
Any idea how can I open this bas file?
----------
Ashish

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29389 More actions · Answer 1

If the BAS file is the only copy of the package that you have, the only way to open it in Enterprise Manager is to update the BAS file so that the program loads the definitions of the package (which is the contents of the BAS File) and then executes the appropriate save method to save it as a DTS file.

Have a look at http://msdn.microsoft.com/en-us/library/aa176245(SQL.80).aspx. It includes sample code on how to save the package.

The BAS file includes all of the code to load the DTS package.

If you still have the package on the original server, you can simply save it onto the new server.

crazy4sql SSCoach Points: 19590 More actions · Answer 2

Thanks for this. Actually my problem is I want to move one DTS from one domain to other domain so the only option is copy DTS to local system and then copy dts to destination server from local system.

I have saved the DTS as bas file and moved it to my local system. So could you please suggest how can I open it on destination server. Server is dedicated to SQL Server and no other application or software is in use on that

----------
Ashish

happycat59 One Orange Chip Points: 29389 More actions · Answer 3

Save as a structured storage file instead. This creates a file with .DTS extension. You can copy this file to the other server and open it using Enterprise Manager and then save it to the server.

crazy4sql SSCoach Points: 19590 More actions · Answer 4

Thanks for this.

While opening the file using ent manager, its giving me error as not a valid win32 application.

Please suggest

----------
Ashish

happycat59 One Orange Chip Points: 29389 More actions · Answer 5

Not sure why you are getting that error. Check service packs - do both servers have the same service packs in installed ?

If the new server is at the same service pack - try re-installing the client tools.