Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Why Does Execute Process Require a Connection Mgr?

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2011-03-24 : 09:32:08
I built a simple (2005) SSIS package that has only an Execute Process Task. In the executable I have the full path to the .bat file which runs the RoboCopy command.

When I run the package (in design mode) I get an error saying
"Package Validation Error - The connection manager '' '' is not found"

Seems to be saying that I need to add a connection manager to the package but why I don't know. This package will ultimately run 3 .bat files so I'll have 3 Execute Process tasks.

Does anyone know why the connection manager " " is not found error is coming up?

Thanks, John

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2011-04-07 : 20:51:20
I was able to get the package to work without adding a connection manager.

See this post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=158889

Go to Top of Page
   

- Advertisement -