Hi..

I think it's because you need to fetch from the cursor before you get the @@FETCH_STATUS. If you run the below you'll get some commands printed out:

declare curBulkImport cursor

forward_only static...

Sweet as! Glad I could help.

Can you please do me a little favour and mark that response above as the solution?

Thaaaaanks!

OK, I got to here and now it's too late to continue. You really need to provide us with at very least the schema of the tables you're using and...

I've got a funny feeling both of the ignore_dupe_keys on the indexes is causing records to be spat out of the tables on insert:

Add a select above your insert and...

Can you post the code that you're written so far?

Does the function you're written work?

Hmmmmm......

Now this looks incredibly like homework\assignment material...

Why don't you post us what you have tried yourself so far and we can make comment? We won't do your homework for...

Hi H4K,

The Levels function to which you refer is zero based, meaning that LEVELS(1) is the second level in the hierarchy. Can you try adding another level to the hierarchy...

Hi..

Firstly, yes you probably are on the wrong forum, but I'll try anyway.

1: After a quick search I found this SSMA:

SSMA for Sybase v6.0 is designed to support migration from...

Hi,

What happens when you run the package manually using the third set of parameters?

Ok,

So the answer was that I hadn't created the Named Calculations in the DSV. Once I created the 'real' measures I needed then my original SCOPE statement worked a treat....

Hi brisims34,

Excel can sometimes cache the names of hidden measures in the cube. Has the user refreshed their pivot table and tried removing and re-adding the measure?

Also can you check...

I'm going to try adding a Null member to the DSV and see if scoping to that measure will solve the problem.

If that doesn't work I'll run a trace and...

Hi Martin,

Thanks for the reply. That [All] member was put on by Excel as that reference only includes both of the product members in the sub cube.

The calculation I'm doing...

Ahhh I see..

Because you don't have a unique key, like an integer identity, you're concerned that if a load is in progress and fails, there'll be no way to tell...

Hi,

If you want to do this in SSIS you'll need to write a script component to act as a datasource.

There are a few good resources out there that show...