Post reply

How Load multipl Excel Files into Table using SSIS 2012

  • January 8, 2015 at 6:12 am

    #313492

    I am new to SSIS..Plz explain.

  • January 8, 2015 at 6:20 am

    #1768759

    Priya004 (1/8/2015)

    I am new to SSIS..Plz explain.

    Assuming you are not also new to Google, please try searching there and then come back here with any specific questions you may have. This process is well documented elsewhere.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • January 8, 2015 at 9:26 pm

    #1768955

    Ofcourse..Yo are right..but I am confused with expressions,collections and connection strings ..Let me explain what I did after going through many sites..

    I am using BIDS 2012

    My tasks is to Get the excel files and loop through each of them ,load them into DB

    I have created 2 variables

    1.FilePath with value D:\TestFiles

    2.FileName with value Test.xlsx

    Created a For EachLoop container with

    1.Expression set to directory and mapped Filepath variable.(Not sure if this is really required as some suggested and some others not)

    2.Set the Enumeration configuration ,@Folder given Filepath again with \suffixed at the end.

    Confused here as if we set the directoy path with variable,then y do we need to set the folder path here?

    3.In variable mappings Selected File name variable

    4.Created a DFT with excel connection manager ..Set the expression in properties to @[User::FilePath].(Not sure if I need to change the connection string with Variable name in it or change the expression with File path variable)

    5.Created Data conversion task

    6.Created OLE DB Destination

    When I ran the package it gives

    [Excel Source [16]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    Hope u understood my issue

  • January 8, 2015 at 10:04 pm

    #1768958

    I am using BIDS 2012

    2012 has SSDT,not BIDS

  • January 8, 2015 at 10:59 pm

    #1768960

    Oh thanks for correcting..but do u gone through the actual issue I mentioned above?

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

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