Edit: I was writing as Kev Riley posted and my questions were answered in his post.

Both: Thank you for your help.

Original post:

That worked, thank you. Am I right in thinking...

• This reply was modified 5 years, 2 months ago by as_1234. Reason: I was replying at the same time as someone else
• This reply was modified 5 years, 2 months ago by as_1234.

I think this might be possible with a case statement. Can you explain how you split the two columns when flagallow=1? Is it always the right two characters from the...

Do you know if the heartbeat is using the same network as other data?

I once had an issue where the database backup was using all of the bandwidth and stopping...

All,

Thank you for your help. I've replied to each of you below. Apologises if I've missed anything.

Quick and easy fix to this - need to mark the variable as...

I solved the first question as follow:

T.c.value ('id[0]','varchar(255)') AS id,

needs to be:

T.c.value ('@id[1]','varchar(255)') AS id,

Sorry I had forgotten about the change from windowsupdate.log to etl.

Are there any other SQL installs using the same WSUS server? Do you know which version of WSUS Server is running?

Can...

I've not had issues with SQL Server and WSUS before so I can't help from the SQL perspective but I have had issues with WSUS before. Is there anything in...

All,

Thank you for your help.

It was the transaction settings in the master package. I think I accidently changed it when I was experimenting with the isolation level settings.

Thanks

Thank you for your help.

I will check the transaction settings when I go back to this issue next week. I'll post any results that will help anyone else who gets...

Thank you for your help. I, mistakenly, understood it as meaning that it would create separate transactions in each sub package. I set it to see if it would solve...

I think I may have, partly, found the issue here https://support.microsoft.com/en-gb/help/2253391/the-execution-of-a-sql-server-integration-services-ssis-package-stop. I'm running SSIS 2017 but I suspect the issue still applies.

There is a more detailed explanation of Validate External...

Thank you for your help and the links.

I just tried them in series and the first instance gets blocked by spid -2.

If I put them in parallel and disable one...

Thank you for your help.

Sorry for not being clear. The destination table is the same for both packages. It's the same package being used twice in parallel. Each is processing...

Thanks for your reply. I'll see if I can post something. As I'm fairly new to SSIS I'm wary of making sure I exclude all usernames and passwords e.t.c.

Thank you for your help. I now have it set up using a sub package and it works.

Just in case anyone else finds this thread looking for details of parallel...