Is it possible to order it this way?

1 1234 1237 some remarks

2 1237 1240 even more remarks

3 1240 1242 bladibladibla

2 1237 1241 blablabla

1 1234 1238 extra remarks

1 1234 1239 more...

How would you manually tell if the Oracle db has been loaded for that day? Is there a status table or some such thing that gets updated? Is...

When you say fetch other data, I'm assuming it's not just part of the same field (or columns from that table/view), but rather you need to pull in data from...

Can't be B as the OP states that it has to update existing records. Unless your SQL destination is going to a temp table and then you do a...

I always have an error output for each task in the dataflow;...

1) Use configurations to store your connection string.

2) Map connection string value to a variable.

3) Use the Expressions property in the connection manager to use that variable for the ConnectionString.

4)...

Add a data viewer to the dataflow path that goes into your conversion transformation. You'll probably be able to see the bad data that's not converting to an integer.

HTH,

Rob

Without your DDL, it's a little hard to get specific. But you probably want to look at the T-SQL DATEDIFF() function.

http://msdn.microsoft.com/en-us/library/ms189794(v=sql.105).aspx

Something like:

SELECT ColA,

ColB,

DATEDIFF(ww,...

Looks like "D" to me.

The downside of the OLEDB Command is that you'll be processing records a row at a time which can be a bottleneck. "C" makes no...

Right now, "created_on" and "start_on" are actual date columns from the source system. I have not created a date dimension yet and I might need help finding an efficient...

I've exported MySQL data nightly to SQL Server table with no problems using SSIS and ODBC source.

Is it repeatably not loading all MySQL source rows? Is there a unique...

Not knowing your help desk system, it looks okay to me. A couple of comments: