SQL Server 2005 exporting data

[Gman]

I'm trying to export a simple 3 table database alont with 3 stored procedures but i'm haivng problems.

I can use the back to creat a .bak file ok but the database at uni has locked the priviledges and wont let me selet an external backup source. SO I need to export it.


There a few files types to choose from so I've selected the Flat File but when it tries to export it comes up with this error

Validating (Error)
Messages
Error 0xc020802e: Data Flow Task: The data type for "input column "Notes" (59)" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component.
(SQL Server Import and Export Wizard)

Error 0xc004706b: Data Flow Task: "component "Destination - temp_txt" (40)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

then tried exporting it as an excel file but got an error saying "The microsoft jey engin could not find the object "Employees". make sure the object exists....."

ideas as i'm running out of em and looking like uninstalling this and trying to dig up msde as i've had no probs in the past with that

Also tried using the restore feature on a sql 2000 database that ive backed up from my hosting account and even that throws an error saying

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'DESTROYER\SQlSERVER'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?Prod...ceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Directory lookup for the file "c:\Databases\WALKER\gwalker4_data.mdf" failed with the operating system error 3(error not found). (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

 

[Gman]

Update

Just found the Generate Scripts option ohh well 10 mins writing a post only t find the answers wthin 2.

 

[Gman]

right ran into another problem.

When using the generate scripts option how do you make it generate the code for the data as well?

at the moment its just creating the sql for the schema not the data within the tables. any ideas how to sort this ?

Update: just got the trial version of Red gate SQL Bundle 5 and that seems to do the trick fine although I think its only going to last 15 days