db2 database running on AS400 to sql server(problem with date format)

[sati]

Hi guys,
i am getting data from db2 database
on AS400 system in CSV files and i need
to use this data and build a dataware
house in sql server 2000.
the date formatt coming from AS400 is
YYYMMDD(eg:- 1011223
101---stands for year
11--stands for month
23-- stands for day of the month
)

can anybody advice me how to
encounter this problem.
thanks.

[lodie]

check the following in the Books online of sql I could help you:

SET DATEFORMAT
Sets the order of the dateparts (month/day/year) for entering datetime or smalldatetime data.


------------
sati at 1/4/2002 4:43:47 AM


Hi guys,
i am getting data from db2 database
on AS400 system in CSV files and i need
to use this data and build a dataware
house in sql server 2000.
the date formatt coming from AS400 is
YYYMMDD(eg:- 1011223
101---stands for year
11--stands for month
23-- stands for day of the month
)

can anybody advice me how to
encounter this problem.
thanks.