sql server dts: 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.

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.sqldts.com/205.aspx



--

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

[quoted text, click to view]