A SQL Agent SSIS jobstep accepts, but does not use, a configuration file UNC path - by Dwaine Wright

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 465331 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 6/8/2009 10:27:37 AM
Access Restriction Public


When creating a SQL Agent step using the SSIS subsystem, adding a configuration entry with an UNC path is successful.   Since adding an invalid path is impossible and raises an  error, the user is lead to believe that path validation is occuring at configuration time and so a correct (and accepted) file UNC is a valid configuration.

At run time, however, behavior is far from expected.  You must manually change the /REPORTING E parm to a V(erbose) to see the confusing runtime issues.

First, the job step runs and completes if the configuration settings in the original package are usable, but data may be coming from unexpected (e.g., develpment environment) sources without warning.  Closer inspection of the resulting logs reveals the following:

1) DTExec ignores the UNC path entry, but it's presence in the configuration causes the attempt to use either the default server config path OR the config path used in the develpment environment if configured.

2) Even though the configured UNC file is not used AND the attempted config file is not present, the package raises no warnings or errors and continues to run using it's original configuration when deployed from BIDS.

Sign in to post a comment.
Posted by Microsoft on 9/4/2009 at 10:52 AM
Hi Dwaine,

Thanks again for reporting this issue. This was fixed in our latest sources.

Thank you,
Posted by Dwaine Wright on 6/15/2009 at 1:16 PM
version 9.00.4035.00
Posted by Microsoft on 6/12/2009 at 11:30 AM
Hi - what version of SQL Server are you using ? This problem should be fix in CU for SQL 2005 sp2