I do this with text files. The same logic should apply to your Excel files though. What I have done is set up a global variable in the package. Then...

The connection timeout setting bug was supposed to be fixed by SP2 for Analysis Services. I have not been able to get it to work and wonder if it is...

Try changing the lines:

"SELECT MAX([trans-num]) FROM matltran"

MsgBox("maxtran is '' " & rst.Fields([trans-num]).value & " '' ")

to:

"SELECT MAX([trans-num]) AS max_trans FROM matltran"

MsgBox "maxtran is " & rst.Fields("max_trans").value

If that doesn't work, check...

use a msgbox to return the value of your rst field and see what you are getting...sql server 2000 dts execute sql task allows you to assign a field value...

I hope I didn't steer you down the wrong path! I just now noticed you are using SQL 7...I am not sure what the execute sql task object looks like...

What about setting up a staging table? bring the data in from the file to the staging table, clean it there via sql update statements, then load it into the...

Have you looked at the Execute SQL task object? If you have your global variable set up for the package, put your sql statement in a execute sql task, you...

I must need more coffee! My apologies...I meant your code is checking the destination column before any transformation has occured, not the source column...I am going for coffee now...lol

Michael Weiss

Sorry...I didn't think that through...of course it is assigning a null for all fields if you think about it...it is not taking just the first value in col013 the way...

I am not sure about it checking only the first value in the columna and assigning a value in the transformation for all records, but shouldn't your script be:

IF NOT...

The best to start with, in my opinion, is Step by Step Microsoft SQL Server 2000 Analysis Services by OLAP Train/Reed Jacobson...

hth,

Michael

Michael Weiss

Okay...now I am really lost! lol What does the DID being less than 64k have to do with whether or not it is a problem processing? What I am trying...

Can you dummy up some data that you know will not fail? If so, and the package still fails, I would think you could safely rule out a data integrity...

Thanks! I forgot about using views as sources for dimensions. I must admit I am not entirely following you though. When you say you are not using separate table information...

I haven't done this yet, but I will have need for it soon so I have been playing around with this. You could use a single dimension and set the...