DTS Package -- Error on saving

[GRHE]

hi

for some reason whenever I try and save a DTS package I keep getting a Package Error.

[ODBC SQL Server Driver][SQL Server]Error converting data type varcahr to datetime

And I don't have dates mentioned in the package??

 

[schu]

When you mean saving the package do you mean, you can open it but when you close it the error appear? Or do you mean when you exceute the DTS.

Also what is your source and destination?

 

[GRHE]

Yes, I can open it but when I save, it locks up or I get that error.

I have checked the source & destination and both are correct?

 

[schu]

I have been trying to simulate what you have done and to no success. I have been using DTS for the past three months migrating our old system to SQL and no problems.

I tried changing a date to string the placing invalid characters into a string and then opening my DTS package, and closing (no errors, errors only appear when I run the package).

maybe a few more details, e.g. is the source a SQL table, access table, excel etc, what is the destination, are you using meta dat etc.

 

[GRHE]

thanx schu for your help

it happens even when I try to save a blank package - ie.

select new package

Package - save -- error datetime!!!!! weird I say