Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Lookup transformation in SSIS

Author  Topic  Sifu Starting Member 8 Posts Posted - 2007-01-08 : 20:33:11 Hi Everyone, I have created a SSIS pakage using the Lookup transformation in SSIS. The package seems to run too long (over 2 hours and still running)for a source table having records for 134 records and lookup table having just over 4000 records. The two tables table are join using a key id mkmodyr, that is: source table lookup table field1 fld1 field2 fld2 field3 fld3 field4 mkmoyr field5 field6 mkmoyr . . . field12 The sql statement in the Lookup Transformation editor is: select * from (select * from [dbo].[year_derived_series]) as refTable where [refTable].[mkmodyr] = ? The package bring all fields from the source table and one field from the lookup table into a new table. Can anyone please help or let me know what I've done wrong? I would be appreciated. Thanks in advance.