You can speed up your view by putting a date_key column of datatype int in each table. Then put a Constraint on the date_key column in each table. Constrain the...

Have you tried creating a transformation then saving the package as a visual basic file, then opening the vb project and looking through the code that was generated? This is...

You might try re-creating your dts connection object on the server you are running the packages on...

hth,

Michael

Michael Weiss

Is your connection valid? You might want to check that...also, was your connection object created on a different machine? If so, you might want to drop it and re-create it...

Actually if yyou are executing the stored procedure from inside the same ActiveX task that you are using to read the ini file, you don't need to use global variables...if...

Another thought...you can use an ini file as the source of global variables in an Execute SQL task...this would necessitate moving the stored procedure outside of the activex script task...

Michael

Michael...

DTSGlobalVariables("myglobalvariable").Value = parameter1frominifile

DTSGlobalVariables("myglobalvariable2").Value = parameter2frominifile

DTSGlobalVariables("myglobalvariable3").Value = parameter3frominifile

'Note: Now I would create an ADO command object and create and append the appropriate parameters:

'Set parameter = command.CreateParameter (Name, Type, Direction, Size, Value)

Dim...

Just out of curiosity, are you using SQL Server 7.0 or 2000? What service pack are you running?

Michael Weiss

If your data includes alpha characters (non-numeric), SQL Server will generate an error. Have you tried running a query in QA and doing and explicit cast or convert to see...

I think Andy is correct...try running the package with the new password and see if it runs. Please let us know what you find out...

Michael

Michael Weiss

PS -

I am not sure if this makes a difference or not, but in SQL Server, a Bit data type can be either 0 or 1...BOL states that any non-zero...

Hey Jonathan,

I don't know anything about Progress, but why not go ahead and try an explicit conversion in the vb script code? Unless you are bringing in tens of millions...

If you want to link your data in the warehouse back to the source, you could certainly include the original source identifying key...maybe as a member property? Also, just because...

The literature I have studied all seems to suggest that surrogate keys are the way to go(an identity integer column in SQL Server, for example). This will negate any possible...

Because aggregations are not stored for virtual dimensions, there is a performance increase from the perspective of time reduction in processing the cube. Similarly, there is a reduction in storage...