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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy