dtswiz sqlserver2005

9 Nov 2005 1:21 PM

Anonymous

Is there somthing like dtswiz (from sqlserver 2000) in sqlserver 2005?

I want to import a tab separated file into a table.

9 Nov 2005 6:43 PM

Jasper Smith

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

Show quote

"Anonymous" <anonym***@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.
>
>

17 Jan 2006 4:25 AM

BenignVanilla

"Jasper Smith" <jasper_smi***@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.

17 Jan 2006 3:02 PM

Sue Hoegemeier

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"
<bvanillaREM***@tibetanbeefgarden.com> wrote:

Show quote

>
>"Jasper Smith" <jasper_smi***@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.
>