tags:

views:

7

answers:

0
Q: 

SSIS Import from Excel - dates in 21-Jun-10 format get inserted as NULL?

I have an SSIS import package that is bringing data into a SQL 2005 database. One of the columns has the date in the following format (dd-mmm-yy) and always gets inserted into the database as NULL. I've tried the destination column as smalldatetime, NVARCHAR, VARCHAR, and always comes in as NULL. I know if edit the column on the sheet to (m/d/yyy h:mm) format it will work, but this is suppose to be an automated job that shouldn't need manual fixes to teh spreadsheet. Any ideas on how to fix this?

related questions

Given a Date Object how do I determine the last day of its month?
Is there an easy way in .NET to get "st", "nd", "rd" and "th" endings for numbers?
VB.NET on Vista, trying to get date (Today) causes security exception
DateTime.Now vs. DateTime.UtcNow
DateTime Utility for ASP.net
Regular Expression to match valid dates
Batch file to delete files older than N days
How Would You Programmatically Create a Pattern from a Date that is Stored in a String?
How do You Build a Date or Calendar Object From a String in Java?
Get Last Day of the Month in Python
How do I get the difference between two Dates in JavaScript?
sql missing rows when grouped by DAY, MONTH, YEAR
What is the regex pattern for datetime (2008-09-01 12:35:45 ) ?
How do i get today's date in C# in 8/28/2008 format?
What's the simplest way to decremement a date in Javascript by 1 day?
How can I format a javascript date to be serialized by jQuery
Ruby / Rails pre-epoch dates on windows
If I have a PHP string in the format YYYY-DD-MM and a timestamp in MySQL, is there a good way to convert between them?
How to display "12 minutes ago" etc in a PHP webpage?
Dealing with PHP server and MySQL server in different time zones
Creation Date of Compiled Executable (VC++ 2005)
T-Sql date format for seconds since last epoch / formatting for sqlite input
Date arithmetic in Unix shell scripts
What is the best way to wrap time around the work day?
Localising date format descriptors