Post reply

How to bring ZipFiles from another Server

  • September 14, 2016 at 7:54 am

    #329876

    Hi,

    I haven't used earlier FTP task, but I got a requirement to bring zip files from one server (A) to another server (B), Server A got From beginning to till data zip files, so only copy files which are not in Server (B) from Server A to Server B (server B has a Sql table to record what records are loaded to Server B form Server A). We got this mechanism earlier in SQL Job with PowerShell Script, but we need to recreate this mechanism in SSIS packages. Could someone help me with task.

    Many Thanks in Advance

  • September 14, 2016 at 2:29 pm

    #1900963

    Try this: http://www.sqlservercentral.com/articles/execute+process+task/129996/

  • September 14, 2016 at 3:14 pm

    #1900971

    What lptech posted may help. This is a pretty simple task. The way I would approach it is to:

    1. Create a script task (whatever language works for you) that compares the files on Server A to Server B and copies the "new" zip files into a different folder

    2. Create a Foreach Loop Container that uses a Foreach file Enumerator against the folder mentioned in Step #1 and does what ever you need to each file.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

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

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