How to generating Unique keys on the basis of multiple column in ssis
Hi,
I have one table in SQL where data coming from source oracle.
Itmkey is not there in source and it have identity constraint

CREATE TABLE [dbo].[Itm](
[ItmKey] [int] IDENTITY(1,1) NOT NULL,
[CustId] [int] NOT NULL,
[CustNm] [nvarchar](100) NOT NULL,
[PartNm] [nvarchar](100) NOT NULL,
[ItmId] [nvarchar](100) NOT NULL,
[ItmTyp] [nvarchar](50) NOT NULL

)

GO
Below are the index created on the table
CREATE UNIQUE NONCLUSTERED INDEX [XAK1Itm] ON [dbo].[Itm]
(
[CustId] ASC,
[PartNm] ASC,
[ItmId] ASC,
[ItmTyp] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

my requirement is that I have to truncate and load every time when my package run.
kindly find the attachment of above table data. I don't understand how ITMKey are generating uniquely.
kindly help me to understand the above concern
August 20th, 2015 3:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics