Search
Resolved
as Not Reproducible Help for as Not Reproducible

1
Sign in to vote
0
Sign in to vote
Sign in
to vote
Type: Bug
ID: 507861
Opened: 11/3/2009 6:35:33 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
I have a DFT that creates a cached transformation to insert rows into a cache file. There are only about 15 rows.
Following on from this there is another DFT that has a lot of transformations, three of which are lookups that lookup data against coming through the pipeline againts data retrieved from the cache file. The first transformation that does this has no problems. The DFT task however fails when the second lookup transformation attempts to lookup against the same cache file.

The following error is seen:
[LKP PickUp Country Key [767]] Information: The system cannot find the file specified.Failed to load the cache from file, "L:\CCM_Country"
component "LKP PickUp Country Key" (767) failed the pre-execute phase and returned error code 0xC020930C.
The raw adapter attempted to read 4 bytes in the input file for column "CountryKey" with lineage ID 1, but there was an error. The error returned from the operating system should have been previously reported.
Cannot read 4 bytes from file "L:\CCM_Country". The cause of the failure should have been previously reported.

The cache file does exist on the L: drive and the account running SSIS has full permissions. If I move the second transformation to the end of the pipeline then the DFT succeeds with no errors.
Therefore it appears that in certain circumstances where a DFT has Lookup transformations that are next to each other in the pipeline that pull data from the same cache file it produces an error.
This goes against the principle of using cache connections in that they are supposed to be used by multiple lookups in the same DFT or across multiple DFT's.
Details (expand)
Product Language
English

Version

SQL Server 2008 SP1

Category

Integration Services (DTS)

Operating System

Win2003 Enterprise Server (SP2)
Operating System Language
English
Steps to Reproduce
Create Data Flow Task in SSIS 2008 to insert data into cache transforms. The associated cache connections use file caches.
The source table for the cache transforms is small (15 rows) & consists of two columns.
Create a second Data Flow Task to follow on from the first. Create an OLE DB data source to pull in data and then a Lookup Transform that looks up against data created in the cache file previously created. Create a second lookup transform that again looks up against the same cache file.
The amount of data being passed from the pipeline at source is large (tens of thousands of rows).
Actual Results
The following sequence of errors is seen where 'LKP Pickup Country Key' is the name of the second lookup transformation. 'L:\CCM_Country' is the name of the cache file created in the first DFT.

LKP PickUp Country Key [767]] Information: The system cannot find the file specified.
Failed to load the cache from file, "L:\CCM_Country"
component "LKP PickUp Country Key" (767) failed the pre-execute phase and returned error code 0xC020930C.
The raw adapter attempted to read 4 bytes in the input file for column "CountryKey" with lineage ID 1, but there was an error. The error returned from the operating system should have been previously reported.
Cannot read 4 bytes from file "L:\CCM_Country". The cause of the failure should have been previously reported.
Expected Results
There should be no failure as the first transformation has successfully looked up against the data in the cache file.
Platform
X64
File Attachments
0 attachments
Sign in to post a comment.