September 26, 2007 at 3:09 am
We have an AS400 at work and we have created DTS packages to connect to this (using a linked server connection) and create reports by retrieving data and putting it into spreadsheets and emailing to the various recipients.
The problem is, the connection seems to be very slow. One query to get sales stats takes over an hour to run, whereas the same query, run in an AS400 query window with a direct connection to AS400, runs in less than 3 minutes. Of course the direct connection route does not open excel and output the data and send it off, but that is why we created the DTS package in the first place...so it is automated.
The Linked Server options are
Provider String = MSDASQL
Provider Name = Microsoft OLEDB Provider for ODBC Drivers
It just seems to be a really slow way to get data from our AS400 system.
Does anyone have any ideas on how to create a proper, speedy connection to an AS400 from SQL Server 2000?
Thx for your help
September 26, 2007 at 9:41 pm
I grab lots of stuff from an AS400, but dont use a linked server. Install the client access driver on your server, create an ODBC connection and pump it that way... see if that makes it quicker.
Cheers, hope it helps.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply