Can we import a package to production from development SSIS 2012

I got a project with many packages, so I want to do a changes in a single package. Instead of deplying the entire project, Can we import a single  package rather than deploying the entire project.

which mean I'm not using deployment wizard on project mode.
ken hanseAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You should make a test to verify that but I think (I'm not sure) that the package will inherit the project connection.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, you can but don't forget to change the connections to Production environment as well.
0
 
ken hanseAuthor Commented:
Is ok if  import from Ssis catalogue from development package source folder and change the connection to production?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, it's ok but try to use SSIS package configuration feature for future since then you'll have the connection in a configuration file instead of hardcoded in the package.
0
 
ken hanseAuthor Commented:
Package uses project connection manger instead of package. My question is will that project connection invalidate if I do import package. My other packages use project configuration where DBA manage connection through that.
Do I need manage connection configuration  this package separately? Or will it manage by project ?
 Hope you understand my question?
0
 
ken hanseAuthor Commented:
all of the hint contrubuted
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.