I have 2 jobs 1 copies an MDB template file and then populates it w/ data from sql tables and stored procedures.

The other copies an excel spreadsheet and populates it w/ data from Sql Server.


The problem is the 1st step in both copies the item as a file, the 2nd step has a connaction to the mdb or spreadsheet. If the item this connection points to doesn't exist before the the package is run, it throws an error on the connection.

It seems the connections are aquired before the package runs and not as needed by each step.

Is there any way around this?

Thanks,

Brian