<div>
The error above is followed by: &quot;Error calling OpenRowSet on the provider&quot; just btw.
</div>


The error above is followed by: "Error calling OpenRowSet on the provider" just btw.

<div>
Can you open a new DTS package and create a connection to the 6.5 server without problems? &nbsp;The ability of DTS to transfer objects usually sucks and doesn't work very well....
</div>


Can you open a new DTS package and create a connection to the 6.5 server without problems?  The ability of DTS to transfer objects usually sucks and doesn't work very well....

<div>
Yup, I transferred about 12 databases (to/from the same servers) without any problems. &nbsp;It's just this last one...
</div>


Yup, I transferred about 12 databases (to/from the same servers) without any problems.  It's just this last one...

<div>
checkdb found a couple errors in the table but DTS still complains. &nbsp;It's only this last database so I'll either use a query or write a quickie program to port the data. &nbsp;Thanks!
</div>


checkdb found a couple errors in the table but DTS still complains.  It's only this last database so I'll either use a query or write a quickie program to port the data.  Thanks!

<div>
Sorry 'bout the errors. &nbsp;You working on getting everything off the 6.5server?<br />
<br />

</div>


Sorry 'bout the errors.  You working on getting everything off the 6.5server?



<div>
<div class="content wysiwyg-content">
I'm using the DTS Import/Export wizard to transfer data from an SQL6.5 server to an SQL 2000 server. &nbsp;I've transferred almost all of the tables without error except for one. &nbsp;I use all basic options with no data transformation. &nbsp;I get this error at the 'Select Source Tables and Views' page. &nbsp;I select all and hit next, then get the error. &nbsp;Anybody know where to look? &nbsp;The MS KBase doesn't seem to have any specific info on the error.<br />
<br />
Thanks!<br />

</div>
</div>


I'm using the DTS Import/Export wizard to transfer data from an SQL6.5 server to an SQL 2000 server.  I've transferred almost all of the tables without error except for one.  I use all basic options with no data transformation.  I get this error at the 'Select Source Tables and Views' page.  I select all and hit next, then get the error.  Anybody know where to look?  The MS KBase doesn't seem to have any specific info on the error.

Thanks!


DTS: Protocol error in DTS stream

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.