Reputation
6,185
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 18 47
Newest
 Caucus
Impact
~388k people reached

Apr
21
comment need to find instances which have multiple rows with the same userID and ResourceID and have a location of 1 and also have other locations
Have you looked at Entity Framework?
Apr
14
comment SQL Job to be run earlier on last work day of month
Always schedule it at the month end time. The first step of the job is a TSQL script that detects whether it is month end. If not, WAITFOR DELAY '02:00:00.000'; That delays it 2 hours. If you need more time, then you change that value
Apr
14
awarded  Popular Question
Apr
13
comment Decimal Data Type as Primary Key
In your Data Flow between your data source and the destination, double click the line connecting it and select Metadata. What data type, precision, scale does it display for the testID column?
Apr
13
revised Decimal Data Type as Primary Key
added 53 characters in body
Apr
9
comment How to set MSDN in order to open on a certain version of Microsoft SQL Server?
The other approach I'd propose is make 6 bookmarks, covering 2000 - 2014, and put that on a network share. New server, add it to the All Users/Default Users bookmarks. If you absolutely must eliminate thinking in the users mind, I'm sure a wee bit of PowerShell could correlate the SQL Server version to the bookmark file and only import the appropriate one. But seriously, that's a terrible idea. If you're responsible for the administration of my servers, you'd darn well better have your thinking hat on
Apr
8
comment How to set MSDN in order to open on a certain version of Microsoft SQL Server?
By MSDN, are you asking about opening your browser to Books OnLine documentation for the appropriate version of your SQL Server Version? If so, what if you have a mixed installation on the machine?
Apr
3
comment Problem running SQL Server 2014 SSAS in an SSIS package
sqlservercentral.com/blogs/dknight/2009/03/02/… Is the source data identical in QA as it is to Prod?
Apr
2
comment Why does an SSIS package fail when executed from the IS Catalog?
Might be worth a support ticket with MS. Sounds odd to me. Otherwise, I'd try to reduce the memory footprint of the package(s) by reducing the number of concurrent operations, removing async components from data flows, etc but that's only treating the symptom and not the root cause (as you likely already know)
Mar
28
comment Executing stored procedures asynchronously using tasks in SSIS
"From what I have read" point me to the link please
Mar
27
comment Treat database field as a flat file source
And no, you can't use a "Flat file source" because that's for items on the file system. Instead, since you need to access a database table-like object, you'll be looking at an OLE DB Source or an ADO.NET Source depending on your connection managers
Mar
27
comment Treat database field as a flat file source
Is there a reason you can't just pop it off Service Broker directly?
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