The exact error message I am getting is :
"Error at destination for row no. 968.Errors encountered in this task so
far:1. The atatement ahs been terminated.Violation of PRIMARY KEY constraint
PK_New09#05$.Cannot insert duplicate key in 'InternalLogs'."
Any help is appreciated.
Thanks
--
pmud
[quoted text, click to view] "pmud" wrote:
> Hi,
>
> I am trting to import data from many spreadheets. The first column in the
> sheets is the serial No. So, after importing the data from teh first
> workbook, I made the first column as Auto-incrementing and also made it the
> primary key, so that we didnt have the same No for different rows.
>
> But now when I try to import the data from the secong workbook, i get
> message, " Cannot insert duplicate data into the primary key."
>
> How can i make the first column an auto incrementing column in the db so
> that every time i import many rows of data ,the first column in auto
> incremented..
>
> Please help.
>
> Thanks
> --
[quoted text, click to view] "pmud" wrote:
> Hi,
>
> I am trting to import data from many spreadheets. The first column in the
> sheets is the serial No. So, after importing the data from teh first
> workbook, I made the first column as Auto-incrementing and also made it the
> primary key, so that we didnt have the same No for different rows.
>
> But now when I try to import the data from the secong workbook, i get
> message, " Cannot insert duplicate data into the primary key."
>
> How can i make the first column an auto incrementing column in the db so
> that every time i import many rows of data ,the first column in auto
> incremented..
>
> Please help.
>
> Thanks
> --
> pmud
increment your numbers in your spreadsheets. Then use "transform data task"
in dts package to import.
