Executing SSIS deployed on SQL Server
Hi, Details: Package mypackage.dtsx is having xml config file myconfig.dtsconfig. The package has been deployed on SQL Server and the path for config file is c:\dt\ssis sql\. The development path of the SSIS package is h:\dt\ssis sql\. Issue: When the package is executed from the SQL server itreads config file from"h:\dt\ssis sql\"path and NOT from "c:\dt\ssis sql\" as specified during deployment. Why is the package not reading from the path specified during deployment? Regards Deepak
August 12th, 2008 7:39am

How have you set the path specified during deployment? It is possible that if the user executing the package (sql server agent?) does not have the drives defined it might be defaulting back to the original value.Also, you should never use drive letters in ssis. Use the full unc path (\\mymachine.mysubdomain.mydomain.com\myfolder\mysubfolder\myfilename)
Free Windows Admin Tool Kit Click here and download it now
August 12th, 2008 8:22am

There is now an open source utility available in CodePlex which can be used to batch update SSIS Package Configuration File paths without using BIDS or manually editing the package XML: http://ssisconfigeditor.codeplex.com/
May 19th, 2012 2:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics