SQL Server BIDS primary key column

Question

In BIDS I have an excel source and an OLE Database destination. However, in my OLE database I have a primary key id field which is not mapped to from my excel source. How do I create values to be inserted to my primary key id field?

I have never used BIDS before so if you need any other information, or a better explanation just let me know :)

Thanks!

Please use the `sql-server` tag (not a separate `sql` and a `server`) - also, with `sql-server`, `database` and `microsoft` are really totally redundant and don't add any additional value - skip those. — marc_s, Jun 07 '12 at 18:23
Is SQL Server your OLE DB? Put the Excel data in there first to at least create a primary key an verify the data. Then go from there to the BI. — JeffO, Jun 07 '12 at 18:35

score 1 · Accepted Answer · answered Jun 07 '12 at 18:22

1

If your primary key column is an IDENTITY, then it will populate automatically if you do not specify a value

answered Jun 07 '12 at 18:22

msmucker0527

5,164
2
22
36

How do I make it an IDENTITY in BIDS? – CodeKingPlusPlus Jun 07 '12 at 18:24
You would have to make it an IDENTITY through Management Studio or a similar solution, unless you are creating the table through BIDS... in which case you can click the "New..." button when creating your OLEDB destination table and specify IDENTITY(1,1) (e.g. TableID INT IDENTITY(1,1)) – msmucker0527 Jun 07 '12 at 19:40

score 0 · Answer 2 · answered Jun 07 '12 at 18:42

0

In your OLEDB Destination once you select the table or view to which to load the data from excel source -> move to the column mapping tab where you can actually MAP the column as per your requirement.

answered Jun 07 '12 at 18:42

Rahul

76,197
13
71
125

SQL Server BIDS primary key column

2 Answers2