Post reply

SSIS Error code DTS CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER When using FOREACH Loop container

  • April 7, 2010 at 9:05 am

    #140159

    I am trying to use a foreach loop contain to export multiple tables to multiple excel files. The excel destination file throws the following error - SSIS Error code DTS CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER as soon as i change the connection properties and add my variable to the expression editor? Any ideas?

  • April 7, 2010 at 3:21 pm

    #1147805

    It needs a value at design time. So copy a valid value out of the current connection string and paste it into the variable.

    CEWII

  • April 7, 2010 at 3:43 pm

    #1147812

    Thanks a lot for the help but how do I assign the variable a value at design time from the connection string?

  • April 7, 2010 at 4:01 pm

    #1147832

    I get the following error when i assign a value to the string variable - The resuly of the expression @[User::PostTableName] on property "Connection String" cannot be written to the property.

  • April 7, 2010 at 4:20 pm

    #1147840

    ksparke (4/7/2010)

    I get the following error when i assign a value to the string variable - The resuly of the expression @[User::PostTableName] on property "Connection String" cannot be written to the property.

    Try the steps outlined in the following link:

    http://p2p.wrox.com/sql-server-2005/63110-dynamic-connectionstring-ssis.html

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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