Tnx for answering, David. One learns everyday.

Tnx Steve,

I followed your suggestion and found the difference. It turned out the spaces in the @provider name where removed...

Funny though, that in EM the name was WITH the spaces...

Thanks for the feedback all.

Micheal, I think I will look-in to your suggestion. I have seen that construction bhefore and this would very well do the trick.

Thanks again all.

I know the Dynamic Props Task.

Basically I am trying to create a loggingmechanism in a DTS-package. There are several tasks: ActiveX, ExecuteSQL and Datapump. When a tasks fails, a...

Tnx, why did I not think of that;-)

I forgot to ask: can I ASSIGN a value to a glovar in T-SQL? I can do it in ActiveX, but it would...

Gila, tnx for answering. This seems to work. I am a bit amazed, for I thought I had tried this and found it not working. Now it does work...

I must...

You are right, I forgot something in Table1:

CREATE Table Table1(

CustID   INT,

CNr  INT)

There are more datafields, but for what I need they're not necessary to get the data I need.

There is...

Tnx for all the input,ppl. I have found a peice of VBscript, which does what I need and which I can easily adapt to my circumstances.

Much obliged.

I've found what the problem is. In T-SQL the value 20051201 ias recognized as a valid date. For whatever reason, when the Data Transformation task in DTS is executed, this...

The query consisted, among others, of an outer join construction, to get data not existing yet. The script is quite large and it so happened, that a restriction was aplied...

I think I have found what is wrong.

Tnx for answering everyone.

Tnx for responding, I have done just that: removed the primkey and ran the package. Then I checked, and a few records, less than 10, hasd duplicates. Again, the corresponding...

Tnx for the response.

I am doing this on an empty table. There were DATETIME columns involved; on your posting I removed them from the Task and ran the package again,...

Tnx for the responses. Maybe I should have elaborate before:

I do not use the previewbutton, I copy the SQL(SELECT * FROM TABLE)  to QA and run it. There are NO...

Tnx for the info, Crishell, this sounds interesting, preferable to a change Data TransformationTask with ActiveXscript. I will look into this, if MS does not come up with a solution.

It...