SQL Server 2005 export table to file

[mlowe9]

Attempting to convert from SQL Server 8.0 to SQL Server 2005. In SQL Server 8.0 Enterprise Manager, I could simply right-click on a table, Choose "All Tasks", and choose "Export Data" and I could dump the table to a file. Very useful for me to do a quick backup of a table for testing.

However, I am stuck in SQL Server 2005 on doing this. It seems from what I've found that I have to build an SSIS package to do this for me, and it even seems harder than the old DTS packages.

Someone please tell me that there's an easy way to just dump a table to a file. Please.

 

[mrdenny]

Right click on the database, not the table. The Import/Export wizzard is found at the database level not the table level for some reason.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com