Thanks for the easy question!

This should be OK, since you could browse the cube before the modifications, but did you check the dimension usage tab to see if everything is connected correctly?

Regarding issue #1: your code appends data to the variable for every iteration. So what did you expect?

Store the fixed part in another variable, and create each time the varFileLocation:

varFileLocation...

Regarding the quotations: this is to indicate that the text contains a delimiter. In this case, a comma.

You can convert the data to currency inside the dataflow, using a derived...

If you set up the event handlers on the package level, do they work?

How do you fail the Execute SQL Task?

If you set-up a dataviewer right before the Excel Destination, is the precision there still correct ?

The EXEC is screwing with your metadata, as the first statement in your sp is not a select statement.

Read the following article:

http://sqlserverpedia.com/blog/sql-server-bloggers/ssis-stored-procedure-metadata/

Great question to start the week. Thanks.

@quillis: is it possible to post the query?

@sririam: read this blog post: http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/stored-procedures-are-not-parameterized-views.aspx

It is best to avoid stored procedures in the OLE DB source, as they do not garantuee metadata...

The data conversion component doesn't actually convert the columns, it makes copies of those columns with the desired data type.

Did you remap the columns in the destination?

Can you browse the dimensions itself in their respective editors?

You can browse the cube in SQL Server Management studio or in Excel.

Maybe a stupid question:

did you refresh/reconnect the browser?

What syntax did you use to indicate the parameters?

Another option is to use a stored procedure in the source.

You copy the .dtsx files in the Windows itself.

Then you go the...