November 4, 2009 at 11:50 pm
i face a problem when importing tables from my peer.
the problem is when i am importing tables the destination table doesn't allow identity insert.
i.e one table say customer has a identity column customer id in source table but when importing from this database to my database the destination table doesn't allow inserting the identity property . so whenever i execute insert stmnt. on this table it give me an error .
Also i want to also import stored Procedure is it possible ?
November 5, 2009 at 12:14 am
Save the package out then you can edit the destination so that it handles identities.
Sprocs are a different matter, you have to use a transfer objects object is SSIS to do that, or just script it out by hand and apply it to your server..
CEWII
November 5, 2009 at 12:34 am
when you do import export from database to other and table is having identity column then a step where you select source and destination table there you have edit mapping button click over it and you will find enabel indentity insert check box ,please check the box and try to do it again
hope this will the problem
regards
Ramu
November 5, 2009 at 12:35 am
when you do import export from database to other and table is having identity column then a step where you select source and destination table there you have edit mapping button click over it and you will find enabel indentity insert check box ,please check the box and try to do it again
hope this will solve the problem
regards
Ramu
November 5, 2009 at 1:34 am
i tried that(Select check box insert identity) as well but still prob remains
actually when i saw the SQL of Destination table there isn't constarint of identity(1,1) for the identity column
thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply