ALZDBA (4/10/2009)

---

Has the account that launches the ssis package been granted read authority on your UNC path / file ?

(service account of sqlagent or proxy account of the sql jobstep...

Then the sub-package itself stops, but the main package continues since it doesn't get a failure back from the subpackage.

I found something on MS TechNet, in VB, but I'n not sure on how to use it in DTS;

Option Explicit

Private WithEvents objPackage As DTS.Package

. . .

Private...

Thanks for your help Greg but this exactly how I have it right now but the package stops before the on failure step is executed for the audit table.

I'm using...

Guys, I tried both;

First results of print @sql;

INSERT INTO dbo.ImportError

(DataElementID, CenterCode, ValueType, ValueDate, [Value], ImportDate, BatchID, ErrorReason)

SELECT DataElementID, CenterCode, ValueType, ValueDate, [Value], GetDate(), '463', 'DataElementID too...

Thanks but I just tried the same solution by Ronald but get the OPTIMIZER LOCK HINTS error.

r.hensbergen (1/16/2009)

This way the code expects @ErrorReason to be a column name, to prevent this, replace ' + @ErrorReason + ' with ''' + @ErrorReason + '''...