Reputation
6,005
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 16 46
Impact
~323k people reached

10m
comment Rearranging Data in an MS Access 2007 table into a new column
How does WATI SMITH match NAUMI WILLIS?
1d
comment how to disable and enable SSIS package using commandline?
To disable an entire package, you don't run it. To enable it, you run it.
Apr
23
revised Repair SQl server 2000
perts = experts? At any rate, salutations not needed
Apr
23
comment Repair SQl server 2000
I assume you realize just what a pickle you're in by being on a product that's been out of extended support for 2 years now. Is it your installation that is bad or do you have a database that needs to be repaired?
Apr
23
comment SSIS Packages get stuck in SQL Agent jobs
Sounds like there may be a hiccup communicating with AD since all the instances go squirrelly around the same time. Anything of interest in the Event Viewer?
Apr
23
revised How can we restore shipped transaction log files in SQL Server 2012 to an online (being used) database without stopping the DB?
Corpse shaving preferable to yak shaving
Apr
22
comment Problem running SSIS package remotely using PoSH
Always gotta go after the low hanging fruit on questions... What happens if you change that dtexec call to C:\Windows\System32\notepad.exe Just to ensure that yes, it's not some weird permission/pathing issue. After that, it's a toss up between "what's the package's protection level" versus "is there something weird about the package - custom/3rd party components, Script task, legacy ActiveX/DTS task involved"
Apr
22
comment Problem running SSIS package remotely using PoSH
I assume \\unc\ssis_package.dtsx is really \\unc\share\ssis_package.dtsx
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
19
reviewed Reject Stored procedure
Apr
17
comment How to see the reject/re-direct reason for rows in SSIS? (row-level)
Duplicate once it reaches SO stackoverflow.com/questions/29676294/…
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