sql server dts: CSV File to database question -- sql server dts

CSV File to database question

ebferro
10/31/2004 3:58:01 AM

sql server dts:

I've got a .csv file named proddata.txt that I'd like to import into a SQL
server table entitled production. I'm confused as to how to do this. Is
there some information somewhere that would explain how to set up the
datasource and do the import, etc?

Re: CSV File to database question

Allan Mitchell
10/31/2004 9:04:09 PM

There are a number of ways to do this

1. BULK INSERT (TSQL)
2. BCP
3. DTS

for #3 have a look here

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

For #1 and #2 have a look in BOL

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

[quoted text, click to view]