SQL Server Performance

Help with SSIS

Discussion in 'SQL Server 2005 Integration Services' started by jagblue, Nov 27, 2007.

  1. jagblue New Member

    Hi AllI have a excel file.
    It contains three columns
    • 1st column contain table name
    • 2nd column contains flag which tells me to transfer all, none or comp rows from source table to destination table
    • 3rd row contains query if for computed data
    How can I Import this excel file SSIS and use to migrate data from source and destination tables Thanks
    jagblue, Nov 27, 2007
    #2

  2. Luis Martin Moderator

    Check:
    http://www.sql-server-performance.com/articles/dba/import_text_files_ssis_p1.aspx
    HTH
    Luis Martin, Nov 27, 2007
    #3

  3. ranjitjain New Member

    Hi,
    Assuming that you have a fixed source and destination name, only table name is going to be dynamic with row filter all stored in excel file.
    In this case, I feel one solution could be to import excel file as is in temp table in source/destination and
    then build query dynamically as the table names were stored as value in excel file, and loop through all the excel values .
    ranjitjain, Nov 28, 2007
    #4

  4. dineshasanka Moderator

    You can use conditioanl split for the first column.
    depending on the table name you can direct the records to relevent tables.
    I can develop sample SSIS package if you can send me the excel sheet and the relevent tables scripts to dineshasanka@gmail.com
    dineshasanka, Nov 30, 2007
    #5

Share This Page