Post reply

Tranformingand Tranfering a big file

  • February 12, 2009 at 11:11 am

    #127682

    I need to transfer a big files 100 GB ++ between two locations.

    SOURCES located in the network segment A.

    DESTINATION located in the network segment B.

    Both location is protected by firewall.

    Can I used the Data Flow Task, OLE DB Source, and Flat File Destination to accomplish?

    The files are sql server 2005 database MDF files.

    Can anyone give me some hints and an examples?

    Thanks in advance.

    Edwin

  • February 12, 2009 at 5:31 pm

    #943302

    Edwin (2/12/2009)

    I need to transfer a big files 100 GB ++ between two locations.

    SOURCES located in the network segment A.

    DESTINATION located in the network segment B.

    Both location is protected by firewall.

    Can I used the Data Flow Task, OLE DB Source, and Flat File Destination to accomplish?

    The files are sql server 2005 database MDF files.

    Can anyone give me some hints and an examples?

    Thanks in advance.

    Edwin

    Edwin,

    If you don't have any transformations in between, why not:

    1. Backup database from location 1.

    2. Restore database to location 2.

    And avoid using SSIS entirely?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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