i have dts packages failing occasionally. have pretty comprehensive logging in various vbscript components , both sql , text logging enabled in each package. logging works fine if run dts packages server live on.
in practice these packages run using dtsrun remote machine has sql server client tools installed. dts runs locally, logs go in case, if created @ all? they're not on server, there's no database on client sql logging , none of text files created on client or server. possible debug dts packages run way?
such is, answer ensure full path of text logging set it's valid on machine dtsrun being called. in case had set c:\dtserrors - folder existed on server, not on client. creating c:\dtserrors on client solved problem - text logs being created.
i assume sql logging fails silently there's no sql server on client machine log to.
Comments
Post a Comment