Thank you

Divya,

Hi I wanted to thank you. Your script and the time you took to answer questions related to problems that I was having were a life saver.

It is good to...

I managed to have the script load the DB with data in the "pkgStats" table. But when running the rest of the script there is no data in the rest...

Where you able to run this in SSIS 2008?

If so would you share how you did it?

I am not an expert but can get around just fine.

I guess I am having a little trouble getting around the concept of variables in this case. I have set...

How to change the SP to a SSIS package.

Establish 2 variables that the SP currently uses in IF statements

DECLARE

maxtrans integer ;

newtrans integer ;

IF SP_CHK_IF_TABLE_EXISTS('MYTABLE')

THEN

maxtrans := NVL(MAX(transactionid),0)...

Thanks for your help. Our DW runs on Netezza. I don't have any issues connecting to it from SSIS. I am still having a hard time understanding the entire process....