Activity overview
Latest activity by Jon_Shaulis
thoov, I want to say they have Data Compare, SQL Compare, and SQL Clone that can probably get you close or are at least worth researching. In the past when I have a large sum of things I need to push from A to C, I typically use Dynamic SQL, BCP, SSIS, or BIML paired with SSIS to achieve that goal. / comments
thoov, I want to say they have Data Compare, SQL Compare, and SQL Clone that can probably get you close or are at least worth researching. In the past when I have a large sum of things I need to pu...
Hi Sunnyvsk, The request you have is a very in depth one. Please see the following links and see if they help to resolve your question. I expect it will take some time to read through all of the documentation however.
Comparison of versions and features.
How to determine your version and features.
/ comments
Hi Sunnyvsk,The request you have is a very in depth one. Please see the following links and see if they help to resolve your question. I expect it will take some time to read through all of the doc...
Greetings dbodell, I found a post located here that may have a solution for you. I'll post the code below in case the link ever expires. Let me know if this gets you close to what you want. I'm sure you can log or aggregate the data to a table and work off of that.
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;<br>SELECT TOP 100<br> event_messages.operation_id,<br> package_name,<br> message_source_name,<br> MIN(message_time) Task_Start,<br> MAX(message_time) Task_Finish,<br> DATEDIFF(SECOND, MIN(message_time), MAX(message_time)) [time_Take_Seconds]<br>FROM SSISDB.[catalog].[event_messages]<br> JOIN SSISDB.[catalog].[operations]<br> ON operations.operation_id = event_messages.operation_id<br>GROUP BY event_messages.operation_id,<br> package_name,<br> message_source_name<br>ORDER BY 1 DESC;
/ comments
Greetings dbodell, I found a post located here that may have a solution for you. I'll post the code below in case the link ever expires. Let me know if this gets you close to what you want. I'm sur...