Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

TransferProvider Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steven - 09 Jun 2008 14:04 GMT
I'm attempting to copy a database from one SQL Server to another, I've made
sure the versions match PERFECTLY.  9.0.3054.  (2005 SP2 with latest patch)

I get the following errors each time I try to IMPORT/EXPORT.  I can't even
find many references to the errors online, and the links in the error
message are dead when you click them.  What can I do to get this database
transferred?  I tried to backup and restore, but it seemed to reference a
drive/path that exists on the backup machine and not on the
restore/destination machine.

- Execute the transfer with the TransferProvider. (Error)

Messages

ERROR : errorCode=0 description=Transferring columns of data type
"sql_variant" is not supported. helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ERROR : errorCode=4 description=Failed to create the pipeline. helpFile=
helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ERROR : errorCode=0 description=Transferring columns of data type
"sql_variant" is not supported. helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
(Microsoft.SqlServer.DtsTransferProvider)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Thanks for any help.

Steven
jsumaraga - 01 Jul 2008 01:28 GMT
Steven,

Did you ever get an answer to this problem. I am getting the same error.

> I'm attempting to copy a database from one SQL Server to another, I've made
> sure the versions match PERFECTLY.  9.0.3054.  (2005 SP2 with latest patch)
[quoted text clipped - 34 lines]
>
> Steven
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.