Post reply

SSIS - cannot connect to database after putting tasks in sequence container

  • November 8, 2013 at 3:00 pm

    #279007

    I had a package that worked perfectly until i decided to put some of its tasks inside a sequence container (More on why I wanted to do that - How to make a SSIS transaction in my case?).

    Now, i keep on getting an error -

    [Execute SQL Task] Error: Failed to acquire connection "MyDatabase". Connection may not be configured correctly or you may not have the right permissions on this connection.

    Why could this be happening and how do I fix it ?

  • November 11, 2013 at 7:51 am

    #1665484

    Check for Max concurrent executable property from the Sequence container properties and change it accordingly then this problem can be solved and its default is -1

    Transaction should be changed package level and task level...

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

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