hi i find that my Server with SQL Server 2000 always has very high Average Disk Queue Length..............it is over 50 and sometimes over 100. So...
I mean in SQL Server 2000, the same driver does not support Oracle new datatype "date with timezone".(I m not sure the actual name in Oracle)....
as subject many thanks, Linus
Hi all, I face a problem as below: our SQL Server daily has a job to delete 2M records in a table of 13M records. It takes quite long time to do...
Hi, I have a problem as below: everyday, our SQL Server need to download about 2M records from a Oracle Server. Therefore, I have built a DTS to...
Error when executing the SSIS in Visual Studio 2005 The AcquireConnection method call to the connection manager "EDR_Prod" failed with error code...
What is the different between -A table or view. -A table or view using fast-load options. for OLE DB destination
where can i set the permission for that?
Hi, I have a table in Oracle 8 and a table in SQL Server 2005 with the same schema. I have created a SSIS to pull data (2 million rows) from the...
Hi All, I encounter the following problem : I create a SSIS in VS2005, it can run successfully in there. then i save the package into Server, and...
is it meant that i should use -b to boost up the performance? Now the destination table is with no index
hi , i also want to know why this bcp action takes so much time for inserting the last few thousand records? it stops at 1000 rows sent to SQL...
i think about 1.2M
another question..........how to delete data much more efficiency from this 217489811 rows table
thanks for you advice.............finally it takes 3 hours to complete the job...........maybe the destination table has index.......i forget to drop...
it seems that the performance does not boost up a lot.............it takes around 3 hours to import 15M data into the table...............however,...
SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]I/O error while writing BCP data-file do you know what is the problem?...
my DB recovery mode is set to simple, so how comes the log will grow up? BTW, 1. BCP utility means everything is copied to text file and then...
Hi, I am facing a great problem. I have a DB about 80GB. There are 217489811 number of records which include 2005, 2006 and 2007 data in 1 table....
Separate names with a comma.
