Regarding execute restore database in dts

Regarding execute restore database in dts

Post by SXRlc » Sat, 14 Apr 2007 23:20:00


Hi Guys,
I want to design a dts that has two tasks, one task is retrieve backup file
name in the global variable, and second task get that file name, then restore
database from that file. I don't know which task I can use in send task that
I can get that file name from globle variable then execute restoration
database. Thanks.
 
 
 

Regarding execute restore database in dts

Post by Allan Mitc » Sun, 15 Apr 2007 22:54:15

Hello Iter,

OK how do you intend to pass in the filename to the Global Variable?

Once you have the filename in the variable you can use this article to execute
it in an ExecuteSQL task

http://www.yqcomputer.com/




Allan Mitchell
http://www.yqcomputer.com/ | http://www.yqcomputer.com/ | http://www.yqcomputer.com/ |
http://www.yqcomputer.com/