Friday, March 9, 2012

Error. doesnt make sense. HELP!

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

No comments:

Post a Comment