Thanks everyone for such a hand full of help.

Let me try them.

Thanks

Munna

Thanks so much for such a great detailed answer.

When I creat a variable "sSQLString", should I leave the DataType as default and Value as well?

Thanks

Munna

Thanks. This was really helpful. Actually I'm migrating my DTS package to SSIS 2005. The DTS performs the following tasks:

It Truncates table using Execute SQL task, then in ActiveX task...

Thanks everyone for your helpful advices.

Munnabhai

Yes Phil,

Certainly it hasn't work at all. But I'm wondering if there is an ActiveX task in SSIS for backward compatibility, why it would throw an error. Error like "Function...