Importing data into 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Importing data into 2005

I am trying to import some .dat files into SQL Server 2005. The dates is formatted as such: Sep 4 2003 12:00:00:000AM
Jul 31 2003 12:00:00:000AM etc. Anyways, in SQL Server 2000, this was easy to deal with using the DTS and the convert function. I cant seem to find this capability in 2005. Any suggestions on how to get this data into SQL Server 2005? Thanks. Archer
WE need to use SSIS in sql server 2005(If you installed it during setup)
I am using SSIS, but I keep getting errors because of the strange date format. A
What are errors can you share them with us
True, that will help to find where the problem is and fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Here is the error message that I get from SSIS Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".
(SQL Server Import and Export Wizard) I am truly baffled that Microsoft cant produce a Database product which can EASILY deal with simple f****** text files. Archer