the encoding would be specified like...

<?xml version="1.0" encoding="ISO-8859-1" ?>

HTH,

It looks like XmlDocument uses UTF-8 by default unless you have an encoding attribute in your xml. You haven't posted any sample of the XML so I can't say...

You would definitely want to use SCD Type 2 for the contact info. I would personally never attempt to use these as measures, they are completely non-additive, and not...

Did you upgrade to Windows 7? This was the symptom of a Win7 -> SSAS connectivity issue. You can search the forum (or google) - from memory (and...

You've given him public and sysadmin roles 'where'? In SQL Server? SQL and SSAS security are seperate models. If so, you need to explicitly provide access (ie...

Scoping of variables is pretty standard in development languages (e.g. C# , java, VB.net etc). If this wasn't available to you, especially on a large code-base, having to have absolutely...

Lynne, you beat me to it 🙂 Apologies for re-stating what you had already

Hi,

Neither 'issue' is a bug, it is by design - it's the 'scope' of the variable/s.

When you are at the top level (ie when nothing has focus but the...

Unless I'm misunderstanding the requirement, seems BOL outlines how to do this here.

Basically write your routines/methods you want to use across different packages into a dll (must be signed) and...

On relooking at the diagram, logically it looks like the precedence constraints to the archive should be set to 'OR' not 'AND' because, in a single iteration of the foreach,...

looks like you may have a breakpoint set in the script task. Sometimes this throws the code window up behind the executing BIDS window, so you may want to...

@ Sabarinathan:

Tables Involed in creating reports is

Dimension Tables :

LDepartment - Department name

LChain - ChainName is filter

DimProductHierarchy - Product Code (Should be a count)

Measure table :

FactStockOnHand...

Let's say you have a package level variable (type object) that contains the ADO table of file names. Then you have a foreach container that iterates through each record in...

on the success/fail (so basically the conditional flow between tasks) make this based on an expression. You can make it be based on the success/failure of the previous step...

Random sampling versus quota sampling? Seems you could be looking for a quota rather than a random sample. The linked pdf (see notes #8 in article) shows minimum...