Hi,

I am also facing this same problem.

Executed as user: NA\svc-sqlinst30-clst22. ...3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:40:02 PM...

Hi,

Thanks the alternate method worked

Thanks

Raju

hi,

This is line 13

DTSDestination("Failure_PO_Create_Date") = Replace( convert(varchar(11),DTSSource("po_create_date") ) )

My main problem is that datatype is diffrent in the 2 tables.

po_create_date is varchar(11) and Failure_PO_Create_date is smalldattime.

Thanks

Raju