Chuck, I tried the conditional split transform and its working good in splitting the data set.

One thing I noticed is, I was able to set condition only on some...

Thanks Chuck. Let me give a try and see.

I agree to your point Chuck. But I also want invalid records which I'm going to publish to a flat file.

Thanks for the response. The main purpose of placing result set in Object type variable is to do some data validation. I want to populate the same data again into...

Thanks to both for the reply. I would try the options and let you know if I have any problem.

Thanks,

-Amith Vemuganti

OK....I would try it and see.

Thanks,

Amith Vemuganti

Hi Dinesh,

Thanks for the reply. The sequence number is basically to uniquely identify the file if multiple files have to be generated, because the string to which the digit is...

I gave all the details username, password, and Data Source when it said Test Connection Success.

Thanks,

-Amith Vemuganti

Thanks a lot for the valuable information.

Regards,

Amith

Thanks a lot for the information.

Thanks for the reply. I have gone through the links and they are very informative. I'm also just wondering if there is any link where I can find the details...