Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    56

    Unanswered: How to move a folder/files from windows to linux inside a DTS package?

    Hi guys,

    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\ root@11.11.11.11:/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.
    Thank you!

  2. #2
    Join Date
    Aug 2008
    Posts
    147
    Have you tried adding it to .bat file and and execute a script task?
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  3. #3
    Join Date
    Jan 2007
    Posts
    56
    Hi,

    I have not tried this yet. How can i parametrize the folder name with this option though?

    Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •