Possibly because of this row:

and bk.backup_finish_date < getdate()- 1;" -ServerInstance "ABC" -Database "db"

Try changing it to

and bk.backup_finish_date < getdate()- 1;" -ServerInstance $ServerName -Database "db"

Out of interest, David, when hiring fresh out of college, did you filter depending on what they'd studied, or did you keep things completely open?

Do you have the same version of SQL Server on your machine and on the server?

> And trying to teach a subject-matter expert how to 'do' IT is equivalent to teaching an actor how to dance.

MMM... usually, but not always.  I'd love to have...

I remember reading about someone who was being hired for a role in a film which was about a dancer. The conclusion was that it was much easier to teach...

SSMS won't run on your phone. The most likely way of making this work is using some sort of remote access software to a PC which has SSMS installed.

Unless you...

• This reply was modified 1 years, 4 months ago by Phil Parkin.

Create another variable, called SQLCommand (or whatever). Define SQLCommand in the Variables section as

SQLCommand = "SELECT * FROM dbo.SQL_SOURCE WHERE Mod_Date >= " + @[User::LastRunDate]

and use SQLCommand as your query...

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 years, 4 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?