I would use BCP or SSIS to import the records. If you must do it this way try specifying column names instead of * in your select...

So whatever your doing it looks like you cannot read from a file either because the path is incorrect or because it is maybe in use by another process or...

Try running an execution plan...I'm guessing the one w/ the derived tables might be better since there is no DML operations taking place but then again it might add a...

okay so after testing it I have determined that SSRS is not able to connect to a SQL 2005 instance. I had a hunch that it would work if I...

Hmmm...

Do you have a maintenance plan that cleans up this stuff and does reindexing and all that? I'm not 100% on this but my hunch is that if you deleted...

The report is using a SQL Login to connect to the DB

Reporting Services is just like a lot of other .Net web apps so I would recommend you setup the web part on your IIS server and the database on the...

A side by side installation has worked for me in the 2 migrations I've quarterbacked. Basically install 2005 as a separate instance and then backup/restore the db's on the new...

Why not develop @ home on SQL 2000?

Not sure that sp_helpprotect will give the stats you're looking for. I haven't found a free one yet, most I've seen are about 1K + Here's a couple I've looked...

Microsloth has some good documentation on this...let me know how it goes. I'm getting ready to upgrade ours here also...

References

• Upgrading or Migrating Analysis Services (link)

• SQL Server 2005...

I would recommend log shipping or just doing a backup of the log then copying it...

Pretty beefy box...are you running the 64bit version? I would say the more the merrier but it might be overkill depending on how much processing is going to take place...

Well there are 3 procs called from one 'step' that calls a 'master' proc. So the problem is if I do a raiserror and kill the 'step' it would potentially...

Would this be an onsite only project?