PROBLEM IN SSIS PACKAGE

  • HI,

    I HAVE PROBLEM IN MY SSIS PACKAGE,IN MY PACKAGE NEARLY 20 TASKS . WHEN I EXECTE SINGLE TASK RUNNING FINE.BUT I PUT ALL TASK IN INTO CONTIANER IT'S FAIL.

    PLEASE HELP ME.

    THANKS &REGARDS,

    pAVAN

  • Please post the full text of the error message you are receiving.


  • hi,

    when i run single sql task ,it's working fine. but i put five sql task run parprelly ,i got error like that

    " [Execute SQL Task] Error: Failed to acquire connection "ProgressDataBase.dba1".

    Connection may not be configured correctly or you may not have the right permissions on this connection".

    1. i am using ODBC with ADO.NET connection manger for all tasks.

  • Try using an OLE DB\SQL Native Client connection instead.


  • gelli.pavankumar (6/13/2012)


    hi,

    when i run single sql task ,it's working fine. but i put five sql task run parprelly ,i got error like that

    " [Execute SQL Task] Error: Failed to acquire connection "ProgressDataBase.dba1".

    Connection may not be configured correctly or you may not have the right permissions on this connection".

    1. i am using ODBC with ADO.NET connection manger for all tasks.

    Good to see your caps lock is working again (and that you turned it off).

    Maybe Progress can't handle parallel connections (I don't know, never worked with it).

    So maybe don't execute everything in parallel but in series.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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