var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to move a folder/files from windows to linux inside a DTS package?
I am using SQL Server 2000 and I have created a DTS package that exports out a set of csv files into a dated directory. As the last step I need to move all these files to a drive on a linux box.
The following command works (i.e. moves the files) when executed from the command line:
pscp -i E:\privatekey.ppk -r E:\SourceFolder\ firstname.lastname@example.org:/destination_folder
How do I make it part of the DTS package as the last step?
The main requirement is that I want to parametrize the folder name - otherwise I think I could just use the "execute process task" and it would work.
Please let me know how I can achieve this.
Have you tried adding it to .bat file and and execute a script task?
I have not tried this yet. How can i parametrize the folder name with this option though?