I have SSIS project, now I want to add an exist package in server into this project. I looked for tutorial in youtube, google,.... but found no answer.
I right click on SSIS Package, and select SSIS Import and Export Wizard
In Data Link Properties window, test connection always return success when I change anything, but when click next step, error come
I dont know how to pass this step :(
The SSIS Import and Export Wizard is not the tool to add existing packages to your project. The SSIS Import and Export Wizard is a GUI for building SSIS packages, usually in a disposable fashion.
I don't know how to fire up the Integration Services Import Project Wizard for an existing project, but if you add a new project, you can pick the Import Project Wizard which will then pull in the existing packages (and project level connection managers and project parameters)