Excellent, thanks for the tip. It was definitely going that way when I was moving from SQL to C#, so I'll brush up.

I think it might be, but every time I put an action in, it pops out to a different report on a new page. I kind of wanted to...

I was thinking about that approach last night. I have a main table that has several dependent tables, so looking at insert into table1 get generated key, use that...

Yeah, I thought it might get more complicated, thanks for confirming. I think I might have a way of doing it, I'll post later if I get it to...

No problem! It's been a year or so, but I found in the past that the best way of learning stuff is to jump in, so I thought getting...

Maybe this? http://stackoverflow.com/questions/6698075/how-do-i-move-files-to-an-archive-folder-after-the-files-have-been-processed

It's been a while and I'm just getting back into SSIS after a long hiatus, so if I'm misunderstanding what you're trying to do, please forgive...

SSIS doesn't support it, so the only way you'll really be able to get it in (I believe) is by using a script task.

This thread might help http://www.sqlservercentral.com/Forums/Topic965972-391-1.aspx

Also,...

I'm just getting back into SSIS after a long hiatus, but can't you move the file you're working on as your step 2 finishes before you hit 3? Seems...

I think the easiest way to do it would be using triggers on the table itself for update and delete. We already do have a createID, createDate, updateID, updateDate...

Sean Lange (5/21/2013)

---

If you track only the "old" value you have the complete history. The value it was changed to is either in the next audit row or in the...

Thanks for replying. CDC was our first thought, but it doesn't have the data that was changed. This is a system that keeps track of who has access...

J Livingston SQL (5/13/2013)

personally I would model this in excel and pivot tables first.....easy enough to create sample data.

start planning on what you really want to analyse / kpis /...

J Livingston SQL (5/13/2013)

---

is this...

Sorry, my bad. In a bad place, two friends lost everything to Sandy and I took it the wrong way. My apologies.

Gosh? Just looking for some general advice on how to get back into ssis after being away for a while. Thanks for the support.