Solved

Bulk import from MDS using SSIS

Posted on 2016-11-02
4
72 Views
Last Modified: 2016-11-07
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.
0
Comment
Question by:devguru001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 3

Expert Comment

by:Shailesh Shinde
ID: 41871624
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
 
LVL 16

Expert Comment

by:Megan Brooks
ID: 41871648
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
 
LVL 16

Accepted Solution

by:
Megan Brooks earned 500 total points
ID: 41871655
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Expressions are in essence, code. If you had an expression 2 + 2 it would evaluate to 4. A string expression of “Hello” + “ “ + “World” would evaluate to “Hello World”. Expressions are an excellent choice for working with dynamic variables, espec…
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question