You mention SSDT – are you hoping to create an SSIS package to do this, or something else?

This is a big task, even for an experienced developer.

SSIS packages are not...

Note also that your original XML was invalid (the <AC> row was not terminated).

Does this get you closer?

USE Testing;

DROP TABLE IF EXISTS #SomeXML;

CREATE TABLE #SomeXML
(
    OTimeGroup XML NOT NULL
);

INSERT #SomeXML
(
    OTimeGroup
)
SELECT '<OTG xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
...

Try this

SELECT JobInfo.JobNo
      ,JobInfo.Product
      ,JobInfo.ItemType
      ,JobInfo.Detail
      ,JobInfo.Started
...

Can you recreate the error?

That is a thing of beauty!

I swapped out the stock pickups on the Ibanez for EMGs.

Here's my Strat.

If the Package runs on the SSIS server successfully and not on you local machine most likely the problem is your Oracle Client isn't configured. you can copy the...

Eirikur, I've been waiting for what feels like years to see this write-up 🙂

I'd be happy to take a look at your draft, if you feel it would...

Eirikur, I've been waiting for what feels like years to see this write-up 🙂

I'd be happy to take a look at your draft, if you feel it would be helpful.

The truncation is possibly happening earlier in the data flow process (so it does not throw an error when you expect it to).

You can check this using Data Viewers to...

What is your question?

Maybe this?

FROM table1
WHERE (APPLE_IND = 1 OR GRAPES_IND = 1)
OR (SOURCE_ID <> 100 AND ADDRESS <> 'NOT APPLICABLE')

If not, can you try putting your requirement into English?

"Choose...

...smtp codes like we used to do earlier.

Earlier than when? What sort of SMTP codes?

Can you clarify a little?

Was...

I must have explained that issue (opening CSV in Excel rogers the underlying data) more than a thousand times.

Access solves the problem, but how many accountants use Access?