That did not work for me.

So what I finally did for a csv source to Table. I added a data convesion task and the one coulum which was a headache,...

Hey Paul,

thanks a bunch. I will try and let you know how it comes up.

Regards,

So would some one a guru of SSIS will be able to rescue us out and the nation. Please do share your success experience and expertise achieved over the years.

sometimes...

I applied this solution but it keeps on changing the warning from souce to destination and back and forth.

Here is my issue and it just keep on torturing me.

My source...

Dear folks,

Thank you very much for replying so quickly to help me out. Reply to your assumptions. I am not doing anything. If you read my message carefully I said,...

well it is the same question, same issue and I have just added that I have tried all of the above still no success.

I can still post new but then...

for me, it is still a mystery even after all the suggestions.

I have 3 SQL 2005 Servers, one with SP2, 2nd and 3rd with SP3 and I see that table...