Convert date from access to SQL Server with SSIS

Posted by Arne on Stack Overflow See other posts from Stack Overflow or by Arne
Published on 2010-06-15T10:23:12Z Indexed on 2010/06/15 10:42 UTC
Read the original article Hit count: 242

Filed under:

date

|

conversion

|

ssis

|

access

Hi, I want to convert a database from access to SQL Server using SSIS. I cannot convert the date/time columns of the access db. SSIS says something like:

conversion between DT_Date and DT_DBTIMESTAMP is not supported.

(Its translated from my German version, might be different in English version). In Access I have Date/Time column, in SQL Server I have datetime. In the dataflow chart of the SSIS I have a OLE DB source for the access db, an sql server target and a data conversion. In the data conversion I convert the columns to date[DT_DATE]. They are connected like this:

AccessDB -> conversion -> SQL DB

What am I doing wrong? How can I convert the Access date columns to SQL Server date columns?

© Stack Overflow or respective owner

Related posts about date

Javascript Date object expression (Date within date)

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear experts, I was analyzing Javascript codes and came across this line: var date = (new Date()).getDate(); This kinda throw me off? I am pretty new to Javascript and a little curious. >>> More
Populate google.visualization.DataTable for a AnnotatedTimeLine using JSON

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have a HttpHandler which returns some JSON in (i think) the correct format for a google.visualization.DataTable, but the AnnotatedTimeLine fails to work? This is the JSON returned by the Handler: {cols: [{id: 'DATE', label: 'Date', type: 'date'}, {id: 'KEYWORD51', label: 'vw cheltenham', type:… >>> More
Excel: Summing values within a certain date range (> start date and < Finish date)

as seen on Super User - Search for 'Super User'
How do I include a 'Between these dates' criteria inside a SUMPRODUCT? =Sumproduct((RangeName=Cell A1)*(RangeDate=Between 01/03/10 and 31/03/10)*(RangeCost)) What's the way to manage dates (between) in a sum product? Thanks Mike >>> More
Extjs Date Time Picker ,HighLight particular Date instead of system date

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How to highlight the particular date in extjs calender(Date Time Picker) control, As default it will highlight the system date when its shows, i need to set highlight date as sql server date. since it will be different. Is there any property or override method to change the highlight date.… >>> More
Finding date between start date and end date

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I want to check whether a date is between start date and end date. i have added a where class where datepaid between '2010-04-01' AND '2010-04-15' but the problem is that it excludes '2010-04-15'. It should include end date also how can i do this? Please help me on this Regards, pankaj >>> More

Related posts about conversion

Conversion constructor vs. conversion operator: precedence

as seen on Stack Overflow - Search for 'Stack Overflow'
Reading some questions here on SO about conversion operators and constructors got me thinking about the interaction between them, namely when there is an 'ambiguous' call. Consider the following code: class A; class B { public: B(){} B(const A&) //conversion constructor … >>> More
Conversion of bytes into a type without changing the application (ie storing the conversion method i

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to store a conversion strategy (for converting some bytes) into a database and then execute it on the run time. If one were to store a complete java file, you would need to compile it, store the class and some how inject into the already running system. I am not sure how this would… >>> More
General type conversion without risking Exceptions

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on a control that can take a number of different datatypes (anything that implements IComparable). I need to be able to compare these with another variable passed in. If the main datatype is a DateTime, and I am passed a String, I need to attempt to convert the String to a DateTime… >>> More
Create a Unit Conversion Application with the Zend_Measure Component

as seen on Internet.com - Search for 'Internet.com'
Learn how to create a simple conversion calculator using the Zend Framework's Zend_Measure component ... >>> More
Create a Unit Conversion Application with the Zend_Measure Component

as seen on Internet.com - Search for 'Internet.com'
Learn how to create a simple conversion calculator using the Zend Framework's Zend_Measure component ... >>> More