Good luck with this. Not the easiest project for starting off your SSIS journey.

Whereas I'd like to see the one written...

opc.three (2/11/2013)

---

I would do this in two steps:

1. Run an Execute SQL Task to retrieve the max ID from the destination table and store the result in a variable.

2. Run...

aaron.reese (2/11/2013)

---

Phil,

Thanks once again for coming to my rescue.

Yes, there will only be one batch per package execution

create table dbo.batchHeader(batchID int identity(1,1), description varchar(200),filename varchar(200))

create table dbo.batchLine (batchID int, partno...

dwilliscp (2/11/2013)

---

I changed to PK, thanks. I will have to look back and see if he stated anything about using PK... I would not think that e-mail would be a...

dwilliscp (2/11/2013)

---

In Andy Leonard's article "Adding Rows in Incremental Loads - Level 3 of the Stairway to Integration Services" he goes over adding 'Lookup' object and checking for modified rows....

I agree with the previous comment. Even if performance is degraded slightly (and it's not clear that it will be), the fact that you can maintain a separate dev environment...

Can you describe in a bit more detail how the batch Id is generated/retrieved?

Is there only ever one batch Id per package execution?

Is this just a rant (it's a good one!), or are you hoping for comments?

A simple source-target dataflow will do the job - but you'll only be able to run it once. If you want to be able to run it multiple times, you...

manikam_sundar (2/10/2013)

---

Hi friends,

This is my first post in SSC, Im new to SSIS .,

Scenario : SOURCE SQL DB NAME 'A'

...

Looks like you have not installed SQL Server / SSIS.

PaulB-TheOneAndOnly (2/8/2013)

---

rs80 (2/8/2013)

---

Can a slowly changing dimension be used to insert/update records into a staging table? I haven't used that transformation before and from what I read it was more...

Have you considered a pure (ish!) SQL solution?

Haven't got much time right now, but have a look here[/url] & see whether it might be useful.

Please explain what you mean by "registers them in a log table" - are you actually processing the files or just recording their names?