What about if I change the above to

Yesterday midnight:

DATEADD("Day", -1,(DT_DBDATE)DATEDIFF("Day", (DT_DBDATE) 0, GETDATE()))

: 10/10/2011 12:00:00 AM

Day before yesterday midnight:

DATEADD("Day", -2,(DT_DBDATE)DATEDIFF("Day", (DT_DBDATE) 0, GETDATE()))

:10/9/2011 12:00:00 AM

Thanks

Sorry for the late reply. But, very thankful to your advice.

Thank you so much for your responses. I have tried group by but, I need duplicate values (but not vchName) as I am trying fuzzy lookup manually (as existing direct...

Excellent. I am very thankful to your response. I will try that.

Thank you so much for your reply. It seems I missed lot of data. Let me add all and try again.

Thank you.

I found the solution by specifically declaring the connection as below:

Dim sqlConn As New SqlConnection("server=sqldev01.lac.authenticom.com;uid=Authencustomer;pwd=Test1234;database=AUTHENCustomer")

Thanks

It didn't work. As I am new to SSIS, don't know where to look for log information.

Thanks a lot.

It didn't work. As I am new to SSIS, no idea where to look for log information.

Thanks a lot.

Sorry to say, no use. May be it is connection problem.

Thank you

Thank you so much for the quick responses. I have followed the link and everyhting looks similar except the connection string. The finalized code is here for your review:

...

I have tried that syntax also. No syntax error. Same task error but no description.

Thank you.

Thank you Vishal. But, I have added that also. Even in the begining only, now added 'MessageBox.Show("Start query")'. It is not displaying thi smessage even. Thank you for your help.

Thank you for the responces. I have deleted and re attached the link. It is working fine now.

I hope you are missing the data conversions.

Great, it worked. Thank you.