Servers should not need to be linked for this to be accomplished.

The account that SQL Agent runs under needs the relevant access to the relevant databases for processing purposes. Either...

Depends on your architecture... if it's distributed (as opposed to all on one box) most likely you have the "double-hop" issue and need to configure Kerberos to correctly delegate user...

Well if you change the data columns in the source file, you have to add them to the flast file connection manager component and through the data flow to the...

Use a precedence constraint on the connector from that task to subsequent tasks.

In the precedence constraint, use an expression to test for a true or false value as to whether...

You can execute SSIS packages using DTExecUI.exe

You can find this utility under SSIS tools on a machine that has SSIS installed

Two that I know of

http://www.forceamp.com/

That uses linked servers and stored procedures to replicate your SF database locally - we tried it but had mixed success especially with large...

Run a trace on the Analysis Server to see which account is accessing the cube to perform the processing.

Ensure that account has the security clearance to process the cube in...

You could double-check your SSAS Server security - they are different to the SQL Server security

Right Click on the SSAS Server from SSMS and check the security credentials - see...

I did this yesterday.

To configure a connection manager to connect to a dBASE or other DBF file

Add a new OLE DB connection manager to the package. For more...

Here is a good starting point

http://www.databasejournal.com/features/mssql/article.php/3386441/MSSQL-Server-Reporting-Services-Mastering-OLAP-Reporting--Cascading-Prompts.htm

Well, you could try

LTRIM([sAMAccountName], 100)

Followed by a Data Conversion Task to String

i.e. two separate tasks

You might try a derived column using SUBSTRING(yourvalue, 1 100) which will truncate to 100 chars, followed by your conversion to correct string type

Sounds like your pages are rendering wider than standard Portrait / landscape A4 page widths.

Check that both your report settings and the size of the obects on the design canvas...

To Dave

Try Teo Lachev's new book

http://www.prologika.com/Books/0976635313/Book.aspx

I have his SSAS 2005 book and it's excellent.

or did you mean this

= Format(DateAdd("s",-1,DateAdd("d", 1, Parameters!rsThruDate.Value)), "dd-MMM-yyyy")