February 19, 2008 at 12:52 pm
Error 0xc0202055: Data Flow Task: The column delimiter for column "Customer Type Description" was not found.
(SQL Server Import and Export Wizard)
· Error 0xc0202092: Data Flow Task: An error occurred while processing file "Z:\Customer Master BIW_Roxane.csv" on data row 44870.
(SQL Server Import and Export Wizard)
· Error 0xc0047038: Data Flow Task: The PrimeOutput method on component "Source - Customer Master BIW_Roxane_csv" (1) 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.
(SQL Server Import and Export Wizard)
· Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited with error code 0xC0047038.
(SQL Server Import and Export Wizard)
· Error 0xc0047039: Data Flow Task: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
(SQL Server Import and Export Wizard)
· Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC0047039.
(SQL Server Import and Export Wizard)
this is the error i got plz help me out in dng this where i can find the problem and the file is flatfil in comma delimited and text file is double quotation and ...it shows error ..thkz in advacne
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
February 19, 2008 at 1:25 pm
It would help if you posted some sample data and details as to what you are doing.
I find the error quite easy to understand. On row 44870 the column "Customer Type Description" is not being found. Have you tried opening the file in a text editor and examining ro2 44870?
You could also use BIDS to manually create the import and send the error row to a file destination and identify the porblem there.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 19, 2008 at 1:32 pm
i have done that but i cpuldnt find any problem any way how should i do that will u plz tell me my data in row 44870 is
"Customer Number","State","SIC","SIC Description","Customer Name","Street Addr Line 1","City Address","Zip Code","Dea Id","Street Addr Line 2","Bill To Only Id","Direct Purchase Ind","Customer Status","Customer Status Description","Customer Type","Customer Type Description"
49320,"WA","01","Nursing Homes","EAR NOSE & THROAT ASSO","1005 W WALNUT","YAKIMA","98902","AE1019543","SUITE 101","0","0","3","Closed/Out Of Bus Account","HN","Nursing Homes Ext Care"
thats the data in that plz help me dng that
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
February 19, 2008 at 1:45 pm
I agree with Jack. Some sample would really help. By the way, here is what I would suggest. I had this same problem long ago when I started using SSIS. First of all, what is delimiting your data? Is it, pipe delimited (|), comma(,) or double quotes("). Sometimes, you have to enter this in the delimiter section to get the data nice and clean as an output. If you know that, then try it, otherwise, try to upload some sample for us to take a look at.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
February 19, 2008 at 1:48 pm
kurraraghu (2/19/2008)
i have done that but i cpuldnt find any problem any way how should i do that will u plz tell me my data in row 44870 is"Customer Number","State","SIC","SIC Description","Customer Name","Street Addr Line 1","City Address","Zip Code","Dea Id","Street Addr Line 2","Bill To Only Id","Direct Purchase Ind","Customer Status","Customer Status Description","Customer Type","Customer Type Description"
49320,"WA","01","Nursing Homes","EAR NOSE & THROAT ASSO","1005 W WALNUT","YAKIMA","98902","AE1019543","SUITE 101","0","0","3","Closed/Out Of Bus Account","HN","Nursing Homes Ext Care"
thats the data in that plz help me dng that
I guess you replied the same time I was answering your post. Anyway, I see that your separator is double quotes. In the delimiter section of your flat file, key in double quotes like this: "
Now try it, you should be able to do it.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
February 19, 2008 at 1:50 pm
I don't see anything amiss in that data and I was able to load it without issue. I think the best thing is to manually build a package to do the load and redirect error output to another file so you can see the errors.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 19, 2008 at 1:54 pm
Ok. I think I see what your problem is. Okay, now, do you have any condition on that specific column? Like should it be null or something. Then just scroll down on that particular column to see if there are some weird looking data. You can do this in the flat file transformation itself by clicking preview. But in order to get to the specific row, I think you should take Jack's advise and open it elsewhere first so that you can navigate to the row you know you have problem with.
Or see if you can export to an excel destination and go there to see your data's fault. Hoping this is good amount of information for you!
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply