Are you doing the export as five data flows?

Are they running in series or in parallel?

I've had those 'unexpected …' errors several times in the past and they're almost always difficult to solve, exactly because of the dearth of logging info which they seem to...

Is that error message taken from the All Executions report?

i ran the pkg sql to sql.   it ran in less than 5 seconds.   because i have a derived column component between the sql frokm and to adapters, i...

Fair point on the ROLLBACK, although it would close the BEGIN TRANSACTION (rather than leaving it open).

Correct, though resolved by moving the BEGIN TRAN down a few rows.

@ReferenceNumber is used...

Using dynamic SQL will probably also do the job, should you wish to keep it in one.

That first ROLLBACK appears to roll nothing back!

Also, you define @ReferenceNumber but don't use it. Are you sure that this is your current proc?

As it's written, I'd be tempted to...

You can ignore that 'global shared memory' warning. It does not affect how your package runs.

Have you tried running the import on a dev machine (with both SQL Server and...

Maybe try installing the Integration Services extension again, while running VS as Admin.

TrustServerCertificate=True is the setting you need. Or something like that ... I'm not at my computer right now.

You are the one asking for unpaid assistance, so we should not have to 'meet you half way', in my opinion.

I have made it very easy, gave data in more than one format. Its you guys that makes it difficult. Your all full of nonsense! What more do you...

If you try running your own code, you will find that no values get inserted into your tables. Not that useful to people who are trying to help you.

Please Only assist, if you want to. I don't need the negativity from the regulars who troll this forum only to attack those that are seeking help.

Are you suggesting that...

We can't tell from what you've posted.

No idea what a 'restraint' is. Constraint? Restriction? Something else?

Post some consumable sample data which highlights the issue you're seeing, so that we can...