Viewing 15 posts - 106 through 120 (of 682 total)
No doubt, Verlander is the linchpin. I've said all along that I'd rather face the Yankees and all that brings with it rather than seeing Verlander. They'd almost...
October 8, 2011 at 4:15 pm
I'm with you on the Brewers. I still like the Rangers to go all the way (though I'm certainly biased) - they've been riding a huge wave since early...
October 8, 2011 at 4:05 pm
Woohoo! My Rangers are moving on. Hoping for a Yankees rally against the Tigers - I don't want us to face Verlander.
October 4, 2011 at 3:18 pm
That was quite a game in New York. I held on until the 12th inning and couldn't keep my eyes open any more 🙂
As a Rangers fan, right now...
September 26, 2011 at 7:29 am
I almost always use SSIS for ETL processes. That said, I'll often call stored procedures from an Execute SQL task in SSIS. If the business logic I need...
September 21, 2011 at 7:43 am
Either the Data Conversion or the Conditional Split would work for this. Try to convert the value to the appropriate type, similar to:
(DT_I4)[input_column_name]
If the cast is successful, the integer...
September 21, 2011 at 7:36 am
See also SQLShare.com. Lots of short, targeted videos on how to accomplish a specific task in SSIS (as well as other areas of SQL Server).
September 21, 2011 at 7:23 am
Import/Export wizard does not automatically handle referential integrity. As you mentioned, the proper way to handle this is to load the reference tables first, and then load the table...
September 21, 2011 at 7:22 am
It's been a while, but I ran in to the same issue - the service account had full rights to the folder, but couldn't access the file. After digging...
June 30, 2011 at 8:51 pm
When you say you need to read in 10 files at once, I assume you mean that want them to run in parallel?
If your workplace/project is open to purchasing third...
June 23, 2011 at 11:09 am
I doubt that the issue is with SQL Server permissions. Again, I suspect your encryption software (GPG). I'd recommend running through their documentation (or support forums, if they...
May 18, 2011 at 8:06 pm
litsonjose,
I've not used the GPG tool specifically - when I need command line en/decryption, I've used PGP in the past. However, on the PGP command line there is a...
May 18, 2011 at 7:18 am
Ninja's_RGR'us (5/17/2011)
No fair... you're not supposed to answer your own questions.
If I didn't answer my own questions, the voices in my head would get lonely.
Ninja's_RGR'us (5/17/2011)
May 17, 2011 at 11:30 am
Update:
Mark Broadbent (http://twitter.com/retracement) pointed out to me that BOL references this in the documentation. Specifically, overriding the ANSI_NULLS setting has no impact on INNER JOIN operations. I was...
May 17, 2011 at 10:36 am
Who knows how long this will last, but my Rangers are clobbering all comers! Haven't made it out to a game yet (and probably won't, until after SQL Rally...
April 11, 2011 at 7:46 am
Viewing 15 posts - 106 through 120 (of 682 total)