May 6, 2002 at 12:53 pm
I am trying to import Data from an old table to an new table. But I create an new PK in the new table(int), the old table's PK just become one the columns in the new table. When I import data from the old to the new table. I have one extra PK column in the new table, which has nothing to import from the old table. SQL did not let me import data since the new PK can not be NULL. I am wondering if I can let SQL create PK value when I am importing the Data from the old table to the new table? Or there are some other ways to do it? Any suggestion or idea? Thanks alot
May 6, 2002 at 1:56 pm
I'd say if you could do this anywhere it would be in your transformation. You may have to customize the actual VB script to do this though. I'd check my help on transformations.
May 6, 2002 at 7:19 pm
Make it an IDENTITY field and it should work.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply