CODEWITHSUNDEEP
sql-serverssis
Tshepiso Selepe
Tshepiso Selepe

Reputation: 67

SSIS deployement to Catalog with (.dtsConfig) FILE

I have an SSIS project that copies data from 1 table to another, the destination table and target tables are passed through variables, I have created a config file to allow dynamic changing of the target table and destination tables names.I have now deployed the project to SSIS catalog but I have no idea where to get the XML config file to change the table names.

Upvotes: 0

Views: 405

Answers (1)

Ferdipux
Ferdipux

Reputation: 5246

Welcome to SSIS Catalog! Config files are gone, you have two great options - Package Parameters and Server Environments. Parameters can add flexibility to packages - one specify its value at package start. Environments will help with 'environment-dependent' settings like connection strings etc.
You can still use dtsConfig files in SSIS 2008 compatibility mode, but it is not practical and is not supported by SSIS Catalog.

Upvotes: 1

Related Questions