Are you still having the same error?

Are you able to preview the spread-sheet in the file connection manager?

This usualy means that the file is not in the location that you specifed, check that it is.

S Hodkinson (1/14/2009)

---

Thank you, thank you. I've managed to get Management Studio installed and connected to 3 servers. Whooppee

Can I do a similar thing for BIDS (or should...

it should do, unless you are using some old t-sql code that has been deprecated in the 2008 release..

I have to agree, if you are not going to use any access features such as bound forms, then you will save your-self a lot of trouble by...

I upgraded our sql server 2005 to 64bit and all our .Net applicaiton worked fine afterwards. Not sure about Crystal though..

The do make it fairly easy but try to make things, like overwriting your database file accidently, a bit more difficult...

The problem is that you are using the NORECOVERY option, this will leave your database in a a non-recoverd state so that you can restore further transaction logs.

If you want...

Also do not forget to rename or relocate the .mdf and .ldf files.

This is not a script, but i use this utility quite a bit to generate scripts from SQL server.

http://weblogs.sqlteam.com/billg/archive/2005/11/22/8414.aspx

You can use SSIS to transfer the tables across, create a package with your SQL server as source and the Oracle database as a destination.

Not too sure...

Check the size of your temp database, and that it has enough room to grow.

Resetting the server will delete this file

It will be hard to write a...

you may have to write a custom script for this.

All the lines of data in the source file in the same format. eg. all three address columns are...

What is the problem that you are having?