sql server dts: Import date field to table -- sql server dts

Import date field to table

John
12/21/2003 7:03:28 PM

sql server dts:

Dear,

I want to capture a date field from CSV file to the table
(the CSV file have one date field only). But the table data
(another field) import from another CSV file. How can i
import the data field from CSV file and fit in the table?

Many Thanks

Re: Import date field to table

Allan Mitchell
12/22/2003 7:25:38 AM

OK

From your explanation I read that you have 2 text files. One contains a
data that you want and the rest of the data comes from the other file.

They must be joined somehow by key otherwise how do you know which date goes
with which row?

Import the text files into their own working tables. Use TSQL then to
manipulate these tables

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]