0

I have a SSIS project with several SSIS packages. They run correctly on my local development machine, where they connect to my local DB through a Connection Manager that connects with windows authentication to "localhost".

Now I copy the .dtsx file on a Server and I create a Job that, as only step, launches the dtsx. I need to change the connection of the dtsx but in "new job step" i don't see any tab where i can modify it. For instance, in "Data Sources" there is an empty list with columns "connection manager, description, connection string". Shouldnt my connection manager appear here and be editable?

Johannes Wentu
  • 931
  • 1
  • 14
  • 28

1 Answers1

0

You should use an SSIS Catalog. Config-Management gets a lot easier. See this awesomely answered SO-Question: How to configure SSIS 2012 project to run under different environment configurations?

Community
  • 1
  • 1
Johannes
  • 395
  • 4
  • 9
  • Yeah, I did this on another machine where SSIS catalog was installed but on THIS machine it is not available. I am using a xml Configuration file but i run into the problem that i can't specify a parameter that i need. there are loads and loads of possible configuration but i can't have the value of a PROJECT parameter nor the value of a PACKAGE parameter to show in the configuration file. – Johannes Wentu Jun 03 '16 at 08:19
  • Is it an older Version of SQL Server? Then you'll have to use Package Configuration files, see https://msdn.microsoft.com/en-us/library/cc895212.aspx – Johannes Jun 03 '16 at 14:56