I think somthing like this may work:

osql -E -S %server% -d %metadata% -Q "EXIT(select completed = case Completed when 'SUCCESS' then 999 else -999 end from Monitor_Progress where Thread=%thread% and...

Forgot to ask if your database has been pre-sized? You may be wasting time auto-extending?

Andy

Unless your data is sorted in clustered index order, remove your index before you load and then rebuild it.

Also, I doubt that VBScript is the quickest language to do any...

There is a problem with DTS and SP3 if you are accessing a table with a large no. of columns. There is an earlier thread covering SP3 issues.

Andy

Try the dtsrunui command. This will start a GUI that you can use to run a dts package, or, it will generate a command line for you.

Andy

I know bcp is very fussy about date formats. Try changing your date format in column 7 to

2001-08-08. I can't remember the exact format bcp requires. It may be dd/mm/yyyy...

I don't believe you can ever prevent sql writing to the log file completely. Even if you are in simple or bulk-logged mode it still writes minimal info to the...

Thanks Phil.

I don't think this is relevant to our problem as we're not using openxml rowset provider.

For info, we're on sql server 2000 sp2 (because of the published problems...

Thanks for the replies.

I was looking for a more elegant solution than the one I had (and, of course, the one that performs the best!).

I will try them out

Thanks again

...

No problems installing SP3. However, after installing, select @@version returns:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)

Dec 17 2002 14:22:05

Copyright (c) 1988-2003 Microsoft Corporation

Enterprise Edition on Windows...

Scorpion 66.

I'd like a copy of your code too if you don't mind. We're migrating 1.2TB from DB2 to SQL Server. We have 48 hours to do the initial dataload...

Scorpion 66.

I'd like a copy of your code too if you don't mind. We're migrating 1.2TB from DB2 to SQL Server. We have 48 hours to do the initial dataload...

hbkdba,

It will be a reporting/OLAP style database with about 50 users, 20 concurrent on average. Daily feeds from the production equivalent.

We are currently going through the SS2k/Oracle question too. We're looking at migrating a 1.2TB database from DB2 to SS2K or Oracle. Has anybody got any tales to tell relating...

On investigating further, its related to the "The SQL Server xxxx is not known to be running" message. For every server that I get this message , I get this...