If you have both SQL 2000 and SQL 2005 installed (as I have) you might be running the SQL 2000 bcp. Try typing bcp /? and see if -x appears...

One isue that I know of is the midnight is 24:00:00 in Oracle and 00:00:00 in SQL Server. This can lead to dates being off by one day if only...

Does SQL 2K have to be thr default instance or can it be a named instance?

Just to finish this off, here is the final result.

"C:\\Data\\SSIS\\AlarmSummary_"  + (DT_WSTR,4)DatePart("yyyy", GetDate()) + "-" + (DT_WSTR,2)DatePart("mm", GetDate()) + "-" + (DT_WSTR,2)DatePart("dd", GetDate()) + "_" + (DT_WSTR,2)DatePart("Hh", GetDate()) + "_"...

I think that the probelm is the you can only use limited TSQL in the expression. If Cast() doesn't work I doubt that Convert(0 would work either.

Thanks for the reply.

I don't how releveant this is but I have SQL 2000 and the default instance on my PC and SQL 2005 as a named instance ("SQL2005" funnily enough) and both...

Thanks,

When you say that you restored the database, I assume that you mean the application database not the distribution database. correct?

I am leaning towards using the script myself. Did you...