December 15, 2008 at 5:09 am
Hi guys,
I created a package from the import/export wizard and the first step is to drop multiple tables.
I keep getting the following error no matter what I try, however, if I run the SQL in a query window it works absolutely fine?
[Execute SQL Task] Attempted to read or write protected memory. This is often an indication that other memory is corrupt.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Appreciate any thoughts.
Thanks.
December 15, 2008 at 4:27 pm
Does anyone have a view on this?
Many thanks!
December 16, 2008 at 3:23 am
Most likely, you didn't set the connection for the task.
December 16, 2008 at 4:09 am
This was completed through the wizard so the connection was set fine.
December 16, 2008 at 7:58 am
Have you saved the package? Can you attach the package to the thread?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply