restoring a DTS - SQL Server Forums

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

SQL Server Development (2000)

restoring a DTS

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2006-04-10 : 03:01:15

ihave a DTS which i have exported from one server in dts and bas format's!
how can i restore the DTS in another server?
thnaksi navance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-04-10 : 20:45:24

In Enterprise Manager, right click on the Data Transformation Services item under the new server and select "Open Package". You can then select your .dts file and re-save to the new server.

HTH,
Tim

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-04-10 : 20:52:32

pelegk2,
This is just an advice,

after doing what timmy has said, make sure the Server / DB are of the new server
(I faced that, when restored a DTS from another server, the referred Server was the old one)

U can check the properties, or u can run the package and see.

Srinika

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-05-20 : 07:08:01

is there a way to restore bas format?

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-20 : 17:31:02

What's bas format?

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-05-21 : 08:30:49

visual basic file

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-21 : 10:33:48

If you have the file, can load it by right click on dts in em and choose open package. Put in file name then click on open.

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-05-21 : 15:10:13

you cant!
your more then welcome to try

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-05-21 : 15:25:46

You can not restore bas files to SQL Server.

You only do a "save as" to bas when you want to execute the code via VB.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-21 : 16:52:55

I confused it with structured file.

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-05-27 : 01:44:32

ok i have found a way to do it :
Using the Visual Basic File to Save to SQL Server :
[url]http://msdn2.microsoft.com/en-us/library/aa176248(SQL.80).aspx[/url]

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources