To identify what specific task or event is the bottleneck, you can look at the SSIS Executions report.

\'Integration Services Catalogs'

\SSISDB

\ProjectName (typically name of your package)

Right click on project

Reports..

All Executions..

Also, the...

Erland Sommarskog maintains an article describing various techniques and considerations for implementing this type of generic search procedure where the entities, predicates, and parameters are broadly defined.

Dynamic Search Conditions...

If your application needs to join Customers with PurchaseOrders, and your Customer table on ServerA, and your PurchaseOrder table on ServerB, then that architectural decision itself has forced you down...

I don't know much about how those time traveling DeLoreans work, but...

Anyone here deer hunt?

Any tool that can present an input form and execute a stored procedure call can be used for this. Actually, your existing reporting tool probably has limited capability for this....

It's 2016, and folks are still coding really bad T-SQL. The problem is that many organizations see T-SQL coding simply as an extension of C# or Java coding. Those of...

I'm a bit of a handy-man both around the house and the database server at work. Just like duct tape, I consider PowerShell to be an essential tool for a...

You'll want to setup an extended event trace to audit any permission denied related errors resulting attempts by applications to execute direct SQL statements. However, if we're just talking about...

First, it's unclear whether you know the basic concepts of dimensional modeling, requirements gathering, or ETL at this point. So before you start building anything, I highly recommend you read...

A "crash" is a series of events, not a single moment in time. You need to know an ideal point in time for which to perform a transaction log restore?

It's hard to believe there are 1 billion active yahoo email accounts. 100,000,000 of them are probably drop boxes for phishing scammers.

Remember when Microsoft offered to buy Yahoo for $45 Billion back in 2008? Yahoo said no, because they felt the deal was undervalued.

David.Poole (12/15/2016)

---

A particularly well timed editorial given the massive failure of Yahoo to secure it's customers data or behave appropriately in response to an immense hack as reported on BBC...

If the two servers are located on-premises, like in the same rack or server room, then perhaps you can connect them directly using a crossover network cable.