Hi All,

Please help me with your suggestions for my above request to find a best way to do data migration.

Is Checksum helpful to validata data?

Thanks in advance.

Thanks for your suggestions.

I would like to try out the linked server option and have queries to do some comparison of tables. Could you please share any ideas on...

Thanks Koen. I am planning to use the dtutil utility to deploy to file system and dtExec to execute the packages.

By the way, would there be any issues if I...

Hi Koen,

Just an update from myside.

I have seen a different behaviour when using ADO.NET source rather than OLE DB source in SSIS and the data with Japanese character from...

Koen Verbeeck (6/17/2014)

---

Suresh Arumugam (6/17/2014)

---

I have so far tried with 50222 and 932 code pages for OLE DB Source and still see the junk data issue.

Thank you for taking...

I have so far tried with 50222 and 932 code pages for OLE DB Source and still see the junk data issue.

Thank you for taking time to help me.

Hi Koen,

SSIS OLE DB Source by default has taken the data type as DT_STR which I did not change. I have tried with AlwaysUseDefaultCodePage property also TRUE. Still the OLD...

Thanks All.

We are trying to create migration package by using import wizard in SSMS. I am yet to explore the possibilities of editing & deploying the created packages in different...

Hi All,

Can any one please share your experience or thoughts for my above query?

Thanks.

Thanks Grant for your valuable comment.

SO, do you mean that even if there are 500 tables in Sybase, we need to manually add source and destination data flow tasks in...

Hi Vijay,

The team is thinking of avoiding any intermediate files like CSV etc which can not be avoided when using BCP for data migration. Let me know your thoughts also.

Also,...

Thanks Vijay. Let me work with the team on your points and get back to in case of any queries.

Regards,

Suresh

Thanks Gail.

I had a high level look at your posts and they look very promising. I am going to work on your steps to have a hands on.

Thanks...

Thanks for the quick response Anthony. I am changing my queries...

ok. I wil test that option.

Thanks for your time Koen.

Regards,

Suresh