Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS connection manager Expand / Collapse
Author
Message
Posted Tuesday, March 27, 2012 10:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 3:18 PM
Points: 2, Visits: 31
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.
Post #1273709
Posted Wednesday, March 28, 2012 1:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 2:20 AM
Points: 5,231, Visits: 5,106
can you attach a screen shot of the execute sql task details?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1274097
Posted Wednesday, March 28, 2012 5:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:40 AM
Points: 13,735, Visits: 10,696
Did you specify a file connection manager to retrieve the .sql file and also an OLE DB connection manager for the database?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1274200
Posted Wednesday, March 28, 2012 12:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 3:18 PM
Points: 2, Visits: 31
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
Post #1274576
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse