Then what is the purpose of using OLE DB transformation as it causes performance issue when we have execute sql task.

why should not use OLEDB cmd since its processing each row..or any other specific reason is there?

Thank you for your responses..

sorry for typo..wise which means performance point of..

Hey Blasto,

Yup..I provided the same answer what you have provided here as I have enough 3 years of exp in T-SQL:).I blabbered some thing like improving performance by adding indexes,setting...

Hi Craig,

Thanks for your quick response on this.I understood it was question to check how much I am strong in that.But honestly speaking I don't have experience in ssis but...

Hi Everyone,

I got a solution for the below issues.Yes there was issues in adding references.

That has been resolved.

Regards,

Sharmi