Date format problem using SSIS for Excel into SQL Server -

-

I am trying to import a column of date from a spreadsheet in SQL Server 2005 using SSIS in Excel 2003 I am I am in the UK so I want to format the dates as dd / MM / yyyy.

Unfortunately, the spread of Excel 'date' formatting with a mix of dates stored in the form of wires in DD / MM / YAY (Excel with 'normal' formatting) in the spreadsheet DD / MM / Yyyy (with location 'English (United Kingdom)')

This is just this way and I can not expect that this user will be able to sort himself.

When looking at the spreadsheet, all the dates are visually visible correctly, ie DD / MM / yay

I am trying to import the value into a Holding table in the database in the valcard column. Then I run a stored procedure that copies these values ​​to the appropriate table, which contains a datetime column.

The problem is that the dates are stored in the spreadsheet and the date formatting used in MM / DD / Yyyy in the form of SQL Server and the date stored in the form of DD / MM / YYYY. going. I have the IMEX = 1 in the connection string.

Since the date of using both formats in the same varchar column, I am trying to put in a data time column, so 

  SET DATEFORMAT MDY; Set desaturat

No use.

Does anybody know that the SSIS package will appear in the Excel spreadsheet, why would the correct date import into MS SQL Server as MS / DD / Yay?

Is there no way to force the SDIS package to import the dates in the form of DD / MM / YYYY, which works with date formatting as strings and cells with the combination of dates Will?

Any other thoughts ?!

Many thanks,

Anthony

I think That you answered your question. Import of date formatted cells is considered as stars and others are considered as strings. Maybe you are the date of the SQL server date MM / dd / yyyy and therefore the conversion.

Why do not you try to add a data conversion step in the SSIS package, and convert each format into a format in a column - day by day or string then I'm sure the SQL server is all about them Will handle the same way.

Raj


Comments

Post a Comment

Popular posts from this blog

c++ - Linux and clipboard -

-
After selecting the copies of the buffer in Linux, after the text, we can click and paste the button between the mouse. I think there is a special buffer for this, I want to use it. Programming Language: C ++ Your Library: Qt Thanks. There is just one more correct answer than Paul Dixon, which answers your needs: / P > QClipboard * clipboard = QApplication :: clipboard (); CastString Selected Text = Clipboard-> Text (QClipboard :: Selection);
Read more

What is expire header and how to achive them in ASP.NET and PHP? -

-
I have examined the performance statistics of my website today. I have received a warning (or error may occur) that is given below Add Terminal Headers Here are 15 static components without a 15-futures end date * (no end) Http://www.example.com/video/css/global.css * (no time limit) http://www.example.com/video/js/global.js * (no expiration ) Http: //www.example.com/video/images/main-bg.png what it means and how to achieve it both in PHP and ASP.Net. I am on a shared hosting server, so please tell me some ways to use the code, because I can not make any modifications at the end of the server. If I expire the header, then there is no chance that if I make changes to the CSS, then the user will not be able to remove them immediately because CSS and other files have a fixed time limit (1 month, week ) Are cached for. Is Is there any harm to using PHP? $ time = time () + 3 * 24 * 60 * 60; // 3 day headings ('End:'. GMDAT ('D, D MYH: i: s \ g \ m \ t',
Read more

sql server - How can I determine which of my SQL 2005 statistics are unused? -

-
After a few years, one of my biggest databases has deposited 73 figures out of its largest tables. With Indexes, I can run many types of reports and queries, how often / heavily specific indexes are used. What is an equivalent for data? We are running SQL 2005. To make statistics automatically managed and honest, I would like to "update statistics", "create statistics" and There is no information about any management except "drop statistics" orders. In theory, UPDATE should handle the addition and removal of statistical data. In addition, I've never heard about the amount of storage or storage taking in large amounts, so I'm not sure whether there is any reason for the alarm or not. If you are seeing a potential problem, then I would suggest running an update before, if it does not clean it, it is leaving and then it appears to be safe operation (because it is the only query optimizer Is for). I will not leave "left" in the
Read more