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,...

Did you check out the HTTP Connection Manager and, if so, what were your findings?

Deepthy (9/28/2010)

---

Hi all,

I am new to SSIS Please bare with me.

Here is my scenario.

I have two tables TableA and referetable TableB

create table tablea ( country varchar(100),city varchar(100),clean_city varchar (100))

Create table...

One day a German beer, then a Belgian one, then Czech, ......

Raunak Jhawar (9/24/2010)

---

da-zero (9/24/2010)

---

Or, just to add another option:

1. Add a script task.

2. In the script, create a directoryinfo on the directory. (let's name it di)

3. Use the getfiles method:...

I think that there is another option: store your incrementing values in a database table. Your package just needs to read/increment as necessary - then you get the data persistence...

delete a

from TableA a join TableB b

on a.ID = b.ID

deletes rows from table A which have matching records (by ID) in table B.

Are the tabs in the source SQL data, or are they being added on the way to the output file?