I need any script suggestion to use in my stored_procedure_load. Looking to
load only the new data into staging tables since last_load_date.
I wish to enter the last_load_date information into a table on each
succesful load...and use the last_load_date info. in my query.

eg.
SELECT a,b,c,d
FROM dbo.customer WHERE
BETWEEN last_load_date AND getdate()

Store the load dates in a seperate table. At the end of the load you can
enter the new load date into this table. In your query to decide which data
to take you can do


SELECT .....................
FROM ...................
WHERE DataDate Getween Getdate() AND (SELECT MAX(Load_Date) FROM LoadTable)



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"baaul" <baaul (AT) discussions (DOT) microsoft.com> wrote

Your second option is to add an execute sql task in front of the load that
captues the max date already in your destination table. Plug that into a
global variable and pass it to the next step in your package. Same result
without the extra table.

"Allan Mitchell" wrote: