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...

Woohoo! My Rangers are moving on. Hoping for a Yankees rally against the Tigers - I don't want us to face Verlander.

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...

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...

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...

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).

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...

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...

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...

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...

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...

If I didn't answer my own questions, the voices in my head would get lonely.

Ninja's_RGR'us (5/17/2011)

---

Nice catch tho, thanks for...

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...

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...

Thanks Gail, that's the nudge that I needed 🙂