Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I retry a data flow task when connection fails
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...- dmusson17
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Process X number of records at a time in SSIS
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...- dmusson17
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Integration Services (SSIS)
