You know that if you type 'show errors' at the SQL plus prompt it will tell you why it didn't compile.

Hope this helps

Adrian

This article covers the reading the connection properties from a file

http://www.databasejournal.com/features/mssql/article.php/3073161

To pass variables to a called package (how I did it), simply.......

Define global variables in the parent package (don't...

Solved (almost)

I've actaully created a generic task that replaces all of my individual packages.

I altered the step on the schedule so that it passed parameters (using /A). Then I used...