Thanks Paul.
I tried the script, only problem is I ran into an instance where the script succeeded but by the time I passed onto my data flow and try to connect again the server is too busy to respond again.
Is there any way I can configure my data flow task to retry upon failure?
Dave
Hello,
I have a package that contains a loop where I have to connect to a data source via a DataReader Source component, running a different query built on the fly each time. My problem is that eventually the data flow in the loop will fail because it cannot connect to the data source...
Hello,
I am getting data from a remote source via an odbc driver in a DataReader Source. I am limited to selecting 2000 records at a time but need to select many more on a regular basis. The recommended way of getting around this is querying once to get the ID numbers that I need (I can do an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.