Hi,

Probabily you did not understand what I meant .

The DTS allows to change Global Variables (inner) in a package based on the value of...

Analysis Manager, does not allow you to:

• Copy roles from one Database\Cube to another Database\Cube.
• Does not allows you easily the fact table in a partition, i.e., you need to click in...

Hi,

Have you consider the Alt-F -> S or Ctl-S commands in Excel ???

Hi,

I was not able to use your solution .

Can you please, check if it works for you?

Thanks.

FYI, COALESCE is a simplyfied version/flavor of the CASE statement (for more info see BOL).

I was already able to assign GV2.

The problem was that GV1 is of type int and GV2 is of type "string".

Hi,

Unfortunatly, no guidance on the debugger, althought insterested in the solution for the debugger. However, don't you have the query in the reverse?

If DTSSource("Fld1") is empty Then

  DTSDestination("Fld1") = " ...

How can you use the Global Variable in the SQL Task?

I created the Global Variable in the Package using the Explicit Global Variables option.

Thanks in advance.

Hi guys,

Have you considered using dynamic SQL? I.e., you would create a varchar variable with the query (using CASE to determine if the query would have either the WHERE or...

Hi,

isnull is the better way to do it. In fact, I think that coalesce is done using case.

Getting back to your initial question. Be aware that if the select returns...

The ideia is to copy the cube from pre-production to production. This way no cube is generated/updated in production and of course I can not stop the production environment to...

Hi,

Before working with SQL Server I worked with ASE (Sybase 11 and 12), my experience with ASE advise my to force indexes when you know that it is better knowing...

I solved the problem by breaking the "Transform Data Task" into sub-tasks.

I.e., instead of copying all columns at the same time (faster), I copied the non-problematic columns with the standard...