I can't execute the "second one". I have two different SELECT-Statement but it always executes the first one (in Query Analyzer).

BTW: The code looks frightening

Hi,

maybe the Data Driven Query Task will do that for you. I'm not sure cause I didn't use it before.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_elemtsk1_9w2z.asp

jan

Hi,

I had a problem with that before. If you have multiple response messages in a procedure and the first one is an error, your ADODB.Command won't catch the error. So it's always a...