I can't remember a time when I didn't use this, along with the colouring options provided by SQL Prompt.

Did it also exist in the olden days of Query Analyser?

• This reply was modified 1 year, 3 months ago by Phil Parkin.

Sorry for the slow reply.

Don't know whether it will help, but might be worth a try. On the Excel connection properties, try setting 'RetainSameConnection' to true.

OK good start. Can you post a screenshot of your control flow? Redact the text...

Which client software are you using to connect?

Something like this?

SELECT DISTINCT
       source = 'Restored'
      ,au1.UserId
      ,ug1.Name
  ...

Not sure what all that 'object_id'...

I would like to compare results

Please define more accurately what you mean by 'compare'. What results are you hoping to obtain?

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...