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.
| Author |
Topic |
|
rockstar283
Yak Posting Veteran
96 Posts |
 Posted - 2013-11-13 : 02:41:45
|
| I am trying to use a foreach loop to go over some sql server objects, so I am using SMO enumerator for it. When I try to configure SMO connection manager, I am getting an error 'Failed to connect to server......a network related or instance specific error..........'If I try to connect same server in a data flow, then that oledb connection manager works fine..but SMO connection manager fails..what am I missing here..can someone please help..Thank you!! |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2013-11-13 : 04:01:49
|
| Try to increase connection time-out time from 15 to 25 or 30 seconds.May be this will help you.In Love... With Me! |
 |
|
|
|
|
|
Problem with SSIS SMO enumerator connection