SSIS connection manager

  • 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.

  • can you attach a screen shot of the execute sql task details?

  • 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

  • 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