Post reply

How to rename files in FTP server in SSIS script task

  • July 19, 2010 at 1:57 am

    #235340

    Hi there,

    I've searched a few topics regarding to the script sample of rename files in SSIS. However, it seems to be too complicate for me. I just wanna rename files' extension name on FTP folder, for example, rename all unprocessed files from *.txt to *.toproc, and then download to be processed.

    Can anyone give me a simple sample code for it.

    Thanks in advance!

    Han

  • July 19, 2010 at 5:01 am

    #1194820

    Hi,

    You can try File system task to rename the files.

    Thanks & Regards,

    Seshadri A.V

  • July 19, 2010 at 7:14 pm

    #1195248

    Hi,

    I understand that File System Task works properly on a local machine, however, is that possible to deploy and run this SSIS package onto a fpt server without SQL server Business Intelligence Development Studio installation?

    thanks and regards

  • July 20, 2010 at 11:27 pm

    #1195956

    Hi,

    Go through the following article to execute the SSIS package without BIDS in remote server. Hope this will resolve your problem.

    http://www.bidn.com/blogs/mroman98/bidn-blog/513/execute-a-ssis-package-from-a-remote-server

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply