Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Fixed Help for as Fixed


0
0
Sign in
to vote
Type: Bug
ID: 465331
Opened: 6/8/2009 10:27:37 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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.

Details
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,
Sergio
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
http://support.microsoft.com/kb/960161/

Thanks,

Gil
Sign in to post a workaround.