CODEWITHSUNDEEP
sqlsql-serversql-server-2008ssis
343
343

Reputation: 305

SSIS package runs without Config file

I am New to SSIS config side. I have created one package with its config file. My Project placed into my account folder at server. but I created the config file which I placed at shared drive folder and also copy the mypackage.dtsx file into another shared folder.

Now I have ran the package with dtexec.exe /f "mypackage.dtsx" without using config file even though it successfully run.

even I have changed some of the property into the config file and ran the package with use of the dtexec.exe command(mentioned above) and it was executed successfully.

So I have a question that, Do I need the config file at dtexec.exe command line because I can run my package by "dtexec.exe /f "mypackage.dtsx" " too?

I saw the syntax of dtexec.exe /f "package.dtsx" /config "myconfig.dtsconfig"

Please guide me...Does the package contains the config file and its changes?

Upvotes: 0

Views: 1527

Answers (1)

William Salzman
William Salzman

Reputation: 6446

The package will remember it's saved settings. The benefit of a config file is that if you need to override/shange the settings that are contained in it, you can do that without needing to open, fix, and redeploy your package. A config file is not ever necessary, it is just a convenience to you the developer, especially if your environment has a strict change management policy. It is usually easier to change values in a config than to edit and redeploy a package under strict change managment.

CLARIFICATION

It appears from your question that you may be thinking that when you change the config it will change your package regardless of including your config in your execution. All of the information from the config will be in the package at the time you save it, but it may differ from what is in the config. If you run without config, you are running exactly what is saved in the package. Package executions work like this:

  1. Load package with all configurations from the saved .dtsx file
  2. Check for configurations to load.
  3. Load configuration in memory and overwrite values loaded from .dtsx package.
  4. Execute.

This is simplified, and there are other things going on, but at the basic level this is accurate.

Upvotes: 1

Related Questions