InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 22:13:00 GMT20http://www.sqlservercentral.com/Forums/Topic1365130-147-1.aspxI have previously posted a question yesterday and thank you all for your quick response.I’ve nearly completed the SSIS package but unfortunately it stalls(doesn't error and have left it for 15 - 20 minutes) at the last step.The step that it stalls on is the updating of the lookup values from the lookup. I’ve tried many ways on performing the lookup cache and a queryI currently have a SSIS with the followingOLE DB SourceData Conversion - (To change my lookup value from int to nvarchar to match it in the lookup)Derived Column - (ltrim(rtrim(column)LookupOLE DB DestinationAny ideas ?Fri, 28 Sep 2012 09:02:13 GMTLee Hemmingshttp://www.sqlservercentral.com/Forums/Topic1365130-147-1.aspxCheers guys the conversion task worked a dream.In relation to SCC Rookie's comment "just go to the advanced tab-> output column and change the datatype" where should i be looking for this ?The reason i ask is so that i know for the future and can cover all permutations.Fri, 28 Sep 2012 02:24:52 GMTLee Hemmingshttp://www.sqlservercentral.com/Forums/Topic1365130-147-1.aspxBefore doing the lookup task convert the field to nvarchar using data conversion task :-P[url=http://www.beetlerim.com/Tech_BI.html]Business Intelligence [/url]Fri, 28 Sep 2012 00:11:35 GMTmarketing 98616http://www.sqlservercentral.com/Forums/Topic1365130-147-1.aspxHave you seent DataConversion task in SSIS pipes, as this seems to be what you are looking for. simply place it after the extractor, and do the conversion on the column, then run that into the Lookup and join on your new converted column.Thu, 27 Sep 2012 04:54:17 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1365130-147-1.aspxjust go to the advanced tab-> output column and change the datatype.or use the conversion task.;-)Thu, 27 Sep 2012 04:53:19 GMTsumit.joshijhttp://www.sqlservercentral.com/Forums/Topic1365130-147-1.aspxHi All,I have a SSIS package that has data in a table. I have a OLE DB Source to connect to the table but i need to do a look up to populate a field within that table. But the field i'm looking up on the destination is nvarchar and the source field is an int and the SSIS componet for look up dosen't allow lookup's with different data types. Can i change this with a derved column ?I could change the the data types on the tables but their both populated form external sources.Thank you in advance.Thu, 27 Sep 2012 04:22:04 GMTLee Hemmings