I copied the url

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15217&FORUM_ID=19&CAT_ID=3&Forum_Title=Data+Transformation+Services+%28DTS%29&Topic_Title=Scripting+a+DTS+package

Maybe that will help.

Richard

How about just backing up msdb.

Or to be more selective you could perhaps look at the recent discussion thread with the title "Scripting a DTS package" started by drewj840 on...

Thanks 5'

We'll take a look at that url. Currently we are sending Microsoft a collection of different profile logs, event logs and anything else that looks like it may help...

We use sp_OADestroy to release to objects.

We alos have not noticed anything interetsing in the Event Log - but will look again. The error Brian pointed me to was...

Sorry - I don't wish to side track the problem with my ignorance but ... 😉

How about if the destination column for the import is a varchar or char column...

We do this sort of thing reasonably often and I agree with Frank that using DTS is the way to go.

WOuld something like this

Case When isdate(DateCol) = 1 then DateCol else Null end

work in a DTS extract?

Try http://www.q4bis.com. It may not be free but (as the sales guys say) it's good value. Sells in Europe, USA and Australia/NZ.

This teaches me to test a lot more before going public. The above didn't really work but this version does (I think).

if exists (select name from sysobjects where name...

I've knocked together this short script that I run from Master. Forgive any scripting stupidity - I'm not a DBA - but I think you get the general approach....

It appears that once detached the db is no longer know to SQL Server (or at least it looks that way to me). I'm taking the sledge hammer approach...

Sorry - should have said SQL2000

- Richard