March 6, 2009 at 1:02 am
Hi all,
I need to do a "simple" thing. I need to transfer some data from a local SQL Server 2005 to an external SQL Server 2000. I created a simple SSIS package which worked like a charm. On my own computer... However when I moved it to the server it refused to work, due to user dredential issues (it seems like the company hosting our external server are very restrictive of which IP-addresses are allowed to access the external DB and they won't budge.
Anyway, I then decided to work with Linked Servers. Quickly ran into a problem working from our Local Server (SQL Server 2005) since not all SP's and patches seems to have been installed on our External Server (SQL Server 2000).
But we have another server running SQL Server 2000, so I linked both our local and external server from there and manage to both read and write from/to both.
But here comes my real problem. It's sooo slow doing INSERT commands on our external server.
I'm just doing a simple command like:
INSERT INTO [GLOBAL_SERVER]
([field1]
,[field2]
,[field3])
SELECT
[field1]
,[field2]
,[field3]
FROM
[LOCAL_SERVER]
WHERE
[SIMPLE WHERE CLAUSE]
It's about 16.000 rows that needs to be inserted and this took less than 1 second with the SSIS but with this solution it takes more than 20 minutes!!!
Does anyone have any idea how I can speed things up?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply