<I posted this message in comp.databases Group and then realized this
is a more MS SQL Svr centric group . ... so re-posting it here.>

Gentlemen, any workarounds for DTS in Expression version?

My goal is to populate a new DB I created with CSV files ... after
reading through dozens of posts it was apparent that DTS is the way to
go and then only to find SS-05 Express doesnot support it.

Thanks in advance.

George

Hi George

You could try using BULK INSERT or BCP with a format file.

John

"GeorgeM" <gm@personaltrader.biz> wrote in message
news:1144511615.708546.208750@v46g2000cwv.googlegr oups.com...
> <I posted this message in comp.databases Group and then realized this
> is a more MS SQL Svr centric group . ... so re-posting it here.>
>
> Gentlemen, any workarounds for DTS in Expression version?
>
> My goal is to populate a new DB I created with CSV files ... after
> reading through dozens of posts it was apparent that DTS is the way to
> go and then only to find SS-05 Express doesnot support it.
>
> Thanks in advance.
>
> George
>

Hi John,

Tnx for the suggestion. But from what I have read in BOL on SS-05
Express, it does not appear it supports BCP.

George

GeorgeM (gm@personaltrader.biz) writes:
> Tnx for the suggestion. But from what I have read in BOL on SS-05
> Express, it does not appear it supports BCP.

Without looking, I say that SQL Express supports BCP. Either the command-
line tool, or the BULK INSERT statement in T-SQL.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland Sommarskog ha scritto:
> Without looking, I say that SQL Express supports BCP. Either the command-
> line tool, or the BULK INSERT statement in T-SQL.

I use BULK INSERT statement with SQL Svr Express 2005
and it's a great feature ...