Phil,

this is not...

Shing,

I think the easiest way is to define 4 user variables, populate/alter them in a script task inside the loop and persist them in the database after finishing the loop...

The canonical way would be to put the connection strings to a configuration XML file where you can change it centrally without changing the SSIS packages.

In our project we do...

David,

if your excel sheet has the F2 field formatted as date, you will get a 'datetime' type value from the select statement. If you want to have this value inside...

When I use your code in my test db I can produce the sum row, so I guess your problem is only to display it at the bottom instead of...

Thanks for your sample data, that clarified your problem.

The Flat File Data Source parses the first line of data to learn ab out the format of your data.

Your first line,...

Grasshopper,

if you use a Flat File Data Source, you can run into problems with comma if your Locale settings use the comma as decimal delimiter.

If you create a new Flat...

SSIS has a Task named Analysis Services Execute DDL Task which can execute arbitrary XMLA scripts, including creating a Cube (although I cannot imagine where that this would be feasible).

Another...

Guid.Empty is a GUID consisting of all zeros.

yours

Günter

You can use the LIKE operator to achieve that.

For example, if your 'x' mean 'any character', you could use

like '_-_____-_-___' to test.

If you need some characters to be in...

Hi,

if you're inside a Windows Active Directory Domain (which I assume), you will have to go to the IIS settings of the Web Server hosting your SSRS Web Site.

This is...

Dankwart,

I am afraid the meaning of 'role playing dimensions' is somewhat different from what you expect. If I see it correctly, the feature enables you to use the same dimension...