I have an SSIS package, for which I am giving some input value to the runtime, this is the SQL agent, or the file system DTExec is likely to either execute it. I have found, if I run DTExec from a file (actually an .ispac compiled project), then I can only set the variable with the / SET option, not the package parameter if I get it from the agent, or from normal If you want to run from the server, its better and the parameters are easy to use. At the moment I have created blank parameters and variables as placeholders, and to use the parameters to use additional variables, variables with expressions in the form of switches. Although all this is unnecessary, so I have to know what is the method to use only the parameters, and when it runs with the file system, it has to be set with DTEXX? Or does anyone have any better ideas in general?
When using an SSIS package, using DTXAC is the best, easiest, and to set parameters The most portable approach is to use "XML Configuration File". Creating and using such files gives you a set value (such as SQL Server instance name and password) and helps in executing a package in Dev to use another set in production.
To create an XML configuration file, click the SSIS tab in your package, select the package configuration and you can choose what settings will contain in the XML file and their initial value.
No comments:
Post a Comment