Thanks Koen. That's a good point. I will try to add the top portion through script and use the Flat File destination option

to add the below Item details.

By the...

GUYS, Please help me to get my above request solved.

Thanks in advance,

Regards,

Suresh

DiverKas (6/21/2012)

Suresh Kumar-284278 (6/21/2012)

I am currently working for retail client and primarily on SQL 2008 DB designs though their applications are spread across 3 different DBs (SQL Server 2008, DB2,...

Thanks for the suggestion and I feel its best suitable option to me.

You guys are really helpful. Keep going.

Regards,

Suresh

Thanks All for your suggestions and sharing your prior experiences.

I am now confused that i feel we are talking about some thing other than SSIS and DB_Email options to...

Awesome responses. Thanks a lot.

By the way, I am not very familiar to Powershell and would like to stick to SSIS to generate XML file and to store it in...

Hi ucbus,

I landed in your thread when searching for a similar solution. Thanks a lot for your effort and a sample script. However, is there a easy change avaialble...

Thanks for the response.

I got it clarified that there are only 10 tables that i need to migrate from Oracle to DB2 and NOT even DATA to be migrated...

Thanks for the suggestions.

Could you please clarify how to check for the wait types? Sorry i am not sure of that.

Thanks,

Suresh

Thanks for all your replies.

few days we are not getting the deadlock issue in Production. However, we are tracking the situtation now and will get back to you.

Thanks...

Thanks a lot EralPer! I will try them out.

Thanks David!

I have decided to have integer value for the primary key and could understand the purpose of choosing integer column.

Suresh

Thanks a lot. It's Very simple and easy to understand.

Thanks all guys for your wonderful thoughts.

Just to understand the difference of using filters between "Joins" and "Where" clauses, I took "Country","Employee" tables and nothing in real picture.

Suresh

Thanks for the suggestion!

Infact, I just have completed BI Sql 2008 training to cover SSAS and SSRS and also planning to ungerdo DBA related trainings.

Suresh