Hi Vika,

I'm trying to convert ActiveX Script listed below to Script Task in SQL 2005 but get the same error. Can you please show how would you convert this ActiveX...

Hi Dan,

I have attached a snapshot of DTS package.

Thanks

Boy

Thanks Dan.

Yes. What the DTS doing is, before inserting data, it's Execute SQL Task that is used to truncate table, then ActiveX script task runs some SQLs and ...

Hi Dan,

I tried converting the above ActiveX script using Variables and Expressions, but unfortunately not luck :crying:. I have reviewed the juspstarttv.com but the demos there are for simple tasks....

Yes Dan it certainly has been a problem moving from DTS to SSIS.

I will certainly visit the site you have listed.

Thanks

Boy

Thanks so much again Dan.

To me it is like finding a needle in the dark :crying:.

It is a very valuable information you have provided me with. Atleast now I...

Thanks Dan for your prompt response.

But can you please let me know what are the alternatives do I have since I can't use ActiveX anymore?

Is there any Tasks I...

This is how you can check why the jobs failed.

SQL 2000

Enterprise manager-->management-->SQL Server Agent-->Jobs

SQL 2005

SSMS-->SQL Server Agent-->Expand Jobs

Learning never ends!:P