June 13, 2012 at 1:15 am
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 ®ARDS,
pAVAN
June 13, 2012 at 2:04 am
Please post the full text of the error message you are receiving.
June 13, 2012 at 6:26 am
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.
June 13, 2012 at 6:32 am
Try using an OLE DB\SQL Native Client connection instead.
June 14, 2012 at 12:56 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy