I am new to SSIS. i am trying to port database from SQL SERVER 2000 to 2005. i am using "Transfer SQL Server Objects" for this. i am just trying to move one object for testing wether it works or not. and it is not working. i am getting this error.
[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80040E37. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E37 Description: "Invalid object name 'dbo.consta_AE'.". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".
Both DBs are on seprate machines. of you need any more info please let me know. that would be great help.
Thanks
Tha error means that the object 'Consta_AE' is not found in the database pointed by 'Microsoft SQL Native client'; make sure the connecion manager is pointing to the right Server and DB; also check that the object being called ' Consta_AE' exists under the schema 'dbo', otherwise provide the right schema name.|||Hi thanks for you response. problem is i have checked all these things. connections is pointing towrods right DB and object exist with dbo scheme in the right DB. but both DB are on the different machines and i am working on the third one. does this make any difference. and do i need any special permissions to do this. .|||Make sure the user you are running the package under has permission to connect to that SQL Server and can see that table/object.
What type of connection are you using in the package to connect to those server? did you test them within BIDS?
|||Yes i have tested these connections with BIDS. these connection i have created from the Data transform object control. yes i do have permissions and i have also created a package from import export wizard and it works fine.
Thanks
|||Haroon,What version of SQL Server are you using? RTM? SP1? SP2?
I almost wonder if the Transfer Objects Task isn't trying to copy things in the wrong order... That is, maybe it's trying to copy a view that references the table that doesn't exist (yet.)
What settings do you have for:
CopySchema IncludeDependentObjects CopyAllObjects
|||
Hi
SQL version is
9.00.2047.00
SP1
Standard Edition
i am just trying to copy only one table object for testing . which is not working .
setting which i have are.
DropObjectFirst True
IncludeDependentObject False
CopySchema False
CopyAllObjects False
and i am just copying one object from tables and everything else in there is also false
Thanks,
|||Try setting the CopySchema property to true.
~Matt
