April 9, 2008 at 2:38 pm
Hi friends,
I am new to SSIS. I want to create backup of my database and copy to another system in the network(file server). I have written a SP to create backup on a daily basis.
I have a shared folder in my file server which has 5 sub folders namely Monday - Friday
So that my current backup file should copy to corresponding folder. When I run XP_CMDSHELL, its generating error "network path not found or not accessible..."
Its mapped drive.
I thought to design a DTS package and do this process. I am returning destPath from the stored procedure. How can I save this to a variable(scope = package). And how can I use this variable to use in File System Task to copy the file to destination?
Can anybody give me an idea of this...
Thanks in advance
April 9, 2008 at 2:55 pm
Just an FYI, DTS is the old stuff. SSIS is the new stuff.
If you want to do this in SSIS, I recommend reading up on the following in Books Online (or GOOGLE for it):
Under the SQL Server Integration Services header
Execute SQL Task Editor
Execute SQL task [Integration Services]
Package Configuration syntax [Integration Services]
--the above contains links to tutorials on how to create a config file
Under the SQL Server 2005 header
xp_cmdshell (this is disabled in 2k5, so you'll want to read this to make sure you know how to enable it and who can run it)
Not sure how to do it in DTS as I never got much past the Import/Export DTS wizard.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply