July 10, 2008 at 6:40 am
Hi
I have a problem when importing a .xls containing date fields into a table using SSIS through development studio( tasks >import data etc). My target database schema is all varchar 255 simply to get the table into staging prior to manipulation. The trouble I am experiencing is that although all my source fields are valid dates in the format dd/mm/yyyy in the .xls when I try and insert them as varchar and look at the results some fields are formated differently and some records are null where they should be populated.
Any advice would be appreciated.
July 10, 2008 at 7:20 am
Could you post some sample data?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 10, 2008 at 7:42 am
Jack Corbett (7/10/2008)
Could you post some sample data?
Dates are all in the format 15/12/2006 yet SQL doesnt see it that way. I'm thinking they are alligned differently hence the descrepancy I have tried playing about but not solved it yet. I have also imported it into a .csv which seems to load fine and although it potentially solves my problem I would like to know why the problem occurs and what the solution is on the .xls.
July 10, 2008 at 10:02 am
I tried creating an excel file with some random dates and could not duplicate what you are seeing. Can you attach a subset of data in Excel?
Are you using BIDS or SSMS import?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply