How to upload configuration file to Integration Service Server

All Replies

• Sunday, February 10, 2013 6:45 AM

   

   
  

  0

  Hi SarahLiu,

     You have to do package configuration & deployment procedure ,once you develop your package.

     Refer this link - http://msdn.microsoft.com/en-us/library/ms137592.aspx

     hope this link will help you!!!

     After successful deployment ,go to \bin\deployment folder,double-click the Integration Services Deployment Manifest file,

     then you have two options to deploy your package in your server - File system & SQL Server deployment.

  ---

  Thanks & Regards, sathya

  
  

  • Edited by SathyanarrayananS Sunday, February 10, 2013 7:06 AM
  • Proposed As Answer by SSISJoostMicrosoft Community Contributor, Moderator Sunday, February 10, 2013 9:46 AM
  •  
  • Reply
  • Quote

   
• Sunday, February 10, 2013 9:49 AM

  Moderator

   

   
  

  0

  Creating a Deployment Utility is probably the easiest way:
  http://msdn.microsoft.com/en-us/library/ms137952(v=sql.105).aspx

  ---

  Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

  • Reply
  • Quote

   
• Monday, February 11, 2013 7:48 PM

   

   
  

  0

  The Deployment Utility install the .dtsx and .dtsConfig files to my local computer if I select File System.

  C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\jobTest

  The Deployment Utility install the .dtsx file to target server, but install the dtsConfig file to my local computer if I select SQL Server.

  Could you please give me more details. Thank you very much!

  
  

  • Edited by SarahLiu Monday, February 11, 2013 8:06 PM
  •  
  • Reply
  • Quote

   
• Monday, February 11, 2013 8:46 PM

  Moderator

   

   
  

  0

  

  Package will be in sql server, but dtsConfig remains on file system... you could choose for sql server config instead of xml config...

  ---

  Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

  • Reply
  • Quote

   
• Monday, February 11, 2013 9:09 PM

   

   
  

  0

  I am new bee for SSIS.

  One more question, if I create the SQL Server configuration file. All of data is saved in table SSIS_Configuration, then how to add the configuration file to the job step, Or do not need add it to the job step, because it already exist in the SQL Server?

  
  

  • Edited by SarahLiu Tuesday, February 12, 2013 4:17 PM
  •  
  • Reply
  • Quote

   
• Wednesday, February 13, 2013 7:29 AM

  Moderator

   

   
  

  0

  Hi SarahLiu,

  You can click the Configurations tab on the SQL Server Agent to add configuration files, please refer to detail steps: http://stackoverflow.com/questions/6712811/how-do-i-create-a-step-in-my-sql-server-agent-job-which-will-run-my-ssis-package/6713464#6713464

  For more information about running a package by using a SQL Server Agent job, please see: http://msdn.microsoft.com/en-us/library/ms138023(v=sql.100).aspx

  Thanks,
  Eileen

  ---

  Eileen Zhao
  TechNet Community Support

  

  • Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 3:06 AM
  •  
  • Reply
  • Quote