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 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...
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
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...
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...
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.