"Lam Nguyen" <LamNguyen@discussions.microsoft.com> wrote in message
news:1F0E15A6-E43A-47CE-9C42-80BDE0607E40@microsoft.com...
> Hi all,
>
> I have the following file and I use DTS to import data into this table but
> I
> am keep getting errors because of the date format in the file. This file
> is
> 2 Gb of data and the table has 230 columns. Does anyone has similar
> problem
> and has a solution for it. Also, this table is copy into other tables in
> DTS
> process. Any suggestions would greatly appreciate.
>
> Save text file: HuonData
> 001143235,20010118,500
> 007814761,20011026,250
> 006408670,20040313,900
>
> IF OBJECT_ID('HuonClaim', 'u') IS NOT NULL
> DROP TABLE HuonClaim
> go
> CREATE TABLE HuonClaim
> (
> HuonPolNo CHAR(10) NULL,
> PolEffDate CHAR(10) NULL,
> PolDeduct money NULL
> )
> go
>

"Allan Mitchell" wrote:

> This article may help
>
> Formatting Character Data into Datetime fields
> (http://www.sqldts.com/default.aspx?249)
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "Lam Nguyen" <LamNguyen@discussions.microsoft.com> wrote in message
> news:1F0E15A6-E43A-47CE-9C42-80BDE0607E40@microsoft.com...
> > Hi all,
> >
> > I have the following file and I use DTS to import data into this table but
> > I
> > am keep getting errors because of the date format in the file. This file
> > is
> > 2 Gb of data and the table has 230 columns. Does anyone has similar
> > problem
> > and has a solution for it. Also, this table is copy into other tables in
> > DTS
> > process. Any suggestions would greatly appreciate.
> >
> > Save text file: HuonData
> > 001143235,20010118,500
> > 007814761,20011026,250
> > 006408670,20040313,900
> >
> > IF OBJECT_ID('HuonClaim', 'u') IS NOT NULL
> > DROP TABLE HuonClaim
> > go
> > CREATE TABLE HuonClaim
> > (
> > HuonPolNo CHAR(10) NULL,
> > PolEffDate CHAR(10) NULL,
> > PolDeduct money NULL
> > )
> > go
> >
>
>