Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can I change the date format when moving a flat file to SQL?

I am trying to copy a flat file into a table in SQL using DTS, but the flat file has been generated by an AS/400 system and the date is formatted like this (yymmdd=051206). At the time of conversion I want it to be formatted into the datetime SQL datatype format. I am developing in VB.NET. Thank you for you assistance on this.
I would recommend reviewing the CAST and CONVERT syntax in order to properly format the date.

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close