By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,413 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,413 IT Pros & Developers. It's quick & easy.

SQL Svr 2005 Express Does NOT Support DTS

P: n/a
<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

Apr 8 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi George

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

John

"GeorgeM" <gm@personaltrader.biz> wrote in message
news:11**********************@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

Apr 9 '06 #2

P: n/a
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

Apr 11 '06 #3

P: n/a
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, es****@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
Apr 11 '06 #4

P: n/a
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 ...
Apr 12 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.