Since the child packages are not started directly, you should use package configurations to configure those packages, instead of manually linking a config file to them.

Nice question, thanks.

Great question, but actually an easy one to get correct. If you just read the question and see "effective Max CPU %" and you look at the table and see...

If all the Excel files have the exact same structure (also equal sheetnames), than it is a viable scenario.

To configure the Excel Connection Manager dynamically, you need to construct the...

Aaah, back to basics 🙂

Thanks for the question!

RonKyle (4/19/2011)

---

I don't recommend this. All dimension keys should have some value. Implement the third suggestion in the above post....

Interesting question, thanks!

Interesting question. Thanks.

WayneS (4/22/2011)

---

Koen Verbeeck (4/20/2011)

---

Stefan Krzywicki (4/20/2011)

---

Under your table name, click on the Columns folder and drag it to your query window and you get a complete list of all your...

Nice question to end the week, but some references would have been great.

My advise:

drop the SCD component. It is notoriously slow, and not easy to configure.

Just write out some TSQL statements that will do the logic:

do a LEFT JOIN between source and...

Load all the filenames into a staging table, so you can use TSQL to validate it.

(or write a script task in SSIS that uses .NET to validate, whatever floats your...

You can't log to a custom table with the built-in log provider.

You can set up custom logging using Execute SQL Tasks and Event Handlers.

As mentioned before in this thread, you...

How do you check the rowcount in the destination table?

You didn't place a top 100 at the beginning, did you? (SSMS automatically adds TOP 1000 when you script out a...

Figure out the widths of each column, import them all as strings, trim them and convert them to the actual datatypes.