Viewing 15 posts - 2,401 through 2,415 (of 5,685 total)
Out of curiousity, OP... Usually the older systems were heavily tuned and something 'tipped', or something new exploded (which wouldn't be on 32bit, these days). Do you use a...
October 27, 2011 at 5:37 pm
There's a 'redirection' choice on OLEDB Target.
Open the target, on the left, go to Error Output. Chose 'Redirect Row'.
Send that row off to a simple flatfile or something, or...
October 27, 2011 at 5:27 pm
Elliott Whitlow (10/27/2011)
Evil Kraig F (10/27/2011)
Elliott Whitlow (10/27/2011)
You can install SSIS without installing the database engine.
True, just still need to have equivalent licensing as though you had installed the full...
October 27, 2011 at 2:57 pm
randy.worrell (10/27/2011)
My SQL experience has been from SQL Server version 6.5 forward, but never in a DBA sense.
That'll be problematic.
Why problematic?
DBAs are the first and last line of defense. ...
October 27, 2011 at 2:24 pm
Elliott Whitlow (10/27/2011)
You can install SSIS without installing the database engine.
True, just still need to have equivalent licensing as though you had installed the full engine... At which point, why...
October 27, 2011 at 2:19 pm
Hey Ki,
Well, with how convoluted this query is nothing's obvious yet. Some questions.
Considering the sample data, should I be expected a result set that looks like this?:
9662010-04-12 00:00:00672714756
11602010-03-08 00:00:00672714756
26882010-07-19...
October 27, 2011 at 2:15 pm
Tom Brown (10/27/2011)
Thanks for the comments Craig?? II's :unsure: Whats an II? (Some DBA shorthand for developers perhaps Ignorant Idiots?, Itinerant Interns? Infernal Irritants? )
LOL, no, not exactly... Out...
October 27, 2011 at 2:03 pm
venoym (10/26/2011)
October 27, 2011 at 1:54 pm
randy.worrell (10/27/2011)
But in an entry level situation, fresh out of college, would someone with an MBA degree with MIS have any advantage over someone with a Bachelors degree?
Only if they're...
October 27, 2011 at 1:45 pm
Regarding Peer reviews:
- Remember the audience. Their attitude will control your approach as much as anything else.
- If you see something that seems odd, particularly strangely optimized code, simply...
October 27, 2011 at 1:37 pm
Kiara (10/27/2011)
GSquared (10/27/2011)
Kiara (10/27/2011)
Sending you a PM, rather than clutter up the Thread...
The Thread lacks clutter???????????????????
Y'know, when I wrote that, I sort of shook my head at myself...
Today, on Hoarders!...
October 27, 2011 at 12:34 pm
bkmooney (10/26/2011)
I ended up having to create a new connection to the csv file, but then the if statement worked.Thanks!
My pleasure, happy to help. 🙂
October 27, 2011 at 12:14 pm
mail.lists (10/26/2011)
The first question I have is, how does one determine if it is necessary to separate them?
The same way you decide if any instance needs to be...
October 27, 2011 at 12:04 pm
Needs one additional answer: "It Depends"
Dynamic SQL in the middle of a proc will have little difference to the affect if intelligently parameterized for cache reusage.
Dynamic SQL from OUTSIDE...
October 27, 2011 at 12:00 pm
When a job fails and the BIDS works first culprit is almost always security. Check the login for the SQLAgent and confirm that login has the necessary rights, unless...
October 27, 2011 at 11:53 am
Viewing 15 posts - 2,401 through 2,415 (of 5,685 total)