Viewing 4 posts - 1 through 4 (of 4 total)
Experimenting with different options... if I change the Data access mode in the OLE DB Destination to "Table or view" instead of "Table or view- fast load" it does load...
June 9, 2020 at 6:11 pm
The source is SQL 2012, and the destination that is having trouble is SQL 2005.
As a test, I have re-pointed the package to another SQL 2012 server, and it succeeds...
June 9, 2020 at 5:31 pm
It's just a straight source -> destination task. If I add " top 25" to the query, it succeeds. It only hangs when the row count increases.
June 9, 2020 at 2:41 pm
I have run it via debug, as well as via a sql agent job. Same results.. Never errors, never completes.
June 9, 2020 at 1:42 pm
Viewing 4 posts - 1 through 4 (of 4 total)