DTS for Import Data

#1

I used DTS to import data from our production server to our test server. DTS
informed me that it was successful. No data was imported. When I looked at
the log it told me:

::Error::
In file in statement on line 0
Transfer Status: Transferring Data: (Table '[dbo].[CATEGORY]')
[Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver version mismatch

With this kind of an error why does DTS report success? I am using SQL 2000
with the latest updates.

Now to figure out what caused this error?

Thanks
Tom G.

#2

Are you using the Transfer Objects task?
Are both sides of the transfer on the same version of MDAC.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Tom Groszko" <newscorrespondent (AT) charter (DOT) net> wrote

Quote:

I used DTS to import data from our production server to our test server.
DTS
informed me that it was successful. No data was imported. When I looked at
the log it told me:

::Error::
In file in statement on line 0
Transfer Status: Transferring Data: (Table '[dbo].[CATEGORY]')
[Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver version mismatch

With this kind of an error why does DTS report success? I am using SQL
2000
with the latest updates.

Now to figure out what caused this error?

Thanks
Tom G.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS for Import Data

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS for Import Data - 02-17-2004 , 11:54 AM

Re: DTS for Import Data - 02-19-2004 , 01:06 AM