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

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?
Feb
25
awarded  Cleanup
Feb
25
revised Trying to attach a .mdf with missing .ldf
rolled back to a previous revision
Feb
25
revised Trying to attach a .mdf with missing .ldf
Pushing useful commentary into the question
Feb
24
revised When should a primary key be declared non-clustered?
No need to point out that you haven't read the other answers
Feb
24
revised Trying to attach a .mdf with missing .ldf
no thanks needed
Feb
24
revised How do I set up a Derived Column Transformation to get row number in SSIS 2014?
added 9840 characters in body
Feb
24
comment Upgrade to SQL Server from 2008 to 2012 - Developer perspective
Do not ask the same question on both sites stackoverflow.com/q/28690889/181965
Feb
21
comment How can I invoke an SSIS package from SQL Agent, via T-SQL, using a proxy
I assume you don't want to create N SQL Agent jobs that use the windows ETL credentialed/proxy user to run the packages that then get invoked from the stored proc call? Or to state differently, you're trying to do all the same steps that invoking an SSIS package stored in the SSISDB as a credentialed user but it doesn't work from tsql? (that parses in my head, not sure if it comes through properly)
Feb
19
comment Arithmetic overflow error for type varchar
I think the only mapping that doesn't have the ability to overflow the target type is your LoB column. You store postal code as float in the source. The East coast appreciates this. You then stuff that into a ten character, not varying character field. I think at a minimum you're missing a -0000 along with prepending the lost leading zeros. Your Part/Catalog number column is stored as varying length unicode in the source and this maps into a 34 character type in the destination. There's a binary or text data was truncated error waiting to happen. Float into an int: same issue, diff err
Feb
19
revised Arithmetic overflow error for type varchar
added 5 characters in body
Feb
19
revised Arithmetic overflow error for type varchar
Added create statements, moved the tables to be in the same order as referenced in query
Feb
18
reviewed Approve Shrink Database/Log (growing and non growing)
Feb
18
answered SSIS Transaction Problem
Feb
17
comment SQL Server database corruption in multi-user mode but not single-user mode
given all the nasty things that can happen when you run repair - make it your absolute last choice, not your first choice - always have a good backup strategy
Feb
16
comment Error while running SSIS Package job in SSMS
Alter your jobstep to be /REPORTING EWI Error, Warning, Information. Ohterwise, yes, as Nigel has specified - something is amiss with the SharePoint connection manager. If this is a clustered instance, did you fail over to a new node?
Feb
13
comment Creating joined rows from multiple tables on date field
I've only traced through Donald's values. It appears that someone can have a Payment without a DownPayment. Is the reverse possible: A DownPayment without a Payment record?
Feb
12
comment Azure SQL slow to delete 30K records
Azure SQL Database Service Tiers and Performance Levels If you need better throughput, you need to pay for it. Or your data model is inefficient. Or your queries. Or the .NET methods you're using. It's impossible to tell what percentage each of these factors is contributing to your experience.
Feb
12
comment Azure SQL slow to delete 30K records
I spun up an S0 instance and ran the same script. Only ended up with 1.1M rows and it took significantly longer to populate the table (6 minutes). Deletion was 5x slower, 2:42 but still completed just fine.