SQL Server 2008 Developer x64 SP1 on Windows 7 Ultimate x64. VS 2008 BIDS SSIS project. SSIS package containing a Data Flow Task which contains a Fuzzy Lookup Transform. Running in debugger, pipeline fills up (components upstream turn yellow and records flowing down pipeline) and then just when the data reaches the Fuzzy Lookup, a DOS box briefly flashes and everything just stops. The Execution Results tab shows that the last entry for Fuzzy Lookup transform is "Information: Execute phase is beginning", followed by an entry saying the package '<name>' has been canceled. Anybody have some ideas on what this might be or how to best troubleshoot it? Thanks

Could you remove the fuzzy lookup and see if the package completes successfully.

I've removed it and the package completes. I've added it back in and the package fails again in the same manner. I've put SQL Profiler on it and I can watch it building the indexs and warming the cach and that lines up with the Progress tab entries showing those events taking place. Then nothing, it just dies when the execution starting occurs. Created an entirely new solution named dummy. Created two simple fake data files to compare against each other. Added the fuzzy lookup transform with 1 column comparison and it works. So I know the problem is not my environment. It can work properly. The question is why does it fail in such a spectacular manner when I'm trying to use it for real. I'm continuing to add complexity into the dummy project to see if it breaks at some point, but I have to get the real ssis package to work with this and its unrealistic to try and build the dummy package up to a level where I can replace the original with the dummy. Thank you for your suggestion though.

I've deleted the entire package and started from scratch rebuilding it. Started with just the part that contained the Fuzzy lookup and built it the way it needs to be for production. Using the artifact tables/data from previous version (now deleted) of package to feed the flow. Blows up in same manner. Setup the reference file to not make local copy (identity column as primary key), still blows up. Turned off warm cache. Still blows up. Turned on and off exhaustive comparison. still blows up. Removed all but one text column of comparison (it's address data, kept the zip code). still blows up. Looked at all data types. Except for Id column (which isn't being compared) they are all DT_WSTR of varying lengths. Both data table and reference table. Suggestions anyone?

Started trying to determine if it was the data being cleansed that was triggering the problem. Put a regular lookup task ahead in the pipeline to pick up all the exact matches. Non-matches were redirected to no-match output, which feeds into the fuzzy lookup. Fuzzy lookup still blows up. So I added a condition split ahead of the fuzzy lookup which was setup to filter out _all_ records (after many other combinations of filtering). Interestingly, although no records show up in the data viewer immediately downstream of the conditional splitter, the fuzzy lookup still blows up as soon as it's execution phase starts. I had assumed the blowup was triggered by trying to perform the first fuzzy match, but apparently that is not the case since no records are reaching it in the pipeline.

Looked at my reference table closely. Again, it's address data. Except for Id column (identity, which isn't being used for matching) all are DT_WSTR of varying length. Looked at the data. All normal with a few nulls here and there. So I trim the file down to just a couple of records. Still blows up. Reload the table with data. Still blows up. Now it gets weird. I create a separate SSIS project and select "Add existing package". Point it at the one that isn't working and it makes a copy of it in the new project. I run it and it works just fine. What the ____ !?!? So I delete the original (non-functioning) package from the original SSIS project. I now select "Add existing package" and point it at the working version of the package in the new SSIS project (which I haven't modified in any way). It makes a copy and adds it back in. I run it and it fails in exactly the same manner as before. Does anybody have any ideas of what might be causing this kind of behavior?

Hello... anyone figured this out??? Having exactly the same problem... used fuzzy before with no (haha) problems... just hanging on this project... grrrrrrrrr

I'm having this issue as well. The transformation turns yellow, a command window pops up and then the data flow is cancelled. I can't find anything in the windows event logs. Here are the diagnostic integration services logs for the Fuzzy Lookup component. I can't find any errors in there either. ExternalRequest_pre: The object is ready to make the following external request: 'IDBCreateCommand::CreateCommand'. ExternalRequest_post: 'IDBCreateCommand::CreateCommand succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'ICommandText::SetCommandText(DBGUID_DEFAULT,...)'. External request parameter for ICommandText::SetCommandText. Command text: SELECT * FROM [dbo].[DimCustomers] ExternalRequest_post: 'ICommandText::SetCommandText succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'ICommandPrepare::Prepare'. ExternalRequest_post: 'ICommandPrepare::Prepare succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IColumnsInfo::GetColumnInfo'. ExternalRequest_post: 'IColumnsInfo::GetColumnInfo succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IColumnsRowset::GetColumnsRowset(NULL, 1, DBCOLUMN_COLLATINGSEQUENCE, IID_IRowset, 0, NULL,...)'. ExternalRequest_pre: The object is ready to make the following external request: 'IColumnsInfo::MapColumnIDs'. External request parameter for IColumnsInfo::MapColumnIDs. Parameter ColumnIDMapping[1]: ID: 208878209 Ordinal: 32 External request parameter for IColumnsInfo::MapColumnIDs. Parameter ColumnIDMapping[2]: ID: 208878209 Ordinal: 485992264 ExternalRequest_post: 'IColumnsInfo::MapColumnIDs succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::CreateAccessor(DBACCESSOR_ROWDATA,...)'. External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[1]: Ordinal: 5 Value offset: 0 Length offset: 0 Status offset: 0 Part: 1 MemOwner: 0 MaxLen: 0 Flags: 0 Type: 19 Precision: 0 Scale: 0 External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[2]: Ordinal: 12 Value offset: 4 Length offset: 0 Status offset: 0 Part: 1 MemOwner: 0 MaxLen: 0 Flags: 0 Type: 3 Precision: 0 Scale: 0 ExternalRequest_post: 'IAccessor::CreateAccessor succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::ReleaseAccessor'. ExternalRequest_post: 'IAccessor::ReleaseAccessor succeeded'. The external request has completed. ExternalRequest_post: 'IColumnsRowset::GetColumnsRowset succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IDBCreateCommand::CreateCommand'. ExternalRequest_post: 'IDBCreateCommand::CreateCommand succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'ICommandText::SetCommandText(DBGUID_DEFAULT,...)'. External request parameter for ICommandText::SetCommandText. Command text: SELECT TOP 0 [CustomerName], [Id], [CustomerCode], [RID_101109_11:18:06_7784_7d4da312-f2db-41f6-b0b3-e7ad73152004] FROM [tempdb]..[##FLRef_101109_11:18:06_7784_7d4da312-f2db-41f6-b0b3-e7ad73152004] ExternalRequest_post: 'ICommandText::SetCommandText succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'ICommandPrepare::Prepare'. ExternalRequest_post: 'ICommandPrepare::Prepare succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IColumnsInfo::GetColumnInfo'. ExternalRequest_post: 'IColumnsInfo::GetColumnInfo succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IColumnsRowset::GetColumnsRowset(NULL, 1, DBCOLUMN_COLLATINGSEQUENCE, IID_IRowset, 0, NULL,...)'. ExternalRequest_pre: The object is ready to make the following external request: 'IColumnsInfo::MapColumnIDs'. External request parameter for IColumnsInfo::MapColumnIDs. Parameter ColumnIDMapping[1]: ID: 208878209 Ordinal: 32 External request parameter for IColumnsInfo::MapColumnIDs. Parameter ColumnIDMapping[2]: ID: 208878209 Ordinal: 486033256 ExternalRequest_post: 'IColumnsInfo::MapColumnIDs succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::CreateAccessor(DBACCESSOR_ROWDATA,...)'. External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[1]: Ordinal: 5 Value offset: 0 Length offset: 0 Status offset: 0 Part: 1 MemOwner: 0 MaxLen: 0 Flags: 0 Type: 19 Precision: 0 Scale: 0 External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[2]: Ordinal: 12 Value offset: 4 Length offset: 0 Status offset: 0 Part: 1 MemOwner: 0 MaxLen: 0 Flags: 0 Type: 3 Precision: 0 Scale: 0 ExternalRequest_post: 'IAccessor::CreateAccessor succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::ReleaseAccessor'. ExternalRequest_post: 'IAccessor::ReleaseAccessor succeeded'. The external request has completed. ExternalRequest_post: 'IColumnsRowset::GetColumnsRowset succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::CreateAccessor(DBACCESSOR_ROWDATA,...)'. External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[1]: Ordinal: 1 Value offset: 20 Length offset: -1 Status offset: 0 Part: 5 MemOwner: 0 MaxLen: 402 Flags: 0 Type: 130 Precision: 0 Scale: 0 External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[2]: Ordinal: 2 Value offset: 16 Length offset: -1 Status offset: 4 Part: 5 MemOwner: 0 MaxLen: 4 Flags: 0 Type: 3 Precision: 0 Scale: 0 External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[3]: Ordinal: 3 Value offset: 424 Length offset: -1 Status offset: 8 Part: 5 MemOwner: 0 MaxLen: 12 Flags: 0 Type: 130 Precision: 0 Scale: 0 External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[4]: Ordinal: 4 Value offset: 436 Length offset: -1 Status offset: 12 Part: 5 MemOwner: 0 MaxLen: 4 Flags: 0 Type: 3 Precision: 0 Scale: 0 ExternalRequest_post: 'IAccessor::CreateAccessor succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'ICommandText::SetCommandText(DBGUID_DEFAULT,...)'. External request parameter for ICommandText::SetCommandText. Command text: SELECT TOP 79572 [CustomerName], [Id], [CustomerCode], [RID_101109_11:18:06_7784_7d4da312-f2db-41f6-b0b3-e7ad73152004] as [RID_101109_11:18:06_7784_5a9991bc-48c3-4e86-aa9f-4e320fef5beb] FROM [tempdb]..[##FLRef_101109_11:18:06_7784_7d4da312-f2db-41f6-b0b3-e7ad73152004] ORDER BY [RID_101109_11:18:06_7784_5a9991bc-48c3-4e86-aa9f-4e320fef5beb] ExternalRequest_post: 'ICommandText::SetCommandText succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::ReleaseAccessor'. ExternalRequest_post: 'IAccessor::ReleaseAccessor succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IDBCreateCommand::CreateCommand'. ExternalRequest_post: 'IDBCreateCommand::CreateCommand succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'ICommandText::SetCommandText(DBGUID_DEFAULT,...)'. External request parameter for ICommandText::SetCommandText. Command text: SELECT [CustomerName], [Id], [CustomerCode], [RID_101109_11:18:06_7784_7d4da312-f2db-41f6-b0b3-e7ad73152004] FROM [tempdb]..[##FLRef_101109_11:18:06_7784_7d4da312-f2db-41f6-b0b3-e7ad73152004] WHERE [RID_101109_11:18:06_7784_7d4da312-f2db-41f6-b0b3-e7ad73152004]=? ExternalRequest_post: 'ICommandText::SetCommandText succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'ICommandPrepare::Prepare'. ExternalRequest_post: 'ICommandPrepare::Prepare succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IColumnsInfo::GetColumnInfo'. ExternalRequest_post: 'IColumnsInfo::GetColumnInfo succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IColumnsRowset::GetColumnsRowset(NULL, 1, DBCOLUMN_COLLATINGSEQUENCE, IID_IRowset, 0, NULL,...)'. ExternalRequest_pre: The object is ready to make the following external request: 'IColumnsInfo::MapColumnIDs'. External request parameter for IColumnsInfo::MapColumnIDs. Parameter ColumnIDMapping[1]: ID: 208878209 Ordinal: 32 External request parameter for IColumnsInfo::MapColumnIDs. Parameter ColumnIDMapping[2]: ID: 208878209 Ordinal: 485994872 ExternalRequest_post: 'IColumnsInfo::MapColumnIDs succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::CreateAccessor(DBACCESSOR_ROWDATA,...)'. External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[1]: Ordinal: 5 Value offset: 0 Length offset: 0 Status offset: 0 Part: 1 MemOwner: 0 MaxLen: 0 Flags: 0 Type: 19 Precision: 0 Scale: 0 External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[2]: Ordinal: 12 Value offset: 4 Length offset: 0 Status offset: 0 Part: 1 MemOwner: 0 MaxLen: 0 Flags: 0 Type: 3 Precision: 0 Scale: 0 ExternalRequest_post: 'IAccessor::CreateAccessor succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'. ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'. ExternalRequest_post: 'IRowset::ReleaseRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'. ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::ReleaseAccessor'. ExternalRequest_post: 'IAccessor::ReleaseAccessor succeeded'. The external request has completed. ExternalRequest_post: 'IColumnsRowset::GetColumnsRowset succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::CreateAccessor(DBACCESSOR_ROWDATA,...)'. External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[1]: Ordinal: 1 Value offset: 20 Length offset: -1 Status offset: 0 Part: 5 MemOwner: 0 MaxLen: 402 Flags: 0 Type: 130 Precision: 0 Scale: 0 External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[2]: Ordinal: 2 Value offset: 16 Length offset: -1 Status offset: 4 Part: 5 MemOwner: 0 MaxLen: 4 Flags: 0 Type: 3 Precision: 0 Scale: 0 External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[3]: Ordinal: 3 Value offset: 424 Length offset: -1 Status offset: 8 Part: 5 MemOwner: 0 MaxLen: 12 Flags: 0 Type: 130 Precision: 0 Scale: 0 External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[4]: Ordinal: 4 Value offset: 436 Length offset: -1 Status offset: 12 Part: 5 MemOwner: 0 MaxLen: 4 Flags: 0 Type: 3 Precision: 0 Scale: 0 ExternalRequest_post: 'IAccessor::CreateAccessor succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::CreateAccessor(DBACCESSOR_PARAMETERDATA,...)'. External request parameter for IAccessor::CreateAccessor. Parameter DBBINDING[1]: Ordinal: 1 Value offset: 4 Length offset: 8004 Status offset: 0 Part: 5 MemOwner: 0 MaxLen: 4 Flags: 0 Type: 3 Precision: 0 Scale: 0 ExternalRequest_post: 'IAccessor::CreateAccessor succeeded'. The external request has completed. ExternalRequest_pre: The object is ready to make the following external request: 'ICommandWithParameters::SetParameterInfo'. External request parameter for ICommandWithParameters::SetParameterInfo. Parameter DBPARAMBINDINFO[1]: Ordinal: 1 Data source type: DBTYPE_I4 Name: @[RID_101109_11:18:06_7784_7d4da312-f2db-41f6-b0b3-e7ad73152004] ParamSize: 4 Flags: 1 Precision: 0 Scale: 0 ExternalRequest_post: 'ICommandWithParameters::SetParameterInfo succeeded'. The external request has completed. Anyone got a clue what's going wrong?

Oops, it looked formatted when I entered it...

Having the same issue... Fuzzy lookup package works well in BIDS on my Server1 (running SQL Server - Standard Edition) then I move the package (and change the connections etc) to Server2 (running SQL Server - Enterprise Edition) it fails... When I execute the task... 1 - Lookup task turns yellow 2 - A black box flashes up and then disappears 3 - Output message states SSIS package "blah blah.dtsx" finished: Canceled I'm running with Run64BitRuntime = True on a 64 bit server... Even when I just re-create a simple look up on Server2 I get the same error... Can't find any sol's online... anyone know what's going on?????????? Thanks.... Mike

As the original poster, thought I'd chime in. What eventually worked for me was to: Created a new SSIS Project Add existing item, selecting the package from the previous project. It makes a copy in the new project directory. Deleted the old project. Everything worked after that. Stupid, but it worked.

Change the Run64BitRuntime option to false. This worked for me. Thanks- Craig

I have the same problem with the Fuzzy Lookup and tried all above method suggested above. None of them works. The project works in my notebook but it does not work in my workstation. Does anyone has a feasible solution suggestion?

I have solved the problem by reinstalling the SSIS. Thanks.