Search Results: Lookup Task

• 
  SSIS Lookup Task

  In today's blog, I wanted to share information on the Lookup Task. It is a great task because it will take your data Join it together, similar to what a Join does in TSQL. When you pull out the task in the Data Flow, you will need to connect it to an exis

  Author:  SMcDonald     Date: 4/30/2010     Section: Blog

  tags : Data Flow, Lookup Task, SSIS, Sherri McDonald
• 
  Lookup task error seems to depend on Cache mode

  Here is a very strange situation. I have a SQL Server 2008 R2 SSIS package that has been working fine for months. Overnight it started erroring, specifically a Lookup task failed with "error converting character data to uniqueidentifer". Seems fairly simp

  Author:  lempster     Date: 5/6/2011     Section: Forum
• 
  Integration Services Lookup Components ARE NOT Inner Joins

  Recently I was working with a client on the layout for a complex Integration Services package. At one point we were discussing the merits of Data Flow Lookup versus Merge Join components. During the conversation I realized that some confusion existed abou

  Author:  CraigLove     Date: 3/9/2012     Section: Blog

  tags : Data Flow Component, Integration
• 
  SSIS Fuzzy Lookup Error

  A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of a time figuring out why. The error did not tell me much: Error: 2011-05-18 10:42:09.33 Code: 0xC0047022 Source: Fuzzy Match InfoUSA SSIS.Pipeline Description: SSIS Erro

  Author:  jamserra     Date: 6/14/2011     Section: Blog

  tags : ssis, fuzzy lookup
• 
  SSIS bug??

  I have had a bit of a pet peeve with SSIS for a while now. My immediate though was that it is a bug, but I thought I would ask the community to see if you all have the same problem. In any of the Data Flow transformations (I use the Lookup task a lot, and

  Author:  Daniel     Date: 12/13/2010     Section: Forum
• 
  Customer Data Integration

  I've been trying to consolidate a number of different sources and representations of the same data , specifically physician listings. I'd like to have a master physician table, and that led me to read about Master Data Services (MDS). MDS, though, seems t

  Author:  stirone     Date: 5/31/2011     Section: Forum
• 
  Updating database records with no dependable relationships...

  Sounds like you need to make use of either the Lookup task to lookup the proper key from the second database or use Fuzzy Matching (Enterprise only feature) to figure out what are true matches and go from there. Lookup Transform: http://msdn.microsoft.com

  Author:  sqlchicken     Date: 6/30/2011     Section: Forum
• 
  Customer Data Integration

  Yeah the Data Quality Services in Denali definitely looks exciting and hopefully alleviates a lot of these types of pains. In the meantime, I spoke with Joe Salvatore this morning about this issue and he suggested you'll probably have to a "waterfall" met

  Author:  sqlchicken     Date: 5/31/2011     Section: Forum
• 
  Error

  If the name means anything here, it basically means that you're trying to use a TimeID that doesn't exist in the Time table. You have some options here. 1. Ensure that all of the possible Time ID's are created before you run the package. Populate them out

  Author:  paschott     Date: 7/9/2010     Section: Forum
• 
  error in execute sql task when updating master table comparing with temp table in SSIS

  Jahid said: Hi, My Control Flow sequense is like 1) Execute SQL Task (which creating temp table) - next - 2) Data Flow Task (which transforming data and looking up with existing master data to saperate matching rows. also inserting matching rows into temp

  Author:  sqlchicken     Date: 5/17/2012     Section: Forum
• 
  How can i ensure that all data from the source to destination dumped.

  You are on right track. I would construct Data Flow 2 task as following. 1. Add Excel Source 2. Add Lookup 3. I will setup following properties in the Lookup task On General tab: Cache mode : Full Cache, Connection type : OLE DB Connection Manager, Specif

  Author:  vksingh24     Date: 12 days ago     Section: Forum