Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Lookup Task
11 results found
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
Page 1 of 1 (11 items)