Greetings. SQL2K5 sp3
I have an Execute SQL Task in an SSIS Package that inserts 154K records from a .txt file. In the future these will have both Inserts and Updates, so changing to a Bulk Insert, etc. is not pssible.
" failed with the following error: "There
to run this query.".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."
I can pull the first 2000 Inserts out of the file and run with no issue in either Mgmt Studio, or a different Execute SQL Task, but attempting all of these causes this issue.