February 1, 2006 at 9:37 am
i think i may be the biggest idot here.. for the life of me i cant get a simple SSIS package to work.
i am trying to do a "Objects Transfer" from a 2000 box to 2005. i am getting errors of tables not there, or i dont have rights ( i am logged in as SA on the destination) or a FK table constraint "IS NOT" a constraint...
is there a idot guide for SSIS ..
i have about 25 DTS packages to migrate ...
SSIS error message
Error: 0xC002F325 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: Execution failed with the following error: "ERROR : errorCode=0 description='FK_MoreBDRInformation_dbo_BatchDataReports' is not a constraint. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".
source Server DB sysobjects table record
name id xtype uid info status base_schema_ver replinfo parent_obj crdate ftcatid schema_ver stats_schema_ver type userstat sysstat indexdel refdate version deltrig instrig updtrig seltrig category cache
FK_MoreBDRInformation_dbo_BatchDataReports 1618573300 F 1 0 0 0 0 86043838 2006-01-31 12:35:41.530 0 0 0 F 0 11 0 2006-01-31 12:35:41.530 0 0 0 0 0 0 0
HELP !!!
February 2, 2006 at 11:41 am
There is a new book out, see the link in my signature.
Also, what are you trying to accomplish? If you are just trying to migrate a database over to 2005, you can just do a restore which will be easier.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply