Many thanks to everyone for your help.

Guys,

Thanks for the advice, and will prbably now do a defrag and dbreindex.

One final question, the concensus seems to be to Redbuild indexes first and then defrag. Is there any...

However if you have no plans to move over just yet then I found the following book invaluable. Often you will buy a book and it's either too simple or...

In which case you should be using the method LoadFromStorageFile.

In theory you can do this in DTS using VB script by instantiating an Excel object. However one limitation os that you will need to have Excel installed on the...

Is it any better with a table var??

Did this work for you in 2000?

Also I take it that package '\PkgFolder\DataUpload' does exists on the server and not as a file on the server?

What are the specofics of the error message?

If you chnage the collation there is a risk it will have a knock on effect on other queries that were prevously working. I usually the cast the join expression,...

In the source query that you use get the data from access you could do a distinct across all coumns.

Check out this post..it may help.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=21&messageid=247772#bm248068

Could it be that the user deepcdbn1coll\sqloper does not have sufficient access for Analysis Services?

As the previous poster mentioned in 2000 this is not easy. we have several situations where we need to format data according to an xml schema and output as a...

I alwasy thought it would be running the DTS package as whoever was specified as the Job owner. So if this is sa then it may not have access to...

In EM open the package for edit. Right click and 'save as' and in the location dropdown select visual basic file.