Thoughts, tips, tricks, and fixes for the IT person in you. I am an MCSE and support a wide variety of IT-related items at my job, including: Windows OS's, Exchange, Terminal Services, .NET, IIS, OS X, Microsoft Office, printers, phones, Linux, Adobe Creative Suites, and plenty of other hardware and software. Hopefully some of the solutions I find throughout the workday are useful to you as well
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:
Post a Comment
Hi, thanks for choosing to leave a comment. Please make sure that it's relevant to the topic you're commenting on though. If you're just trying to promote another product or webpage, sorry, but your comment will be deleted.