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 |
|
dcobb
Yak Posting Veteran
76 Posts |
 Posted - 2005-08-23 : 11:23:22
|
| I'm trying to transfer data from one sql server to another, but define my own query (basically I don't want all of the records only certain ones) and I get the following error...Deferred prepare could not be completed.Invalid object name 'pricelist' (this is the table I'm trying to copy)Context: Error calling GetColumnInfo. Your provider does not support all the interfaces/methods required by DTS.Note: I'm running this on the destination server and the table already exists, so I'm only trying to transfer the data.Anyone know why this is happening?TIADave |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-23 : 11:25:55
|
| not all OLEDB providers are supported by DTS. what database are you trying to work with? Are you using the latest version of the ODBC or OLE DB drivers for it?-ec |
 |
|
|
dcobb
Yak Posting Veteran
76 Posts |
Posted - 2005-08-23 : 11:29:01
|
I'm using the standard Microsoft OLE DB Provider for SQL server. Not sure which version. How can I check this?CheersDave quote:
Originally posted by eyechart
not all OLEDB providers are supported by DTS. what database are you trying to work with? Are you using the latest version of the ODBC or OLE DB drivers for it?-ec
|
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-23 : 11:35:57
|
quote:
Originally posted by dcobb
I'm using the standard Microsoft OLE DB Provider for SQL server. Not sure which version. How can I check this?
the SQL Server OLEDB provider is definitely supported. You can update the drivers by installing the latest MDAC here http://msdn.microsoft.com/data/mdac/downloads/default.aspxWhat OS are you running, what service packs for the OS and SQL?-ec |
|
|
|
dcobb
Yak Posting Veteran
76 Posts |
Posted - 2005-08-24 : 04:58:32
|
OK. The destination server is windows 2003, SQL server 2000 SP3, which has MDAC 2.8 SP2 installed.The source server is windows 2000, SQL server 2000 SP4, which I assume would be MDAC 2.8 SP2 as well.Still not sure why this is happening, anyone?Davequote:
Originally posted by eyechart
quote:
Originally posted by dcobb
I'm using the standard Microsoft OLE DB Provider for SQL server. Not sure which version. How can I check this?
the SQL Server OLEDB provider is definitely supported. You can update the drivers by installing the latest MDAC here http://msdn.microsoft.com/data/mdac/downloads/default.aspxWhat OS are you running, what service packs for the OS and SQL?-ec
|
|
|
|
|
|
|
DTS import error