Import data from Excel and conversion

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184395 More actions · Answer 1

The best way to send the date to SQL Server is YYYY/MM/DD. So if you switch this:

SUBSTRING(INVOICEDATE,7,2) + "/" + SUBSTRING(INVOICEDATE,5,2) + "/" + SUBSTRING(INVOICEDATE,1,4)

to this:

SUBSTRING(INVOICEDATE,1, 4) + "/" + SUBSTRING(INVOICEDATE,5,2) + "/" + SUBSTRING(INVOICEDATE,7,2))

It should work. I have tested it myself. You also do not need to do the conversion to date in SSIS, SQL Server will do it.

Jason Coleman SSCrazy Points: 2187 More actions · Answer 2

Thx for that - my ssis package also runs faster now without the date conversion.