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