No announcements
Found 825448 threads
-
0 Votes
SSIS unable to handle Numeric with 30 precision
I do not know if you are on a more recent SSIS build.Answered | 2 Replies | 468 Views | Created by Vikas.Garg - Thursday, July 6, 2017 9:50 AM | Last reply by Vikas.Garg - Friday, July 7, 2017 10:48 AM -
0 Votes
Precision problem on division of two numeric values.
As Rishab said the statement Cast(@PoSumExcVAT As numeric) will be evaluated to 746909 instead of 746909.28.Answered | 3 Replies | 3285 Views | Created by Yogesh Bhadauriya - Friday, July 29, 2011 8:02 AM | Last reply by Surendra Nath GM - Friday, July 29, 2011 8:58 AM -
0 Votes
MSSQL 2008 Precision Problem
BEcause, SQL Server allows a max of precision value of 38 only in case of decimal/numeric.Answered | 3 Replies | 1828 Views | Created by Dilek Uslu - Wednesday, January 22, 2014 7:54 AM | Last reply by Dilek Uslu - Thursday, January 23, 2014 11:38 AM -
0 Votes
Precision not valid Error
Hi Saurabh, there is always a problem with this oracle number to SSIS numeric data type conversion. i will suggest you to first save this oracle number as string and then ...Answered | 3 Replies | 3264 Views | Created by Saurabh Trivedi - Wednesday, July 22, 2009 5:15 AM | Last reply by Duane Douglas - Thursday, July 23, 2009 5:05 AM -
0 Votes
SSIS OLE DB source connection and precision
I am setting up our DR SSIS enviroment and copied the packages from the production server to the DR server and am experiencing Validation warnings on the DR server but not recieving them on ...Answered | 1 Replies | 4116 Views | Created by Richard Tracy2 - Monday, January 31, 2011 10:41 PM | Last reply by Josh Ashwood - Monday, January 31, 2011 10:58 PM -
0 Votes
Value In Field Bigger Than Data Type Precision SSIS
Hi, I have a field in derived columns (SSIS) that should present the unit net price in local currency.Answered | 1 Replies | 341 Views | Created by emveha86 - Tuesday, July 18, 2017 12:59 PM | Last reply by ArthurZ - Tuesday, July 18, 2017 2:10 PM -
0 Votes
Converting from NVARCHAR to NUMERIC in SSIS
AS NUMERIC) Regards, Mike Yin TechNet Community SupportAnswered | 2 Replies | 5691 Views | Created by lilutchay - Monday, May 13, 2013 1:21 PM | Last reply by Mike Yin - Friday, May 17, 2013 4:43 AM -
2 Votes
Problem with numeric precision with DECIMAL(28,14) variables
I see that I run against the upper precision limit of 38.Answered | 7 Replies | 6132 Views | Created by pstr - Wednesday, September 2, 2009 9:08 AM | Last reply by Ewan - Wednesday, September 2, 2009 2:58 PM -
0 Votes
future 128-bit integer data type for high precision, numeric processing
was curious if there are plans for a "double-LONG" data type in VB.net (or any of the visual studio 20xx components), some high precision calculations cause 64-bit LONG ...Answered | 2 Replies | 1343 Views | Created by tcbeckrd1 - Wednesday, December 9, 2015 7:48 PM | Last reply by Brian Muth - Wednesday, December 9, 2015 10:54 PM -
0 Votes
SSIS + Error Handling
Hello, If you have scheduled a job to run the package say every 30 mins, then you should expect at least 48 mails a day.Answered | 2 Replies | 1488 Views | Created by swathit544 - Wednesday, May 29, 2013 11:39 AM | Last reply by RWP - Wednesday, May 29, 2013 1:37 PM -
0 Votes
SSIS Process Handle Count
Even after DTExec.exe and DTSHost.exe have exited, the handle held by the SSIS Service may not be immediately released.Answered | 6 Replies | 7526 Views | Created by The Sinister China Penguin - Friday, January 22, 2010 1:01 PM | Last reply by ClaudioG64 - Saturday, January 22, 2011 2:05 PM -
2 Votes
numeric overflow in vfp
" The reason behind it is, internally, in memory, all numeric types are handled as double, there is even no int variable in foxpr, you can only set variable = ...Answered | 3 Replies | 8046 Views | Created by Creative_Pro - Friday, March 16, 2012 5:32 AM | Last reply by Rich Pupko - Friday, March 16, 2012 6:19 PM -
0 Votes
Numeric column in dbf
Well, more precise about the Jet engine, which exists independant of Access.Answered | 2 Replies | 2179 Views | Created by BONIETE - Wednesday, November 4, 2015 10:18 AM | Last reply by Olaf Doschke - Thursday, November 5, 2015 8:44 AM -
0 Votes
How to Handle Bad Rows in SSIS?
Hi, look at my post here about how to handle bad rows:Answered | 8 Replies | 9117 Views | Created by cmk1 - Friday, August 6, 2010 2:50 AM | Last reply by cmk1 - Friday, August 6, 2010 3:15 PM -
0 Votes
ssis exception handling
Hi ajay singh rawat, Please refer to the following link: Error Handling in SSIS: ...Answered | 6 Replies | 3262 Views | Created by Ajay Singh Rawat - Tuesday, November 8, 2011 6:47 AM | Last reply by Eileen Zhao - Friday, November 11, 2011 8:59 AM -
0 Votes
defining max precision for numeric in sql server 2005
Hi, In this case, you would define numeric(38,25).Answered | 2 Replies | 4080 Views | Created by madhur_ms - Monday, September 19, 2011 8:34 AM | Last reply by madhur_ms - Monday, September 19, 2011 10:01 AM -
2 Votes
Error handling loss of precision.
however, since it seems to obfuscate the most important part of my errors, I reverted to the old error handling method.Answered | 4 Replies | 3079 Views | Created by Antoine F - Friday, December 16, 2011 10:32 PM | Last reply by Antoine F - Monday, December 19, 2011 9:23 PM -
0 Votes
Unable to eliminate non-numeric values before CAST as numeric
When ISNUMERIC() = 1, you know the value can be successfully converted to some numeric value (int, bigint, money, float, decimal etc).Answered | 8 Replies | 1706 Views | Created by JackJHolmes - Tuesday, June 3, 2014 12:57 PM | Last reply by JackJHolmes - Tuesday, June 3, 2014 3:23 PM -
0 Votes
Examples of Errors SSIS can handle
Guess my understanding of Error handling wasn't totally right.Answered | 16 Replies | 6084 Views | Created by Thimmana - Thursday, January 13, 2011 3:15 PM | Last reply by Nik - Shahriar Nikkhah - Thursday, January 13, 2011 8:33 PM -
0 Votes
Handling unexpected data in SSIS
Answered | 2 Replies | 571 Views | Created by Manibala - Tuesday, April 12, 2016 8:05 AM | Last reply by Eric__Zhang - Wednesday, April 13, 2016 6:40 AM - Items 1 to 20 of 825448 Next ›
No announcements