Jay,

Did you try adding a new datasource, changing the datasource of your cube & shared dimensions to the new source, then deleting the old source? I know you can add...

Do the tables need to be joined? By your description, it is difficult for me to be sure. I would do something like:

1. Create DTS Package

2. Add SQL Server Connection...

Sorry for sending you off to another site yesterday, I wasn't fully understanding your question and thought it was a query related issue only. Anyway, I just finished writing out...

OOPS! Looks like I should have read Steve's article first before replying...

Michael Weiss

Jay,

Did you try looking on sqldts.com? I think they have a script there just for migrating dts packages to another server...

Never heard of an MSX server...if it were me I...

go to aspsqlserver2000@aspfriends.com - or try the sql programming forum here...you can probably get your question answered quicker there perhaps? just a suggestion...

hth,

Michael

Michael Weiss

Hi Jonathan,

How about 'INSERT mytargettable SELECT * FROM mysourcetable'...the problem you have to watch out for though is that you can get type mismatch errors if you don't list out...

The functions native to DTS are not available in the UI...as far as I know, the way to see them is to open the package in VB...

hth,

Michael

Michael Weiss

You are more than welcome!

Michael Weiss

The code I sent to you sets your excel connection object provided you have one in your package...just substitute the name of your connection object in the place of 'Connection...

Julie,

Here is some code that with a little modification should work for you...let me know if you have any problems! If your email address is listed on the site here,...

Sooooo...I assume you right clicked on the Analysis Server in AS, selected properties, and then clicked on the processing tab...there is a checkbox there for server timeout and if you...

Jonathan,

I do not have access to SQL Server 7.0, but in SS 2000 you can enter a ? for a parameter placeholder in your sql statement and then click on...

I will check this when I get in the office shortly, but basically as I understand it, a value of zero should mean no timeout at all...however, I am sure...

Julie,

I have some code I will post in an hour or thereabouts when I get in the office. Until then, look up file system object in the vbscript help files,...