How do i do that?

Hi,

Thanks for replay, But will it select rows which contains only arabic record if coulmn has both arablic and english records, also it has arabic collation on that column already?

But how do i use for loop in here as for loops are not allowed in data flow task?

Hi,

Do you know any good books and sites in which i can get to learn more on SSIS as i am working on same?

Thanks a lot for this info...

Hi,

Thanks for the reply.

But I have package which is updating/inserting around 12 billion records and I want to test this package only on small records to ensure only success...

Hi,

Thanks a lot for this information, now i understud how it works. One more doubt is will data in snapshot file will be emptied after completion of snapshot restoration or...

Thanks for your reply , but they have not named DTS files liek i specified, they have such names for UDL's inside one DTS package pointing to same Database....