Link to home
Start Free TrialLog in
Avatar of godwineffiong
godwineffiongFlag for United States of America

asked on

SQL Server Agent job duplicating SSIS configuration file

I have a job running about 40 steps, each processing an SSIS 2008 package. I have one configuration file for all steps and added the file to the configuration tab of each step. When I close and reopen the job, the file has been added again to each step, multiple times. Each subsequent step as one more file added. This eventually causes an error due to the length of the configuration file names being read.  


pic.bmp
SOLUTION
Avatar of Kumaraswamy R
Kumaraswamy R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of godwineffiong

ASKER

COuld not resolve issue. Thanks!