Reputation
8,076
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 21 56
Newest
 Nice Answer
Impact
~526k people reached

Jan
7
reviewed Close PostgreSQL: How to get the column named, data typed, and nullabled of tables in a schema:
Dec
31
comment Why repetition in join queries
What would you expect to see?
Dec
30
revised Table design: how to store denormalized Excel data
Typo was driving me mad
Dec
30
answered Table design: how to store denormalized Excel data
Dec
29
comment Best Practice for SQL Server data validation
How bad are you expecting it to get? Are you just concerned about a a;lskdjfklj showing up in the DebitAmount column or do you have to worry about things like today you get 21 columns and oh look, they have a name of bill in kfc but instead of spaces, the knuckleheads have carriage returns in there?
Dec
28
comment How can I restrict the version of the target DB instance in a SSIS package?
I approve of the general approach but I think you're going to have a much more painful experience with using @@server. Way too much text and permutations therein to deal with. I think they'd be much better served by retrieving the value as the OP originally thought of SELECT SERVERPROPERTY('productversion') AS ProductVersion and then apply your logic via precedence constraints
Dec
28
comment Populate ID Field by Converting Group Name Values
Are you able to add additional tables to the existing database with System Rights/Users
Dec
17
reviewed Close How to design mongodb collection?
Dec
9
comment SQL Server 2014 SSIS Package Ignores Script Task when running as AGENT
One thing you could take a look at is disabling the existing Script Task and then adding a new one that just logs a warning event to show it fired (assumes your SQL Agent invocation has /rep ew attached to it) Code approximately Dts.Event.FireWarning(0, "Test", "Yes, this worked", string.Empty, 0, ref fireAgain); If that works then it becomes a matter of slowing adding the upload code back into it until you find that which breaks it or you've gotten all code in there.
Dec
9
revised SQL Server 2014 SSIS Package Ignores Script Task when running as AGENT
Added additional data from twitter conversation
Dec
7
comment SSIS Package - “Subquery returned more than 1 value” - Inserting one record into a table
The trigger is doing something dumb relative to what the data indicates ;)
Dec
7
comment SSIS Package - “Subquery returned more than 1 value” - Inserting one record into a table
Does the table have triggers on it?
Dec
7
comment SSIS package fails intermittently with: Unsafe assembly 'microsoft.sqlserver.integrationservices.server, version=11.0.0.0
I think I remember seeing this after someone's done a restore of the SSISDB poorly, or they've changed user/owner, etc. Patches rarely hurt though so won't knock you on that point
Dec
7
comment SSIS package fails intermittently with: Unsafe assembly 'microsoft.sqlserver.integrationservices.server, version=11.0.0.0
What else has happened on the box besides patching from SP2 to SP3? Failover in a cluster? New DBA/team administering the box? Virus scanner installed/turned on?
Dec
2
answered Change database used for SQL Server Integration Services logging
Dec
1
comment Copying (hundreds of) tables from one server to another (with SSMS)
Possibly of interest dba.stackexchange.com/questions/30473/…
Dec
1
awarded  Nice Answer
Nov
24
awarded  sql
Nov
21
comment Is there any way to tell which derived column failed?
While not a turnkey solution, when dealing with non-system generated Excel, I favor a script based approach for consuming the data - long and rambling blog post here billfellows.blogspot.com/2013/04/… but hopefully some point before you adopt 2016, I'll have the rewrite of that article complete ;)
Nov
21
comment Is there any way to tell which derived column failed?
An option is to only muddle with a single column in a given derived column. While it sounds dumb and likely to provide poor performance, the opposite is likely true sqlblog.com/blogs/jamie_thomson/archive/2011/01/12/…