FYI - reinstalling sp2 for Analysis Services did the trick.

Michael Weiss

I could be wrong, but my guess is that the index number of each step is assigned at the time it is created...not based on the order it is executed...

Just to let everyone know who may be interested, the patch is available from MS Support...

Thank you,

Michael

Michael Weiss

Take a look at the following function that you can execute via an ActiveX task...

Function DynamicFileImport

Dim objPackage

Dim objConn

Set objPackage = CreateObject("DTS.Package")

objPackage.LoadFromSQLServer "yourservername","","","256",,,,"textfileimportpackagename"

objPackage.GlobalVariables.Item("gvfiletoget").Value = InputBox("enter complete file path and name","Dynamic Text...

I don't know if there is a property to set to control the verification of transformations. I do know that the notification with the three options available is a real...

quote:

---

I have an ActiveX task containing vbscript that when placed in a DTS package, will set all Connection and DataTransformation (DataPump) information...

Did you ever find the cause of the problem? If so, what did you have to do to resolve it?

Thank you,

Michael

Michael Weiss

I am not sure if SP2 has fixed this or not but it sure sounds like a bug to me. Are you running SP2 on both SQL Server and Analysis...

Thank you! I will save the example code you provided, but I wimped out and did it through an ActiveX task using ADO and a command object which I passed...

Sorry, I should have added that I want to map the output parameter value from the sproc to a global variable...I also realize I can do this from a Dynamic...

Thank you, Jeff, for the info on how you solved your problem. That is good stuff to know - those things sure can be frustrating to figure out! Glad you...

You are most welcome...the input box method of prompting for a parameter works great for me and I use it extensively...good luck with your project!

Michael