I think the options you have explained are either to have enire records duplicated - once for each language, or to only have the text data duplicated.  The simple answer to...

Yes.  Here is what I would do.  In the control flow tab of your package, put whatever process you have now to get your file name into the variable into...

If you have a dimension in a star schema in your data mart, when you set up the cube you ill have two tables joined in your cube editor by...

You will save your sanity by figuring a way to not have NULL values in your data mart.  Analysis Services is much happier to deal with non-null values in a...

Almost every tool available for setting up a database schema will default to matching columns with the same name.  So, naming the columns <TableName>ID and having this name as the...

I must be missing something.  Can you ping the remote SQL server from any of your other reporting services servers?  If you can connect to the database from any of...

I posted about this recently.  The execute SQL component in SSIS will not error when running a procedure if the procedure returns a result set before the error is raised. ...

It all depends on the situation.  A trigger is nice, but it is part of the transaction inserting the record and can slow down or error that transaction causing other...

You cannot downgrade the edition, you get a message about it violating the edition change rules.  The only option I was able to find is to uninstall MSSQL completely and...

You can get the identity back with @@Identity, but only if you tell SSIS to not open a new connection for each component.  In your connection manager, set the RetainSameConnection...

The answer is yes, there are in fact a number of components that can do an update.  You probably want the OLE DB Command component for a simple update.  Set...

You probably will not be able to use transactional replication.  You could, but your databases would need to be set up to ensure that you did not get primary key...

You are not in as bad of shape as you think you are.  Sorry about the whole sp3a thing though...Tell your company that MS has stopped support on that version.

As...

The short is that a report is a report (sorry to be that obvious) and a report model is basically a pre-set schema that is published allowing the end users...

Like most people are saying, you are going to have to end up with a little bit of down time for this unless you upgrade to SQL Enterprise.

My suggestion would...