SQL Server 2005 – Importing from a Flat File
With our recent renumbering of every pupil in our district, several applications had to have keys updated. Good times. Unfortunately, our student information is on Oracle and my information is on SQL Server. Rather than bother with creating links and such, a simple import of a two column (old, new) text file and a couple update statements made the process very painless.
Upon running the script, it failed on Validating with:
Validating (Error) Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component “Source – import_txt” (1). (SQL Server Import and Export Wizard)
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component “Data Conversion” (35). (SQL Server Import and Export Wizard)
So, I did the usual—Googled it. I found many resources:
- Is SSIS installed? Yes.
- Is Integration Services (ehh, isn’t that SSIS?) installed? Yes.
- Is SP1 installed? Yeah, SP2!
Everything sounds good… so what’s the catch?
The catch was where I was RUNNING it from. The server had SSIS installed—the WORKSTATION did not. I just run the Client tools. Unfortunately, according to http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1, the SSIS is required no matter what. It says that SP1 fixed this, but… that doesn’t seem to be the case (in this situation).
I moved my text file off to the server and ran it there and it worked like a champ. *grumble*
So, I’m, for now, tossing the Developer tools on my workstation to dink with and see if that solves the problem… and then hunt down the Microsoftie that didn’t ensure that a simple Import/Export can work flawlessly from the client tools.