You will find that people will respond better if you post error messages and what you have tried to resolve them.

Very...

This is a cross-post - no more answers here please - use this thread instead.

mister.magoo (2/12/2013)

---

dubem1-878067 (2/12/2013)

---

I have a varchar column containing dates (not my design) with this format 2013-02-12

I need to extract records between two dates

this code will do the job

where...

I can't really see what this has to do with SSIS, but here's one way.

declare @MyDate datetime

set @MyDate = '2012-12-29'

select DATEADD(dd, - (DAY(DATEADD(mm, 1, @MyDate )) - 1), DATEADD(mm, 1,...

athi_ssn (2/12/2013)

---

I have created a sample package for the first 5 scripts having 5 different sources,dataflow task and destination. I wanted to know if there is any other simple way...

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...