Hi, In my source (text file connection) there is a date field but the date
is stored yyyymmdd (20080226)
I need to convert this into a real date 02/26/2008 and then import it into
the sql server database into a datetime field.
I'm a newbie with DTS so very detailed insturctions would be greatly
appreciated. When I just tried having it import into SQL Server I got an
error obviously since the date in the source data is not in a format sql
server will understand

I'm not going to get detailed but I'll give you one way to do this. You'll
have to do some research on your own.

Import into a varchar column then use convert to transform and push into
your destination datetime column
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"Patrick Hill" <phill (AT) nospam_quickcomm (DOT) com> wrote

I'm not going to get detailed but I'll give you one way to do this. You'll
have to do some research on your own.

Import into a varchar column then use convert to transform and push into
your destination datetime column
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"Patrick Hill" <phill (AT) nospam_quickcomm (DOT) com> wrote

I'm not going to get detailed but I'll give you one way to do this. You'll
have to do some research on your own.

Import into a varchar column then use convert to transform and push into
your destination datetime column
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"Patrick Hill" <phill (AT) nospam_quickcomm (DOT) com> wrote

I'm not going to get detailed but I'll give you one way to do this. You'll
have to do some research on your own.

Import into a varchar column then use convert to transform and push into
your destination datetime column
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"Patrick Hill" <phill (AT) nospam_quickcomm (DOT) com> wrote

I'm not going to get detailed but I'll give you one way to do this. You'll
have to do some research on your own.

Import into a varchar column then use convert to transform and push into
your destination datetime column
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"Patrick Hill" <phill (AT) nospam_quickcomm (DOT) com> wrote

I'm not going to get detailed but I'll give you one way to do this. You'll
have to do some research on your own.

Import into a varchar column then use convert to transform and push into
your destination datetime column
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"Patrick Hill" <phill (AT) nospam_quickcomm (DOT) com> wrote

I'm not going to get detailed but I'll give you one way to do this. You'll
have to do some research on your own.

Import into a varchar column then use convert to transform and push into
your destination datetime column
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"Patrick Hill" <phill (AT) nospam_quickcomm (DOT) com> wrote

I'm not going to get detailed but I'll give you one way to do this. You'll
have to do some research on your own.

Import into a varchar column then use convert to transform and push into
your destination datetime column
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"Patrick Hill" <phill (AT) nospam_quickcomm (DOT) com> wrote

i forgot to mention use convert function when pushing varchar into datetime
column

--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"Knowledgy" <atlanta business intelligence consultants> wrote