First time trying to run one of my data files that I ended up cleaning up with a python script. This was how it looked like before and after the script cleaning. The file original has about 1 million lines in it, but for testing I just ran the script for 400 lines.
Here's how a lines look like (can't post another line cause reputation points)
<http://dbpedia.org/resource/AccessibleComputing> <http://dbpedia.org/ontology/wikiPageWikiLink> <http://dbpedia.org/resource/Computer_accessibility> .
After cleaned:
AccessibleComputing Computer_accessibility
Now i'm trying to run the flat file on Microsoft SQL server management studio 2014, after I import the files this is the error message I get:
"- Executing (Error) Messages Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "# started 2015-04-29T13 36 38Z" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard)
Error 0xc020902a: Data Flow Task 1: The "Source - cleanedlabels_file_txt.Outputs[Flat File Source Output].Columns[# started 2015-04-29T13 36 38Z]" failed because truncation occurred, and the truncation row disposition on "Source - cleanedlabels_file_txt.Outputs[Flat File Source Output].Columns[# started 2015-04-29T13 36 38Z]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. (SQL Server Import and Export Wizard)
Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "C:\Users\Dave\Desktop\database\cleanedlabels_file.txt" on data row 6. (SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Source - cleanedlabels_file_txt returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. (SQL Server Import and Export Wizard)"
I tried numerous things but cannot get it to work. Any help would be great.
User contributions licensed under CC BY-SA 3.0