I get the following error when trying to import (have tried flat files, Excel & Access). I've searched but have not found a resolution. Any help is appreciated. Jeff Validating (Error) Messages Error 0xc00470b6: Data Flow Task: The LocaleID 0 is not installed on this system.(SQL Server Import and Export Wizard) Error 0xc004706b: Data Flow Task: "component "Source - Test1" (1)" failed validation and returned validation status "VS_ISBROKEN".(SQL Server Import and Export Wizard) Error 0xc004700c: Data Flow Task: One or more component failed validation.(SQL Server Import and Export Wizard) Error 0xc0024107: Data Flow Task: There were errors during task validation.(SQL Server Import and Export Wizard)

Thislooks like thebug in the RTM that caused the import/export wizard to fail on flat files when the SSIS engine wasn't installed on the system. If you go back to setup and install SSIS then it should work ok. I think they said they were going to fix it in sp1 but I don't know if it made it.

When I did the intial install I selected all of the client components, the documentation and the samples. I've also installed sp1. If i can launch the Import/Export wizard does that validate the I have SSIS installed? If not, what must I select in setup to install it? Thanks Jeff

Just click on "change" in add/remove programs for sql server 2005 and there's a link at the top for "to install a new component, click here". Go through setup and select "integration services".

Thanks for your help. I went through these steps, did the install but get the same error when trying to import. Jeff

I am experiencing this same problem. Does anyone know of a solution to this. I have uninstalled and reinstalled. Also installed sp1 but does not correct the problem. I get this error with any kind of import/export to/from sql server 2005Thanks

Me too! Error at Data Flow Task [DTSPipeline]: The LocaleID 17 is not installed on this system. Anyone from Microsoft, what's the solution?

What level of SSIS are you using?Initial release, SP1, SP2?

SP1

Installed SP2, same error!

Cool_DBA wrote: Installed SP2, same error!Can you post your specific error?Thanks.

Error at Data Flow Task [DTS.Pipeline]: The LocaleID 17 is not installed on this system. Error at Data Flow Task [DTS.Pipeline]: "component "Flat File Source" (1)" failed validation and returned validation status "VS_ISBROKEN". Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation.

Did you create the data flow, or did a wizard create it?When you view the properties of the Flat File Source component, what is the LocaleID set to and what is your locale?

I created the Data Flow Task. LocaleID = Japanese Where can I check the locale?

Cool_DBA wrote: I created the Data Flow Task. LocaleID = Japanese Where can I check the locale?Do you want it to be Japanese? Or English? Is the file Japanese or English? Or what?

I received this error: Error at Data Flow Task [DTS.Pipeline]: The LocaleID-1 is not installed on this system. Error at Data Flow Task [DTS.Pipeline]: "component "OLE DB Destination" (42)" failed validation and returned validation status "VS_ISBROKEN". Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation. The Data Flow task contains one flat file source, one derived column transformation, and an ole db destination. After setting everything up I went back and removed one unused source column from the flat file output, and received this error.

Hi Guys, I also get that error when trying to import a Greek text file into my sql 2005 server. Error 0xc00470b6: Data Flow Task: The LocaleID 8 is not installed on this system.(SQL Server Import and Export Wizard) Error 0xc004706b: Data Flow Task: "component "Source - greece_POI_txt" (1)" failed validation and returned validation status "VS_ISBROKEN".(SQL Server Import and Export Wizard) Error 0xc004700c: Data Flow Task: One or more component failed validation.(SQL Server Import and Export Wizard) Error 0xc0024107: Data Flow Task: There were errors during task validation.(SQL Server Import and Export Wizard) Does anyone have any idea how to fix it apart from importing the text files into Access database and then back onto SQL Server?

Hi all Had the same kind of problem trying to read a "850 Codepage" file on a Danish OS. The preview shows up nicely with all the national specific characters being displayed correct. However trying touse a flat file source based on the connection in question wouldthrow the following error: "The LocaleID6 is not installed on this system." The following procedure seems to "solve" the problem: 1) Take properties on the flat file source and then change the LocalID to "Default". 2)Close the property window - VS 2005 informs you that the component is not in a valid state - should the component try to fix the errors" 3) Answer "Yes" - et voil Funny thing though - it seems like the "LocalID" property has the same value before and after .... Best regards, Steen

I had the same error, changing the LocaleID from "Default" to the language ofthe table's collation (which is Turkish in my case) solved the problem.

All, I get the following error even before the flat file is created. tried multiple ways to copy data from one database to another but to no avail. Messages Error 0xc00470b6: Data Flow Task: The LocaleID 0 is not installed on this system. (SQL Server Import and Export Wizard) Error 0xc004706b: Data Flow Task: "component "Source - KCEAS_Tran_Header" (1)" failed validation and returned validation status "VS_ISBROKEN". (SQL Server Import and Export Wizard) Error 0xc004700c: Data Flow Task: One or more component failed validation. (SQL Server Import and Export Wizard) Error 0xc0024107: Data Flow Task: There were errors during task validation. (SQL Server Import and Export Wizard) Any help is appreciated. Thanks, Rajendra Naik

Hi Everyone,I had the same problem.I corrected it by mapping a "txt" file, instead of a "csv" file.--> Just rename your CSV flat file into TXT file. Column truncation will still work !

Hi, Same problem here. I wanted to change a few thingsto a package that was working for ages. I changed the data Flow to add a couple more columns and change the destination(oledb data pull from Oracle) then I started to get the error. Impossible to delete the data flow item, Instance not set to an object. I simply rebuild the entire package, it was hopefully quite small and I could still copy paste items from the damaged package to the new one. I think thatthe xml behind the package got corrupted somehow. Nothing to do with LocaleID -1 not installed. That is a missleading error message.

Steen is right, if this error occurs in the data flow source, then you can change the LocaleId to default.It will resolve your issueThanksdsu

Hi, I am having similar problem I guess, trying to import database from sql2005 to sql2008 and I get these errors:- Validating (Error) Messages Error 0xc02020f4: Data Flow Task 1: The column "subdirectory" cannot be processed because more than one code page (1257 and 1252) are specified for it.(SQL Server Import and Export Wizard) Error 0xc02020f4: Data Flow Task 1: The column "depth" cannot be processed because more than one code page (1257 and 1252) are specified for it.(SQL Server Import and Export Wizard) Error 0xc02020f4: Data Flow Task 1: The column "file" cannot be processed because more than one code page (1257 and 1252) are specified for it.(SQL Server Import and Export Wizard) Error 0xc004706b: Data Flow Task 1: "component "Destination - D99_Tmp" (25)" failed validation and returned validation status "VS_ISBROKEN".(SQL Server Import and Export Wizard) Error 0xc004700c: Data Flow Task 1: One or more component failed validation.(SQL Server Import and Export Wizard) Error 0xc0024107: Data Flow Task 1: There were errors during task validation.(SQL Server Import and Export Wizard)Thing is I have little to no knowledge about SQL server so I dunno what a flat file is? and how to change it's properties. And which Import Export wizard should I use? 32bit or 64bit?

Same problem here. I copied some components from one package to another package and i got this error. I changed the locale to the default but no luck so far.. Still looking to resolve this error. Hope that someone can help me. Gr Hennie

I am getting the following same error on two fileds which contains the time stamp in sybase source, when i deselect these two fields the ETL working fine but when i include these having the same problem. Error: 0xC004706B at Data Flow Task, DTS.Pipeline: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_ISBROKEN" i also change the localid to default but no luck!

Hi Phil, I've also got this problem. Using the Import/Export Wizard, I chose my txt file and set the code page to 932 ( Japanese ) and the LocaleID Japan. If I select preview, I can see the Japanese as well as the English writing that appears in my file. ( the file contains both English & Japanese ). When I press Finish the following error appears: Validating (Error) Messages Error 0xc00470b6: Data Flow Task 1: The LocaleID 17 is not installed on this system. (SQL Server Import and Export Wizard) Error 0xc004706b: Data Flow Task 1: "component "Source - Japan Eloqua Contacts_txt" (1)" failed validation and returned validation status "VS_ISBROKEN". (SQL Server Import and Export Wizard) Error 0xc004700c: Data Flow Task 1: One or more component failed validation. (SQL Server Import and Export Wizard) Error 0xc0024107: Data Flow Task 1: There were errors during task validation. (SQL Server Import and Export Wizard) Could you please help me with this, as it is really urgent ??????? Many Thanks

Hey, I got the similar issue, and I got it to work by setting every component's LocaleID to the same parameter, in my case I used English (United States). Hope this helps.