tag:blogger.com,1999:blog-7130587409577087282.post5745488936446485535..comments2024-03-15T23:24:50.847+11:00Comments on David Klein's Corner: Fix SSIS 2008 Error - The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data."David Kleinhttp://www.blogger.com/profile/13657389334766989234noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-7130587409577087282.post-80339309077739042432016-08-15T13:14:31.393+10:002016-08-15T13:14:31.393+10:00Thanks for the post, very help full.Thanks for the post, very help full.Harsh Vardhan Parasharhttps://www.blogger.com/profile/12419091131798375946noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-61421710347629724192016-02-13T06:07:02.482+11:002016-02-13T06:07:02.482+11:00Including the tip above, I also made changes on th...Including the tip above, I also made changes on the Error Output above where I selected 'ignore failure' on the column that contains NULL. The particular column I have is date datatyp and can have NULLs.Cecihttps://www.blogger.com/profile/05604015167025690407noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-60006931668867173722013-05-02T00:02:19.128+10:002013-05-02T00:02:19.128+10:00Thanks for the info.
I am new to SSIS. Inspite of...Thanks for the info. <br />I am new to SSIS. Inspite of checking the check box I still get the following error<br /><br />[Data Conversion [617]] Error: Data conversion failed while converting column "pre_use_amount" (32) to column "pre_use_amount" (786). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".<br /><br />I am not sure if it is happening after processing the last row. If so how do I avoid it. In dataviewer everything look ok<br /><br />SUresh<br />cshttps://www.blogger.com/profile/16247843971278340913noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-7007771840402999452013-05-02T00:02:09.182+10:002013-05-02T00:02:09.182+10:00Thanks for the info.
I am new to SSIS. Inspite of...Thanks for the info. <br />I am new to SSIS. Inspite of checking the check box I still get the following error<br /><br />[Data Conversion [617]] Error: Data conversion failed while converting column "pre_use_amount" (32) to column "pre_use_amount" (786). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".<br /><br />I am not sure if it is happening after processing the last row. If so how do I avoid it. In dataviewer everything look ok<br /><br />SUresh<br />cshttps://www.blogger.com/profile/16247843971278340913noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-51350834537552744802013-02-02T06:21:10.147+11:002013-02-02T06:21:10.147+11:00Hi Guys! where can I find this window? i dont have...Hi Guys! where can I find this window? i dont have much experience in sql and the same error is displayed.. Thank you...Anonymoushttps://www.blogger.com/profile/12876368217471530952noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-75203627099288799082012-06-19T01:22:07.168+10:002012-06-19T01:22:07.168+10:00You sir have made my day. I have been googling for...You sir have made my day. I have been googling for this a long time and it is such a simple solution :-).<br /><br />Thank you! Life saver!deejhttps://www.blogger.com/profile/03566449896517670402noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-87004311236281877152012-05-19T00:23:47.930+10:002012-05-19T00:23:47.930+10:00Oh, man, this was driving me buggy. Thanks!Oh, man, this was driving me buggy. Thanks!Patmanhttps://www.blogger.com/profile/15758436033021957369noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-49057613807442543812012-03-16T02:50:27.971+11:002012-03-16T02:50:27.971+11:00This worked. Thanks :)This worked. Thanks :)Krithikahttps://www.blogger.com/profile/05524213438849065246noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-4537382517359182352010-09-30T08:20:32.880+10:002010-09-30T08:20:32.880+10:00Amazing suggestion mate! You are a genius.Amazing suggestion mate! You are a genius.Unknownhttps://www.blogger.com/profile/14808941633403366282noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-29914584394427698412010-08-04T04:56:30.885+10:002010-08-04T04:56:30.885+10:00Thank You David for taking the Effort to write thi...Thank You David for taking the Effort to write this article. You just save me from one month of pain.Unknownhttps://www.blogger.com/profile/13071248473212422904noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-21829655363250898872010-01-17T08:15:47.633+11:002010-01-17T08:15:47.633+11:00Realy THANK YOU!!!!!!!Realy THANK YOU!!!!!!!qaiscshttps://www.blogger.com/profile/17867921117047761190noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-10403789359647883052010-01-17T08:15:28.613+11:002010-01-17T08:15:28.613+11:00Relay THANK YOU!!!!!!!Relay THANK YOU!!!!!!!qaiscshttps://www.blogger.com/profile/17867921117047761190noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-64451003606782716762009-11-18T12:58:03.555+11:002009-11-18T12:58:03.555+11:00cool, thanks Dave for the hint.
I run in the same ...cool, thanks Dave for the hint.<br />I run in the same issue and also found this post pretty interesting...<br /><br />http://ssisblog.replicationanswers.com/2007/11/24/retain-null-values-vs-keep-nulls--which-to-use.aspxUnknownhttps://www.blogger.com/profile/13731280231311751249noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-26189255241341051882009-09-09T18:36:03.423+10:002009-09-09T18:36:03.423+10:00Thanks PalThanks PalUgur Naciterhanhttps://www.blogger.com/profile/15919580022439661168noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-10882546207256259522009-09-01T22:01:55.980+10:002009-09-01T22:01:55.980+10:00Thank u so much for ur solution :-)Thank u so much for ur solution :-)Samyukthahttps://www.blogger.com/profile/13681188783499373408noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-53541546253400975782009-08-12T05:47:27.371+10:002009-08-12T05:47:27.371+10:00I was pulling my hair out on this today and your b...I was pulling my hair out on this today and your blog post came up in a Google search for [error code 0xC020907F status value 2]<br /><br />I'm so glad you took the time to write this up. Thank you.<br /><br />-JD Long <br />Chicago ILJD Longhttps://www.blogger.com/profile/13671705961117672395noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-8789495070074524802009-07-23T06:43:01.433+10:002009-07-23T06:43:01.433+10:00THANK YOU THANK YOU THANK. I have been searching ...THANK YOU THANK YOU THANK. I have been searching the web looking for a solution. After seeing lots of bad advice/suggestions, I finally found yours.....Anonymousnoreply@blogger.com