Post reply

XLS Connection Manager

  • November 20, 2006 at 2:06 pm

    #121578

    Hi

     

    I want to create a xls connection manager where the connection string property will be equal to a variable. Could any one please help me how to implement the same in SSIS?

    Thanks in advance.

     

    Regards

    Utsab Chattopadhyay

     


    CDBA

  • November 21, 2006 at 6:19 am

    #673175

    When you create a excel source component in your data flow, you have to specify a connection manager for it (SSIS designer suggests to create one). When you create one here, the connection manager points to a specific excel file per default. Choose an excel file here that has the structure you need. After that, go to the properties of the created connection manager, choose the property "Expressions" and create a new expression where you override the connection string property with an expression where you use a variable that will hold the excel file (complete path) at runtime.

    At runtime, SSIS will override the connection string property of the connection manager with the value of the specified variable and the excel source component will use it.

  • November 21, 2006 at 11:04 pm

    #673379

    Hi,

    You can use ovrride the connection string property of the XLS Connection Manager so that it's taken at the run  time.

    THanks,

    S Suresh

  • November 22, 2006 at 8:28 am

    #673482

    Hi

     

    I got the solution..Thank you all.

    Also Tons of thanks to Dan Evans  for his continuous helps to get me the stuff working.

     

    Regards

    Utsab Chattopadhyay


    CDBA

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

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