The two most accepted definitions are from Inmon and Kimball. Inmon describes it basically as the product while Kimball describes it as the entire process as well as the...

Keep it simple.

You are already assigning the value to a variable. Go back to the control flow and use an execute SQL task to run an INSERT into a...

You have another option - use a parent package to call of the child packages and pass the parameters from the parent package to each of the child packages (this...

It depends on your hosting provider. You should contact them. There may be additional cost - if they allow this at all.

Cross-domain connections are not that big of a deal. The servers need to be able to see each other's IP addresses and they need to be able to authenticate....

Please don't cross-post. It is really annoying.

http://www.sqlservercentral.com/Forums/Topic565232-338-1.aspx

You can use a loop container and a SQL Command that calls WAITFOR to wait for some time and poll again.

You could also do that entire operation in a stored...

It will depend on your definition of a data warehouse. Some people will tell you that this is a data warehouse, some will not. I tend to be...

SSRS hates temp tables. When it needs to update it's schema information, it runs your query or stored procedure, but it runs it with the parse only option on....

You can store it in a VARCHAR(MAX) or NVARCHAR(MAX) field and it will be relatively easy to manage the substitution with REPLACE.

I understand you have some project constraints, but Reporting...

Search this site a little. There are a few options and some articles have been written.

Does the query include any joins? Can you post the query?

Why not just use a data flow task to insert the data into a table or temp table on the server that holds the table you want to update?

What you want is a Role-Playing Dimension.

You create a single dimension for your dates and add it multiple times to your cube. In the cube you can specify the...

You cannot set up transactional replication in both directions like that. You either need to configure your transactional replication with the updatable subscriber options, or you need to use...