Reputation
6,160
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 18 46
Newest
 Yearling
Impact
~368k people reached

Mar
26
revised Applying Quotes Across Multiple Lines
Let's make an authoritative answer
Mar
21
answered SSDT on VS2013 for SQL Server 2012
Mar
19
awarded  Strunk & White
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
Careful man, there's a beverage here
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
Using / reduces the likelyhood of someone failing to escape their paths in languages and scripts that use the backslash character for character escape sequences
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
@swasheck It is general advises between the two
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
Windows uses \ as a directory separator. Linux uses / as a directory separator
Mar
17
comment How can I invoke an SSIS package from SQL Agent, via T-SQL, using a proxy
FWIW, I happen to script out the create_execution procedures and yeah, I'm guessing somewhere with all the impersonation and reverts in there things go poorly. I suspect Agent has a different mechanism, similar to a RunAs that allows it to not get fouled up whereas the TSQL impersonation does. shrug
Mar
13
comment Run SSIS Package as different user
Doesn't this assume that they are using SQL Server Authentication when they specifically mentioned "run as a different windows account and not a SQL account."
Mar
13
answered Run SSIS Package as different user
Mar
13
awarded  Notable Question
Mar
12
comment Efficently Remove 90% of a table's data
Contributing nothing of value except that your 10% reminded me of this comic
Mar
10
revised How do I get the difference in minutes from 2 timestamp columns?
common sense for dummies
Feb
27
reviewed Close SQL CLR in MySQL?
Feb
27
reviewed Close How to reinstall a legacy DB2 Server 7.x for Linux?
Feb
27
reviewed Leave Open SSIS Merge Join Error
Feb
27
reviewed Close Too big database file 90GB
Feb
26
answered One SQL Server. One SSIS. Two versions of DTExec.exe?
Feb
26
comment SSIS Transaction Set to Required giving error
You marked your previous question on the same topic as resolved. I assume it's still going to be a DTC issue.
Feb
25
comment Error while executing SSIS package which contains Script component through SQL Server Agent Job
What does the script do? Smells like it's talking to a web service. Does that service require authentication and if so, does the account that is executing the package have permissions? Does it expect a wsdl at some location there isn't one? Did the devs create a custom DLL that needs installed on the server? Has this ever worked on the machine in question? Does it work anywhere?