Sounds like a foreach task containing a fairly simple dataflow to me. The Foreach task will enumerate over your import folder, looking for *.xslx (or similar) and passing the name...

Mike Palecek (7/11/2012)

---

I am looking for the same information. I have two servers that are at different companies and I need to move data from one to another. The servers...

Presumably you are...

I don't quite follow you.

Can you provide a couple of extra bits of information please?

1) Sample input data

2) Desired results, based on the input data provided.

If you follow the link...

OK. Your problem is possibly down to the fact that the WHERE clause is acting on the whole row at a time (and not just to date1, date2 etc individually).

You...

Add a Row_Number() column to both (with sorting as you require) and join on that - then the update becomes trivial.

Jeff Moden (7/9/2012)

---

Koen Verbeeck (7/9/2012)

---

SSIS can rename files. I do it all the time.

It just happens to be that with a script task using .NET I have more control over...

Devesh_Srivastava (7/10/2012)

---

I am trying to fetch the rows from the source table which have a timestamp(Column) within the last 20 minutes and then formatting the rows to send the data...

phoeneous (7/9/2012)

---

Can't wrap my head around this one. Not sure which is the best way to handle the logic, in t-sql or ssrs.

12 columns total, six money columns and...

What is the purpose of the foreach container?

Worth a test, though I would expect SQL to SQL to be the fastest.

I think you might mean a script task, and I agree.

The extra flexibility (and, I...

It was in a previous role and I don't still have the...

Have a read here[/url].

i.campbell (7/6/2012)

---

Hi All,

i have an SSIS package that loops round a recordset, it takes a file name and path and copies it into other directories, updates a DB entry and...