If the table is re-loaded every day, you could consider using view swapping/schema switching/table partitioning/rename table. I.e. you load a table the user can’t see, once the load is done,...

Here is a blog post that describing your switching scenario: http://kevinmintmier.wordpress.com/tag/xmla/

If you use a scheduling agent, you would be able to execute the alter command after the processing command.

SSIS needs to be installed on the machine where the packages are run, it is an option for the general SQL Server install.

How to run a package: http://technet.microsoft.com/en-us/library/ms138023(v=sql.105).aspx

If the packages...

Question 1.

Yes, research package configuration.

Article: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/66500/

BOL: http://technet.microsoft.com/en-us/library/ms141682(v=sql.105).aspx

Question 2

The deployment process does not alter packages, it moves them to a location where SQL Server agent can access and...

You missed bridge table 😉

How often does an advisors qualifications change?

When an Advisor qualifies for a new code, is that an event?

You can have a 1 to 1 relationship between a dimension and a fact table, you often see this in a degenerate dimension.

You write “Actually issues will be associated with...

Try to pass the file names in one variable with a space between the file names. Watch out for string size overflow.

Here are three alternative solutions:

1)Use wildcards to download...

Have a look at this: http://www.sqlservercentral.com/articles/Job/101563/

Scroll halfway down the article too see the sample report

Dts.Variables(0).Value is the value of the first variable in the collection of variables defined in the Control Flow.

I don’t know what book you are referring to, however to...

Did you map the result to a variable in the Result Set pane for the Execute task?

You mentioned that "I set in the expression @Connectstring to the variable I'm filling up with the connectionstring"

Why don't you just set the variable value to your development connection string?

You...

Yes, it is possible. The concept of dynamically setting the connection string is best practice.

The link you provided seems to show all the necessary steps for this to work.

Just a...

The Kimball books are a pleasure to read compared to other technical books, they are however very generic. Which goes for all data warehouse books I have read.

If you...

Instead of setting the connection server to the package configuration value, set it to a variable under Properties/Expression/Server name for the connection.

Use the package configuration to set the variable value.

Set...

In your fifth paragraph you mention: "inspected each one", this implies a business process. Then later "number parts inspected, replaced or broken", this implies that there is a Repair or...