If I use the query below I get the LAST_UPDATED fields but no newly INSERT_DATE records which I should get atleast one record.

SELECT t.[ID]

,t.[SETID]

,t.[ACCOUNT]

,t.[ACCT_DESCR]

,t.[ACCT_DESCRSHORT]

,t.[ACCOUNT_TYPE]

,t.[ACCT_TYPE_DESCR]

,t.[BALANCE_FWD_SW]

,t.[BUDGETARY_ONLY]

,t.[INSERT_DATE]

,t.[ACCT_STATUS]

,t.[EFF_DATE]

,t.[LAST_UPDATED]

FROM [DCRPT].[dbo].[AMOUNT] t

inner join (

select ID, MAX(INSERT_DATE)...

Ok, I got confused but once the package is created we will deploy it and schedule it to run in a SQL job.

Phil I don't believe the job writes to a log table.  This is a table that gets updated daily I want to get the updated records and the latest inserted...

Currently, I don't have the value stored anywhere.  How would I write it as a subquery?

I do not.  What would be the best way to go about that as a variable?

Thanks, Jonathon but I'm not getting any results.  I'm new to SQL and SSIS learning as I go this is the query I'm using in the OL DB SOURCE for...

That worked for me Thom thanks.

Thanks for the reply Henrico,
I'm new to SQL so forgive me for the questions but I need the CSV file to be stored in a specific location on a...

Thanks Luis that worked perfectly.