Home > Ask the SQL Server Experts > Joe Toscano - Integration Services/Development Questions & Answers > Error importing Excel data to SSIS in SQL Server 2005
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Error importing Excel data to SSIS in SQL Server 2005

Joe Toscano EXPERT RESPONSE FROM: Joe Toscano

Pose a Question
Other SQL Server Categories
Meet all SQL Server Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 05 December 2007
I am just starting to learn SQL Server 2005 and I can't believe how absurdly difficult SSIS is when compared to DTS. I have been trying to import an Excel spreadsheet for two hours (would take me two minutes with DTS) and I continue to get the error: The column can't be inserted because the conversion between types DT_R8 and DT_STR is not supported. I don't even know what DT_R8 is?

I'm using an Excel source and a SQL Server destination. I've tried importing to an existing table and creating a new one. I've tried changing all the cells to text in the spreadsheet. Nothing works. Do you have any ideas for me?


>
EXPERT RESPONSE
Whenever a client has to deliver a file to me that I will need to extract via a DTS or SSIS package, I absolutely always avoid Excel for many reasons. Give me a csv file, a tab delimited file, or a '|' delimited file, but please not Excel. Sorry for ranting…here are some things to try. You can essentially line up the data types so they match. Carefully inspect the data types in your Excel file – especially for the failed column. You can right-click on cells and choose format to view the data types. The destination table's column must match these data types. If they do not, you may consider using the SSIS Convert task to change the data type before the insert.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Joe Toscano - Integration Services/Development
How to convert DTS packages to SSIS and overwrite data
How to migrate DTS to SSIS and deploy SSIS packages
Query to search text in old DTS packages in SQL Server?
Delete .bak files automatically with CLR
DTS package designed to overwrite extract.xls
Displaying a SQL Server database report in Excel
Call triggers in a stored procedure
Stored procedure practices in SQL Server
SQL Server permission to create jobs and schedules in SSIS
Problems with structured exception handling

SQL Server data warehousing/business intelligence
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
Tutorial: SQL Server 2005 Analysis Services
Top 10 SQL Server Integration Services (SSIS) and DTS tips
Open SSIS packages without validation using these SQL properties
How to process SQL Server 2005 Analysis Services for data availability
Export SQL Server data to an Excel file using SSIS and Visual Studio
Five steps to event handlers in SQL Server Integration Services (SSIS)
Workaround to Reporting Services error in SQL Server Express
Optimize SAN setup for improved SQL Server performance
Table partitioning with SQL Server 2005

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
data aggregation  (SearchSQLServer.com)
data preprocessing  (SearchSQLServer.com)
data warehouse  (SearchSQLServer.com)
FileMaker  (SearchSQLServer.com)
GIS  (SearchSQLServer.com)
MOLAP  (SearchSQLServer.com)
pivot table  (SearchSQLServer.com)
Quiz: SQL Server 2000  (SearchSQLServer.com)
SQL  (SearchSQLServer.com)
T-SQL  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts