DSXchange

Ray,
I got it straightened out at least it is not doing it, I think I was parsing the file wrong, etc...Thanks for the help.

Craig,
Yup, I wasn't even thinking about that, your right. mucho thanks.

thanks. I will take a look at doing that.

I was wondering if anybody has seen this situation. I am using the following: DATE.TAG(@DATE) to insert into 2 different columns, one has the correct date, for instance '2004-05-04 00:00:00.000' and the next column ends up with '4513-02-25 00:00:00.000' the target db is sql server 2000, both fields ...

I want to utilize keymgtgetnextvalue to generate surrogate keys. But as a good pratice, I would like to update or re-seed the file or process with the max value of each of my dimension tables. Can anybody explain or post a code snipet to accomplish this?

Thanks
Marc

Marc, Actually storing the CRC value in the DB is a good idea and one I try to get each of my customers to do. This will prevent you from having to generate a CRC value for an existing record. It's one less step you have to perform. When you are updating or inserting new DW rows you already have th...

Hi All, I have been lurking for a while on this site and the dev net for Ascential. I am looking for a little feedback on a datastage process. Basically, I am implementing a type 2 scd using michael's example,(thanks Mike). My question is that, right now I end putting CRC values and a natural key ou...