Hi,

I have a Package that needs to be deployed in SSIS Catalog DB.

Later I need to execute it through SQL Job.

Please let me know the steps how to do this and also I need to pass a Config file to run the package in SQL job.

Thanks,.

Sailaja

• Changed type SSISJoostMVP, Moderator Friday, January 30, 2015 3:52 PM More appropriate type

Hi Sailaja,

why don't you get a book on SSIS 1st? Or at least search the internet?

How to deploy a package - tutorial https://msdn.microsoft.com/en-us/library/ms365338.aspx

Understanding package configurations: https://msdn.microsoft.com/en-us/library/cc895212.aspx

Try then let us know what issues you encountered.

PS: If your package touches the file system you may need to run using a domain based proxy

Just to be clear, you need to deploy the package to the Catalog and also use a config file for Execution? The config file that you are are talking about is it package config file? You cant deploy the package to Catalog (project deployment model )and use package configurations at the same time.  

Hi Arthur,

 at least search the internet

Currently we are deploying our packages to File system and there we are using configuration files.  Now we are planning to deploy them to SSIS Catalog DB.

I searched in internet and couldn't find the appropriate way. Hence I posted the question here as

"Please let me know the steps how to do this and also I need to pass a Config file to run the package in SQL job."

Hi Sailaja,

If you have config file and wants to migrate to 2012 or above, config file automatically converts into parameters during (Convert to project deployment model)

then all your variables(config file values) in your package if there is any, should replace with paramenter value. 

- then for dynamic value changes you have to create environments in SSISDB, and then assign those environments in your sql agent job.

Refer below web link and video how to deploy package to ssisdb

https://msdn.microsoft.com/en-us/library/hh667275.aspx

https://www.youtube.com/watch?v=lMPhwV4Gb5M

Thanks

--------------------------------------------------------------------------------------------------

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

• Edited by SequelMate 23 hours 28 minutes ago

Hi Arthur,

 at least search the internet

Currently we are deploying our packages to File system and there we are using configuration files.  Now we are planning to deploy them to SSIS Catalog DB.

If you deploy your packages to the IS catalog, then you can use the Environments (associated to each IS project). Inside the environments (env), you can create env varibales which can be changed at run time. 

Creating SQL agent job out of IS catalog projects is not cumbersome. It is designed the same as it is for file system deployed packages. 

http://sqlmag.com/sql-server-integration-services/ssis-deployment-sql-server-2012

Hi Sailaja,

Based on your description, you want to deploy a package to SSIS Catalog DB, then execute it through SQL Agent job with configuration file.

To deploy a package to SSIS Catalog DB, we can refer to the following suggestions:

• SSMS-->Integration Service Catalogs-->SSISDB-->Your project-->projects. Right click on the projects, and choose "Import Packages...". Then make use of the Project Conversion Wizard to select the packages that you want to deploy, deploy the generated .ispac file to SSIS Catalog. For more details, please see:
  https://msdn.microsoft.com/en-us/library/jj852096.aspx
  
• The command line tool DTUTIL.EXE which can be used to deploy SSIS packages. For more details, please see:
  http://www.mssqltips.com/sqlservertutorial/215/command-line-deployment-tool-for-ssis-packages/
  

To schedule the package by using SQL Agent job, we should select Integration Services Package for the job step type, then add configuration file or add some properties form configuration file in the Configuration tab. For more details, please see:
https://msdn.microsoft.com/en-us/library/gg471507.aspx

Thanks,
Katherine Xiong