Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itchy
Starting Member
1 Post |
 Posted - 2011-04-13 : 04:57:05
|
| I have inherited a process which requires a nightly copy of a database from a remotely hosted Postgre server to our SQL Server database.Currently this import runs on an old Windows 2K machine which I am very keen to remove from our network and I am trying to recreate the steps on our Windows 2008 x64 machine running Sql Server 2008.I can connect to the database successfully using the psqlodbc_09_00_0200-x64 driver and run selects and inserts on some data. When I try and pull data from the largest table however (over 2 million rows) I get a SQL error:OLE DB provider "MSDASQL" for linked server "RemoteDB" returned message "Communication error while getting a tuple;Error fetching next row".Msg 7330, Level 16, State 2, Line 323Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "RemoteD".I have Allow in Process disabled as it totally refuses to run with it turned on and selecting each column individually returns all rows.It is still running fine on the Win2k server.Feels like I've hit a wall on this, can anyone help? |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-04-13 : 12:18:41
|
| http://social.msdn.microsoft.com/Forums/en/transactsql/thread/be568c5e-ba18-4a0f-b617-da56bfe46894If you don't have the passion to help people, you have no passion |
 |
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-15 : 08:47:36
|
| Write transaction to pull the data,it will increase the performance and decrease the locks on the database,Pull data 10000 records in each transaction then you will not get the error again,You should have proper ETL code,you can send it here or you can use Microsoft Integration Services also for ETL processRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA |
|
|
|
|
|
|
|
|
Linked server -> Sql 2008 / Postgre