dtswiz sqlserver2005

Is there somthing like dtswiz (from sqlserver 2000) in sqlserver 2005?
I want to import a tab separated file into a table.
Sure. In Management Studio Object Explorer right click on a database and
select Tasks>Import Data
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Anonymous" <anonymous@.noemail.com> wrote in message
news:%231v1Y%23S5FHA.1276@.TK2MSFTNGP09.phx.gbl...
> Is there somthing like dtswiz (from sqlserver 2000) in sqlserver 2005?
> I want to import a tab separated file into a table.
>
|||"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eaCH41V5FHA.3760@.TK2MSFTNGP14.phx.gbl...
> Sure. In Management Studio Object Explorer right click on a database and
> select Tasks>Import Data
> --
> HTH
> Jasper Smith (SQL Server MVP)
<snip>
Ok, so I now know I am not losing my mind, when I look through the
Management Studio, and feel like I can't do anything. When I right click my
DB, I don't see the Import Data option. I am trying to move from one ISP
using SQL 2000 to one using SQL 2005. I downloaded:
Microsoft SQL Server Management Studio Express 9.00.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
What am I doing wrong? Management Studio seems so crippled, that I can't do
anything.
BV.
|||I don't think that functionality is available with the
Express Edition.
The Express Edition of Management Studio doesn't not include
all the features available in the other versions of SSMS.
-Sue
On Mon, 16 Jan 2006 23:25:24 -0500, "BenignVanilla"
<bvanillaREMOVE@.tibetanbeefgarden.com> wrote:

>"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
>news:eaCH41V5FHA.3760@.TK2MSFTNGP14.phx.gbl...
><snip>
>Ok, so I now know I am not losing my mind, when I look through the
>Management Studio, and feel like I can't do anything. When I right click my
>DB, I don't see the Import Data option. I am trying to move from one ISP
>using SQL 2000 to one using SQL 2005. I downloaded:
>Microsoft SQL Server Management Studio Express 9.00.1399.00
>Microsoft Data Access Components (MDAC) 2000.085.1117.00
>(xpsp_sp2_rtm.040803-2158)
>Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
>Microsoft Internet Explorer 6.0.2900.2180
>Microsoft .NET Framework 2.0.50727.42
>Operating System 5.1.2600
>What am I doing wrong? Management Studio seems so crippled, that I can't do
>anything.
>BV.
>