I haven't yet re-registered anything on the client...everything worked fine up to the time I left the office yesterday evening. This morning when I came in and tried to open...

Thank you, Phill. I looked at the variables' properties and everything looked fine...in fact I couldn't find anywhere that the datatype could be 'dispatch' so either I am confused or...

Thank you very much, Steve! I appreciate the extensive info and the link. I will study that article as I was impressed with all of the settings available...however, I will...

Thanks, Steve...I guess I was more concerned about the amount of memory being used by the msmdvldm processes...it just seemed really high compared to what I was used to seeing....

As an after thought, I am running the upsize wizard on an Access db...but I can't see why that would possibly involve those AS services. I am thinking memory leak...

Michael...

For some reason, SQL Server believes there is a default constraint in the target database with the same name as one it is trying to copy over from the original...at...

I believe you can archive the cube and then restore it on the other server...check BOL for information on archiving, restoring and copying cubes...

Michael Weiss

Yeah, I forgot about that fix...since you mentioned it, I remember going that route myself on one occassion...

Michael

Michael Weiss

The problem may not be with your MSDB repository. Have you opened the cube editor in Analysis Services and checked the cube's visible property? My bet is that the migration...

Here is a link to some ADO connection examples:

http://www.able-consulting.com/ado_conn.htm

and here is where you can find the ADO API programming reference on MSDN...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscadoapireference.asp

hth,

Michael

Michael Weiss

DTSGlobalVariables.Parent is a reference to the package object that contains the Global Variables...in your case, your DTS package. DTSGlobalVariables.Parent.Connection is a reference to a connection object in the package containing...

Also, you could use ADO in your ActiveX task and set the appropriate connection properties...ADO can connect to a text file...this will work if you are 'querying' the text file...

Check out this thread from a few months ago...

(watch for url wrap!)

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6872&FORUM_ID=19&CAT_ID=3&Topic_Title=Changing+the+Source+File+in+DTS&Forum_Title=Data+Transformation+Services+%28DTS%29

hth,

Michael

Michael Weiss

You can pass in user defined values to DTS packages via Global Variables. Look in Books On Line (SQL Server help) for Global Variables. A simple prompt to the user...

Enable logging for

this package, so that the error message will be recorded in the log file. Also, are you setting your main function in the activex task to something like:

If...