What is the purpose of converting all rows in that table to an XML format - with all 55 columns?  If this is for an export file - there are...

Hi,

Please refer below code snippet -

;WITH DateTable AS (
SELECT * FROM (VALUES
('2020-07-01',0,0),
('2020-07-02',0,0),
('2020-07-03',0,1),
('2020-07-04',1,0),
('2020-07-05',1,0),
('2020-07-06',0,0),
('2020-07-07',0,0),
('2020-07-08',0,0)
) AS t(DateValue,isWeekEnd,isHoliday)
),
TicketTable AS (
SELECT * FROM (VALUES
('Ticket1','2020-07-01','2020-07-06'),
('Ticket2','2020-07-07','2020-07-08'),
('Ticket3','2020-07-07',NULL)
) AS t(Ticket,CreateDate,ResolvedDate)
)
SELECT t.Ticket,t.CreateDate,t.ResolvedDate,
DATEDIFF(DAY,t.CreateDate,t.ResolvedDate) -...

Just guessing - but is it possible that a scheduled process on the source system is running at the same time as the backup?  If there was a large load...

The difference is related to the connection settings or the user.  To determine the difference you need to review what is happening on the Sybase system.

Nothing you do within SQL...

<!--more-->I think you need to be looking at the Sybase system to see what is executing on that system.

My guess is that the extract query is hanging.

This isn't a SQL Server issue - looks like you have some Windows issues on that system.

Have you tried taking ownership of the folder - and enabling inheritance?

Just thinking out loud...

Is it possible that your are getting a different execution plan on the source system?  Since that source system is Sybase - it is possible the code...

Totally agreed on the Modified_By and Created_By columns being fix length like an INT column with an FK but, if an application has a generic login, that would mean...

You can start here for the SSIS Catalog: https://docs.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver15

Installing is quite simple - it really is just a matter of right-clicking on the item in Object Explorer and selecting the...

If all of the controls are in the same section - either the body, page header or page footer - you can select all of the controls (Ctrl-A) and then...

It's (a separate table) is a better practice for multiple reasons especially if it can't be altered without all hell breaking loose.  The 4 columns you speak of (I...

I am curious - why are you deploying your packages to MSDB?  As of SQL Server 2012 we now have the Integration Services Catalog and project deployments which is much...

Then you need to run an extended event session to capture the SQL statements during the load process.  You can then review those statements to see how they are updating...

One other point about AD groups...you can treat an AD security group as a 'role' in SQL Server instead of creating a role in SQL Server and adding the security...