This is probably more a problem with the SSIS designer than with your package.

It is not really recommended to run a package with production purposes in the SSIS designer. Run...

sam.dahl (4/19/2012)

---

I've seen different results when using trim in SSIS compared to trimming in a SQL statement.

As a matter of course now I use a script component to do my...

Easy one, thanks.

For the moment, almost 30% took Read Commited (the default). Surprising, as Repeatable Read is stricter.

Revenant (4/18/2012)

---

Jeff Moden (4/18/2012)

---

Koen Verbeeck (4/18/2012)

---

Stefan Krzywicki (4/18/2012)

---

Just complaining for a second

Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I...

Jeff Moden (4/18/2012)

---

Koen Verbeeck (4/18/2012)

---

Stefan Krzywicki (4/18/2012)

---

Just complaining for a second

Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I hear...

Stefan Krzywicki (4/18/2012)

---

Koen Verbeeck (4/18/2012)

---

Stefan Krzywicki (4/18/2012)

---

Just complaining for a second

Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I hear...

Stefan Krzywicki (4/18/2012)

---

Just complaining for a second

Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I hear it has been fixed...

Everyone thanks for the great feedback.

There is another SSIS 2012 question in the pipeline for this month, and I'll do my best to think of some new ones.

Use Excel Services in SharePoint. Exactly the same as Excel, but users don't need to have Excel/Office installed.

Check out the PIVOT statement:

Using PIVOT and UNPIVOT

aarionsql (4/18/2012)

---

It's is for debugging only.

I will try the conditional split .. The conditions on the split will be looking for the lenght ... I would have never thought...

aarionsql (4/18/2012)

---

Thank you for your reply. The column is a concatenation of an ID and Date field and there is a truncation error which is stopping the package from running.

Is...

It should be. I configured database mail a few weeks ago so I could use notifications, and...

You could also delete the destination temporarily and use a multicast as a dummy destination. Put a dataviewer right in front of this multicast and see if all rows are...

SQL Server itself is normally insensitive to white space. However, the SSIS lookup isn't.

If you use TRIM, you need to use it on the source data and on the reference...