I still use DTS to copy the data from Sage into copies of the Sage tables that I created.

It does import all the records though but I am using SQL...

Just a thought Hugh, you might want to try posting at http://www.sageforum.co.uk[/url]

There's quite a few guys that do Sage development hang out there and at least one of them used...

Hi Hugh,

I ran out of time trying to solve the problem and ended up setting up a few DTS packages to import/update SQL tables which I created as a mirror...

Thanks for the good advice guys.

Installed SP4 and querying the linked server still does not return all the rows.

I'll stick to my data driven query in DTS - seems like a cleaner solution anyway.

SP3 - I'll stick SP4 on there and see if it makes a difference!

Thanks Ian, Sage's ODBC has always been a bit quirky and from what I've read Sage blame Microsoft and Microsoft blame Sage!

I'd already tried running a data transformation task and...

Hi Brian,

I can do SELECT * FROM SAGE...STOCK and it again returns only 1983 rows. There doesn't seem to be anything in common with the records it misses out and...

Thanks for that Tim, I'll give that a go.

I've found a helpfile I had for Sage Data Objects which shows examples of code and what it can do and how...

I hadn't thought about doing an update from the Sage record as the user views it Tim, like you say it's not live but it's no more than a couple...

Hi Tim,

I need to pull out real time stock levels from Sage so I need the live link to the Sage tables rather than doing a DTS update or import....

Tim have you ever tried setting up a linked server in SQL server to Line 50?

I'm toying with an Access front end which needs linked tables to both Line 50...

If Line 100 has ODBC drivers you could try a DTS package?