Viewing 15 posts - 10,936 through 10,950 (of 13,877 total)
You added an extra decimal place and that was just enough to highlight the rounding issues associated with the Numeric data type, which is what STR assumes.
January 20, 2012 at 2:28 am
raiserror('Your master data table has been truncated. Please have a quiet chat with your DBA', 1,1) with nowait
Read BOL to make sure you understand the concepts behind the...
January 18, 2012 at 9:24 am
Does the stored proc include Try ... Catch and RaiseError error trapping?
If not, you could try implementing that and see if it does what you wish.
January 18, 2012 at 8:58 am
subahan_syed (1/18/2012)
I'm looking to import multiple excel sheets in one file into multiple SQL tables using SSIS, at the end of the package run, I want to move the...
January 18, 2012 at 7:01 am
GilaMonster (1/18/2012)
Gazareth (1/18/2012)
And Wikipedia's "block" appears to be the equivalent of a hand-written sign hanging on an open door saying "We're Closed, honest." :hehe:
Intentionally.
http://en.wikipedia.org/wiki/Wikipedia:SOPA_initiative/Learn_more
Is it still possible to access Wikipedia...
January 18, 2012 at 5:26 am
Can we 'do a Wikipedia' on this thread and block it? Permanently.:hehe:
January 18, 2012 at 3:25 am
Hi Sean and thanks for the response.
My point is that using Object Explorer to connect works as you would expect (with colour coding from Registered Servers) unless that colour coding...
January 17, 2012 at 11:05 am
I know that this is an old thread, but I think it's the best place...
I've just been caught out by this - luckily nothing major, but still a production server...
January 17, 2012 at 10:14 am
public2 61705 (1/16/2012)
And no,...
January 16, 2012 at 2:12 pm
Elliott Whitlow (1/16/2012)
January 16, 2012 at 9:59 am
public2 61705 (1/16/2012)
January 16, 2012 at 9:58 am
Are you hoping to give this functionality to users? Or is it just a package which a developer will run interactively from within Visual Studio?
January 16, 2012 at 9:33 am
Right click the relevant SQL Agent job and View History - you should be able to get a more detailed error message there. Please post it.
January 16, 2012 at 5:41 am
Somewhere in there (I don't have SSIS in front of me), there is a list of objects to transfer - you just have to expand a few properties. Keep looking!
January 11, 2012 at 2:40 pm
Check out the various properties of the Transfer task - that is where the tables will be specified. It might not be doing a truncate - rather a delete/recreate (I...
January 11, 2012 at 2:17 pm
Viewing 15 posts - 10,936 through 10,950 (of 13,877 total)