question

sunil2711 avatar image
sunil2711 asked

SSIS Excel-SqlServer

I have a date in a sql server table defined as datetime. I'm improting that into an excel column defined as DT_Filetime. Some of these dates may be null. , I can't get the null values to import into the sql server date field
sql-server-2008ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sunil2711 avatar image
sunil2711 answered
Sorry Importing from excel I have a date in a sql server table defined as datetime. I'm improting from excel to sqlserver table Some of these dates may be null. , I can't get the null values to import into the sql server date field
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.