Post reply

importing problems

  • July 16, 2008 at 3:34 pm

    #123221

    hello

    here is the scenario. I have a table which has three columns. One of them is the primary key which already has data. the other two are null columns. When i am trying to import the data for the null columns from oracle 9i database to the sql server database. It says that cannot insert null values in the primary key column. When infact it already has values. What should i do.

    Please help

    thanks

  • July 16, 2008 at 4:40 pm

    #844096

    Hi,

    There could be problem with the mapping between sorce to destination, or if source primary key column is an identity column then, you need to select identity insert on in data flow task. You can put a data viewer in between sorce and destination to see what data coming in...

    -V

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply