SSIS Date Formats

There seems to be several different data types in SSIS that represent date and/or time. Is there a direct relationship between T-SQL date types and SSIS date types? Is any one of the SSIS date type preferred over the others?

more ▼

asked Oct 22, 2009 at 12:18 AM in Default

avatar image

Tim Mitchell
23 2 2 5

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

MS has a fairly complete listing of SSIS data types and how they map to data types in SQL Server and other database systems (Oracle, DB2, and Jet).

Here are some of the SSIS date data types that map directly to SQL Server date data types

DT-DBDATE -> date
DT-DBTIME2 -> time(p)
DT-DBTIMESTAMP -> datetime, smalldatetime
DT-DBTIMESTAMP2 -> datetime2
DT-DBTIMESTAMPOFFSET -> datetimeoffset(p)

I don't know that a particular SSIS date data type would generally be preferred over the others. I would say to prefer the SSIS data type that best represents the dates and/or times you are working with and that most closely matches the SQL Server data type you are trying to represent.

more ▼

answered Oct 22, 2009 at 01:00 AM

avatar image

25k 3 13 20

(comments are locked)
10|1200 characters needed characters left

Does SQLL2008 SSIS really support DT_DBTIME2? I can only find DT_DBTIME as a data flow type, DT_DBTIME2 only exists as a cast type in the derived column component, but can't be used outside of it, for example in a SQL Server Desitination.

more ▼

answered Mar 07, 2010 at 11:45 AM

avatar image


(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 22, 2009 at 12:18 AM

Seen: 10805 times

Last Updated: Oct 22, 2009 at 12:18 AM

Copyright 2018 Redgate Software. Privacy Policy