March 6, 2007 at 8:11 am
hello there
would someone share an example with me for this type of scenario:
1) copy a file from a ftp site on a local drive (ftp site of course requires username/password)
2) restore the database
I think this should be do able within a single job. are there any samples for something like this?
thanks
March 7, 2007 at 5:14 am
We have several of these processes running, using dts packages. The first step is an execute sql task which uses xp_cmdshell to call a batch file which controls the actual login, download and decryption from the ftp site. Next we kill open connnections to the database, set single user mode and restore the database (each in its own execute sql task). Finally, set multi user mode. I have several of these packages in production and they work well. We were unable to use the ftp task - but it was so long ago that I don't remember why - I think because the name changed each day. Hope this helps.
March 7, 2007 at 8:53 am
I used to have a task like Purple lady's. I did a "pushFTP" from the source side to get the files to our office rather than a pull. If that doesn't work, you can script something to pull down the files, calculating the names or have the source side rename the file and put it up there everyday.
Use two steps, one to get the file, one to restore.
http://www.sqlservercentral.com/columnists/sjones/pushftp.asp
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply