Post reply

excel sheet and connection

  • June 26, 2008 at 4:53 am

    #123584

    hi,

    I am loading excel file according to the sheets e.g. load second sheet only. I dont have problem loading them using variable in dataflow. but when i change my connection string for excel to variable filename it doesnt run.

    all i am doing is set it dynamically to loop through 4 or 5 excel files.

    any suggestions ???

    thanks

  • June 26, 2008 at 5:25 am

    #834531

    ^^ this is the error

    Error: The result of the expression "@[User::Filename]" on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the property.

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

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