SSIS Configuration

SSIS Configuration

• badlydressedboy

  Thanks Jamie.

  Please let me know about the other option also. I will be able to understand things better. Thanks for your support

  
  

• Thorsten Abdinghoff

  You have a couple of options:

  1. Use /SET option of DTExec (http://blogs.conchango.com/jamiethomson/archive/2004/12/13/451.aspx)
  2. Use SSIS Configurations (http://blogs.conchango.com/jamiethomson/archive/2005/03/01/1093.aspx)

  Short comparison of the two here: http://blogs.conchango.com/jamiethomson/archive/2005/05/17/1424.aspx

  -Jamie

  
  
  

• Hans Malherbe

  See dtexec.exe command line reference, in particular /Set parameter:
  http://msdn2.microsoft.com/en-us/library/ms162810.aspx
  
  
  
  

• Zalkalway

  The most often used SSIS configuration is an XML configuration file. This is a file that sits external to your package which the package uses at execution-time to tell it where all its external data sources/destinations are. So basically, an XML configuration file should store the ConnectionString property of your connection manager that you want to change.

  When you want to change which external data sources/destinations you are using, just change the CML configuration file.

  More descriptions of the various configuration types here: http://msdn2.microsoft.com/en-us/library/ms141682.aspx

  And here is how you create them: http://msdn2.microsoft.com/en-us/library/ms140213.aspx

  -Jamie

  
  
  

• Steven Rosaria - MSFT

  Hi,

  Sorry for not mentioning what option I am looking for.

  Well , I am looking for SSIS Configurations.

  Thanks

  
  

• Jesse Hersch

  Hi Jamie,

  Thanks for your reply. I'm very new to SSIS. If you can provide me the steps to parameterize the source , Destination as well as how to configure the same from Job Agent It will be of great help.

  Thanks

  Vijaykishan

  
  

• s3382

  ManjuVijay wrote:

  Thanks Jamie. Please let me know about the other option also. I will be able to understand things better. Thanks for your support

  /SET option of DTExec allows you to change any property of a:

  • Container
  • Task (which is actually a container itself)
  • Variable
  • Connection Manager

  from the command-line when you execute the package.

  -Jamie

  
  
  

• Fabio Gouw

  Hi,

  My Package name is MyDts.dtsx

  I want to change my connection string in run time. I went to Sql Agent / Steps.

  In the SetValues tab I entered propertypath as \Set /MyTest.src and Value as below.

  Data Source=VENUS;Initial Catalog=Test1;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;

  src is the variable I have created in the package which I am using as connectionstring

  When I started the job I received "Invalid Command Line Parameters".

  Whether the steps I have done is right [ SET option of DTEx ]

  Thanks

  
  

• khubaib

  No, your property path is wrong.

  This: http://blogs.conchango.com/jamiethomson/archive/2006/06/01/4020.aspx tells you how to get it!

  -Jamie

  
  
  

• Mystus

  ManjuVijay wrote:

  Hi Jamie,   Thanks for your reply. I'm very new to SSIS. If you can provide me the steps to parameterize the source , Destination as well as how to configure the same from Job Agent It will be of great help.   Thanks   Vijaykishan

  Well first, you need to tell us which of the two options that I highlighted you would like to use. We can help you with the "How " but YOU have to make the decision about "What ". What method you are going to use

  -Jamie

   

  
  
  
• SSIS Configuration