March 27, 2012 at 10:49 am
When I run the "Execute SQL Task" component results in this error message:
Validation has started
[Execute SQL Task] Error: No connection manager is specified.
Error: There were errors during task validation.
Validation is completed
I already have a connection manager specified to this component and a sql file in the attachment that drops and creates tables. I constantly get this error message every time I run it. Does anyone have suggestions?
P.S.
The connection manager was already tested and succeeded.
March 28, 2012 at 1:29 am
can you attach a screen shot of the execute sql task details?
March 28, 2012 at 5:25 am
Did you specify a file connection manager to retrieve the .sql file and also an OLE DB connection manager for the database?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 28, 2012 at 12:53 pm
Thanks a lot guys and much appreciation for the responses, but I figured it out this morning. I decided to test the script that i had in the execute sql task component via SSMS and it provided a much more accurate error. I had incorrect syntax for creating a trigger and it located which table had the error, but I'm not sure why SSIS sent me a connection error. Anyways its all good now
thanks guys 🙂
Lerad
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply