Post reply

SSIS Package

  • October 11, 2012 at 9:21 pm

    #268421

    Hi all,

    We have developed a package where we are pulling data from master table into destination table but now i want the source data to be fed into the master table from files may be excel or csv so how can we do this?

    Pls help me out in this

    Thanks in advance

  • October 12, 2012 at 2:43 am

    #1548495

    CSV --> flat file connection manager and flat file source

    Excel --> Excel connection manager and Excel source

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 12, 2012 at 3:41 am

    #1548520

    Thanks for the reply,

    But i Hav like 42 CSV files and i need to pull the data frm all these 42 files nd insert in the master table how do i do that one???

  • October 12, 2012 at 3:44 am

    #1548522

    By creating 42 dataflows.

    If they all have the same structure, you can use a for each loop to loop over the files and use only a single dataflow. You need to configure the flat file connection manager dynamically by using an expression.

    Looping over files with the Foreach Loop

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 12, 2012 at 4:19 am

    #1548537

    Hey thank you so much yup the files have same structure:)

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

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