My use of Except, Intersect is to prepare a slowly changing dimension table as written below. This will help me to get the changed address as well as new...

Hi,

If this answer is not related to your requirements, pls ignore.

I guess your SSIS package is for a regular uploads/data feeds to some system. There is nothing wrong in going...

I just want to take it out and insert into DB2 table.

Char will perfom in its best at sinlgle character length and the best practice is to use char for fixed length string instead of varchar. If i were u I...

What advantage we will if the shrink database option is enabled? Will you please explain?

Hi,

This is just a frame giving you.. I may be wrong in the way of logic and the way of doing.. You develop further using currect sintax. I am using...

You can use : SELECT * FROM TABLENAME WHERE DATE = '01 Jan 2005'

it will return satisifing records. But while inserting/updating from client programs using native languages, you should take...

Thanks for your comments,

I can execute the statement in Query Analyzer and even open recordset. But I am getting the error only while looping through the records. And the error...

Thanks. It is working.

Thanks Remi Gregoire. It is working. But shall I know why my code is returning error even after opening the recordset. Also, I don't have zeros in my table.

Regards,

Ragesh