Hi,

I want to use Integration Services to import a weblog file. The date
format
uses the 3 letter abbreviation for the month (jan, feb, etc).

I cannot see a simple way to convert that to the numeric equivalent so
that
I can import it into SQL Server.

It seems that I could create a table to do the mappings and use a
lookup
transformation. Is there something else built-in for months?

Alternatively, if there is an easier way to import dates in this
format:

11/Nov/2005:00:20:25

I would be eager to hear it.

Any pointers in the right direction would be appreciated.

Thanks!

John.

You almost wnt something like this I think

http://wiki.sqlis.com/default.aspx/S...Functions.html

Allan

"John Goalby" <jgoalby (AT) gmail (DOT) com> wrote

These functions look one-way, going from a date to the month name.

I think I will end up using a script component.

Thanks

John.