currently how are you handling the footer records in 2005? Isn't the same logic working for 2012?

Some time SSIS acts wiered. For these kind of problems, just deleted the dataflow and recreatea new one. 90% of the time the problem will be solved. If not need...

thanks for that suggestion Jim.

That's the crazy table with out the datecreated or modfied timestamp which brough me to this forum.

I am looking for both inserts and updates.

I am not particluar about the...

I am looking for some idea on how incremental loads can be handled in case of a failure in sql server or SSIS.

if the incremental load fails for a day...

For id 1 the the destination table is loaded fine till the startdate of 01012012.

suppose if the load fails after that for some reason and meanwhile the source table...

By the way what is this Vanilla trigger?

For this first you need to specify the variables in the ReadOnlyVariables or the ReadWrite Variables in the script task editor.Then in the Design script

Dim Variable1 As String =...

Really Nice Solution given at the link http://www.sqlservercentral.com/articles/comma+separated+list/71700/

WITH CTE AS

(

SELECT DISTINCT

empno

FROM #tab1

)

SELECT empno,

...

SELECT j.[name],

MAX(CAST(

STUFF(STUFF(CAST(jh.run_date as varchar),7,0,'-'),5,0,'-') + ' ' +

STUFF(STUFF(REPLACE(STR(jh.run_time,6,0),' ','0'),5,0,':'),3,0,':') as datetime)) AS [LastRun],

MAX(CAST(

STUFF(STUFF(CAST(sjs.next_run_date as varchar),7,0,'-'),5,0,'-') + ' ' +

STUFF(STUFF(REPLACE(STR(sjs.next_run_time,6,0),' ','0'),5,0,':'),3,0,':') as datetime)) AS [NextRun],

CASE jh.run_status WHEN 0 THEN...