Have a look here and see how you get on.

Are you running on a 64-bit server? If so, have you tried running the package in 32-bit mode to see whether that fixes your problem?

Are you saying that you are getting an error before the script task even executes and that that is why your breakpoint is not being hit?

It would help if you...

I see. No, you need to use variable mappings to get the array members into a string variable.

But then you can directly execute the contents of the string variable in...

Is the requirement exactly the same for each server?

Is the schema exactly the same for each server?

If so, you can execute the same process over and over again, against the...

OK, I've just mocked this up and it works.

First, I have two package-scoped variables:

DropTablesSQL - object

strSQL - string

Next, a script task with DropTablesSQL in ReadWrite variables:

Public...

Going back to my suggested method, can you confirm that you had configured the variable mappings page for the FEL?

The datatype of your array variable needs to be Object.

Once it has been populated, you can feed it into a Foreach loop.

Change the enumerator to 'Foreach From Variable'. The...

What is the data type of dropTablesSQL?

Please post the error message.

I second Alvin. You're going to have to build in a lot of logic rules and what-ifs to make that work.

Not easily. Rewrite in 2005 and deploy, or upgrade server to 2008 and deploy.

Have you got an instance of SS2005 running on the machine you are deploying to?

Check for the existence of multiple dtexec.exe files on the deployment machine.

19th Century?:w00t:

Your very first post used 30-DEC-99 as an example, so it's not surprising that some confusion was caused.

You might find something interesting in this thread.

jango_41 (9/27/2010)

---

Dear joyfull All,

when a trigger is to be defined in c#, you must define something like :

[Microsoft.SqlServer.Server.SqlTrigger(Name = "UpdateAddressChangeLogADDRESS", Target = "ADDRESS", Event = "FOR UPDATE")]

I may be wrong,...