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

9h
comment How to archive a whole database?
No, do not go route #2. Take a backup and after taking the backup, verify it. When you detach, you don't know whether the database was corrupt at that point in time. If it was, you may be toast attempting to re-attach it
May
15
comment How to create content with c# for microsoft office word. can you help me?
If your question is on how do I pull data from a database and insert it into Word, then you need to click the edit button and describe what you're doing, what you have tried and what issues you have doing so. google.com/translate can probably help with the language barrier
May
15
comment How to create content with c# for microsoft office word. can you help me?
This site is focused on English. I don't believe the stack exchange network has any Turkish language focused subsites. This one is also focused on database technologies of which C# and Word are not a subset
May
11
comment SSIS Package Security
Help me understand then, what would secure development look like as opposed to secure execution
May
10
answered SSIS Package Security
May
6
comment Issuing Inserts/Updates to Progress OpenEdge via ODBC
There may be error messages posted before this with more information on why the AcquireConnection method call failed <- were there additional messages? SELECT * FROM ssisdb.catalog.operation_messages AS OM WHERE OM.message_type = 120 AND OM.operation_id = @MyLastRun;
May
6
comment Issuing Inserts/Updates to Progress OpenEdge via ODBC
FWIW, the openquery syntax generally gives better performance with filtered queries because it pushes the filter to the source system. The 4 part query can result in all the data being pulled back to SQL Server and then the filter is applied. Syntax for openquery may be a little wonky but I'll take that over the performance drag. Never mucked about with pushing updates though
May
5
revised Calculating values from three related tables, without using join or union
receved
May
5
answered Calculating values from three related tables, without using join or union
May
5
comment Calculating values from three related tables, without using join or union
Someone has placed an unreasonable constraint upon you and your solution. Instead of using the correct tool for the job, a relational query, you must extract the data into some external tool, like Excel, or craft a specific program, C#/PowerShell/etc, to extract all the data from the tables and perform the "join" logic in there which is silly and inefficient
May
5
comment Calculating values from three related tables, without using join or union
You have a relationship between 3 tables. You cannot simply sum the quantities per table and add them together as that would merely reflect the total quantity available. What you are likely asking for is the quantity available by item
Apr
29
comment Tracking row level status of SSIS ETL process
Yes. This can be done. However, your question needs details to be answerable. SSIS 2012/2014 in project deployment model? If not, have you enabled logging within your SSIS packages? Do you have a framework built out for tracking execution of your packages? etc, etc etc
Apr
29
answered How to format SSIS Expression for weekend
Apr
28
comment SSDT Schema Compare doesn't work while a BULK INSERT is in progress
As with everything in development, there are trade offs. If you want to shove the maximum amount of data into a table, you need to ensure no one sticks a finger in there and it gets chopped off due to moving parts. That's what the locks are trying to do and that's a good thing. Unless I have a reason not to, I always lock my tables for loads. I then make sure my data flow is well tuned so that I don't have a table locked for hours on end. Locks can escalate to table locks once a documented threshold has been passed.
Apr
28
comment SSDT Schema Compare doesn't work while a BULK INSERT is in progress
Could you perhaps better explain why the schema comparison must run in parallel with a load operation? Perhaps an alternative is to have a reference model of the database. No data, just schema. Run your comparisons against that and then ensure that no one modifies the actual database where these bulk ops are being performed without first updating the reference model.
Apr
28
comment SSDT Schema Compare doesn't work while a BULK INSERT is in progress
Internals are not my forte but as I understand it, you have a lock on the table. Whatever lock is taken is for the bulk insert is incompatible with the lock(s) required to validate the schema. Relevant reading BOL Schema lock
Apr
27
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
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
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