Monday, March 23, 2009

Fix SQL Server error 0xc00470fe

I ran into this error when trying to import data from a spreadsheet and .csv file to an existing SQL database. The import data wizard was able to create the table correctly, but it wouldn't import any of the existing data. I did a quick Google search and found out that the problem had a pretty simple fix. I thought the server already had integration services installed, but apparently it didn't. In order to import the data, you need to make sure integration services are installed. To do that, just put your SQL Server installation CD in the drive and go through the install process. During the installation, you're given the options for what you'd like to install. Check the Integration Services box and continue. Don't check any others unless you understand what they are and feel that you know what you're doing. Finish the install, then go back and try importing your data again. I bet it'll be ok.

No comments: