Bulk import from MDS using SSIS

Hi

Please assist on ImportType (https://msdn.microsoft.com/en-us/library/ee633854) on MDS I can use to insert data to the <mds. stg table> without duplicating existing data?I have used 0,1,2 and all of them are giving me the same results,each time I run the SSIS package it insert new records to the table even the records that are already in the table.
devguru001DevAsked:
Who is Participating?
 
Megan BrooksConnect With a Mentor SQL Server ConsultantCommented:
You may need to load an SSIS lookup with data from an MDS subscription view, and then check new incoming data against that before sending it to the staging table (so as to exclude the duplicate rows). It sounds, though, like there is an issue with your coding scheme, or that you are using MDS to store something other than attribute data, for which codes might not be meaningful.

If you can provide a little more background on what you are trying to do then I might be able to suggest something more.
0
 
Shailesh ShindeLocalization Engineering & AutomationCommented:
Hi,
Each entity in SQL Server 2012 Master Data Services (MDS) will have it’s own staging table (stg.<name>_Leaf). Using this staging table, you can create, update, deactivate and delete left members in bulk.
Have you gone through with this post...


Thanks,
Shail
0
 
Shailesh ShindeLocalization Engineering & AutomationCommented:
0
 
Megan BrooksSQL Server ConsultantCommented:
Are you saying that the data values for two different members (codes) are the same? Are you automatically generating codes? The import doesn't check for duplicate data for a given member.

The ImportType compares members using the Code attribute. You can specify that only new members (codes) are created (ImportType = 1), or have it also update existing members (identified by code) with new data, either treating NULL attribute data as 'don't change this attribute' (ImportType = 0) or as actual data (ImportType = 2).

(While I have worked extensively with MDS, it was 3+ years ago. Apologies in advance if I am not understanding the problem correctly.)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.