February 3, 2014 at 9:35 pm
Hi All,
I have a package with 1000s of tables int, many data flow tasks with Sources inserting to Destinations.
Whenever I change the Source connection that all the sources use, SSIS reports "Testing Connection" for a few minutes and then validates every !@#$%^& source. Same with the Destination connection. Please, please how can I disable this? Setting the connections to "Work Offline" does not work, nor does setting the package and connections to Delay Validation. Must I set each data flow task to delay validation, seems extremely tedious since we have so many of them.
February 3, 2014 at 11:58 pm
If your package is so big, it is better to split it up in smaller packages. This is more manageable and it makes the guy who comes after you not want to kill you.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 4, 2014 at 12:01 pm
Well I ended up editing the XML directly (no testing connection waits there!) I did indeed inherit this package from times past and yes it is super frustrating. Perhaps down the road I can break it up but this is not a priority for me now.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply