Hi Gradley,

Thanks for the reply!!

Could you please be a bit more descriptive in how you accomplished the task using "Set Attributes" operation (leaving the defaults) of the File System Task....

Hey Jamie!!

I guess my response was a bit premature  coz the issues haven't settled in totto. The suggested method indeed does help in inserting...

I landed with a link suggested by one of the members on this group. It'll solve your issue of DLOOKUPS. http://www.sqlis.com/default.aspx?311 There are 2 methods here - I recommend you use...

Hi Jamie!!

Thanx a ton.....

I had tried the second method earlier but was somehow not convinced of its elegance. The first method suggested in the link sent by you was just what I was looking...

There is a transformation in Informatica named Update Strategy. It has three distinct options to deal with the incoming records based on some user defined conditions. The three options are:

I am afraid that SQL Server doesn't has any such feature as Dynamic lookup. However i guess that the slowly changing dimension feature of SQL Server could come handy for...