The high level process for the incremental and full download is:

1) Informatica deletes data in the destination table on the staging SQL Server

2) Informatica on the runs the incremental or...

Ok I have attached the 2 SP that carries out the transformation from the de-normalized data that I receive from the DB2 database into the normalized structure for my application...

Hi John

You are correct i do have some of the tables set to ignore duplicates - on my original data feed that used SSIS i used that switch to lazily...

Hi Thanks Mat and Perry, your explanation of the problem was useful and the solution worked.

I can now failover between the principal and the mirror and the web site...

Hi thanks for your response

The data types used are:

FS.TANK_ID INT

FS.UNIT_ID INT

FS.Feedstock_Type_Code VARCHAR(10)

The columns FS.QTY and FS.TANK_TOTAL are actually calculated columns from an earlier step in the function fnTb_SUM_TANK_BY_FEEDSTOCK (which I...

Thanks for the response - I used the function and that worked perfectly

Regards

Justin

Thanks Danette for you reply, I actually mean't objects that were no longer required in the database, such as Views, store procedures even tables that are no longer used, rather then...

You could try creating a temporary table or table variable. Insert into this table the log data you want to keep, then truncate (not delete) the original log data table...

Thanks for the help. I read the article and followed its instructions. I discovered that the Packaging Wizard doesn't seem to register the DLL's as I was still getting the...

The /L switch is good, but this only shows the results after the package is run. I am looking to get a real time feed back whilst the package is...