September 2, 2013 at 5:38 am
Hi
I am quite new to SSIS and I am having the following problem.
I want to open the ssis package locally on my laptop to take a look at the current steps/tasks and control flow that the job currently implements. On the general tab of the job (which i open the server) i can see under Package that it is stored in:
\MSDB\FolderA\DataFeeds\datafeedGeneric and under the Configurations tab i can see S:\SSIS\Datafeeds\ClientName\ClientName.dtsConfig
I have copied the file with the .dtsConfig extension from the server to my laptop locally and tried to open it in bids but it opens in xml.
Am i correct in saying i need to locate a file with .dtsx extension ?
Do i need to get the package from the msdb location ie the MSDB\FolderA\DataFeeds\datafeedGeneric and if so how do i go about this.
I have some other questions too but i'll raise a new thread for those 🙂
September 2, 2013 at 6:46 am
Yes, the DtsConfig file contains parameters for the SSIS package - it is one way of making the package more flexible by changing parameters instead of rebuilding the SSIS package every time you want to change a value.
There are several ways to open the the actual SSIS package (the dtsx file).
One way is to open Visual Studio, create a new SSIS project and then, in the Solutions Explorer, right-click on 'SSIS Packages' and select 'Add Existing Package'. from this dialog you can select the Server and then the package you want to import.
You can also connect to the Integration Services Server via SSMS, right click on the package under 'Stored packages/MSDB' to locate your SSIS package. then right-click on it and select 'Export Package...' to save it as a file or even move it to another IS Server.
September 2, 2013 at 6:51 am
There are several ways to open the the actual SSIS package (the dtsx file).
One way is to open Visual Studio, create a new SSIS project and then, in the Solutions Explorer, right-click on 'SSIS Packages' and select 'Add Existing Package'. from this dialog you can select the Server and then the package you want to import.
If i implement this method will it in any way effect the live package on the server . ie if I where to play around with the package on my local laptop after exporting will it effect things live - does the live package still remain 'as is' on the live server ?
September 2, 2013 at 6:57 am
PearlJammer1 (9/2/2013)
There are several ways to open the the actual SSIS package (the dtsx file).
One way is to open Visual Studio, create a new SSIS project and then, in the Solutions Explorer, right-click on 'SSIS Packages' and select 'Add Existing Package'. from this dialog you can select the Server and then the package you want to import.
If i implement this method will it in any way effect the live package on the server . ie if I where to play around with the package on my local laptop after exporting will it effect things live - does the live package still remain 'as is' on the live server ?
When you import it this way, once opened you only have the option to 'Save As...', so you can't overwrite the installed package by mistake.
If you want to feel really safe, just export it from the IS server instead, that will create a dtsx file where you specifiy and then there is no doubt it isn't the server's copy.
September 2, 2013 at 8:12 am
You can also connect to the Integration Services Server via SSMS, right click on the package under 'Stored packages/MSDB' to locate your SSIS package. then right-click on it and select 'Export Package...' to save it as a file or even move it to another IS Server.
Ok Just clarify 100% before I do this.
I have connected to ssis from ssms and located the package as you mentioned above. So just to clarify, 'exporting' doesnt remove the package from this location - it is in effect just like copy and paste at a simple level - so the package actually stays on the server and performs as nothing has happened ??
Sorry for the hesitation on this, its just the first time i have done this.....:-)
September 2, 2013 at 8:57 am
PearlJammer1 (9/2/2013)
You can also connect to the Integration Services Server via SSMS, right click on the package under 'Stored packages/MSDB' to locate your SSIS package. then right-click on it and select 'Export Package...' to save it as a file or even move it to another IS Server.
Ok Just clarify 100% before I do this.
I have connected to ssis from ssms and located the package as you mentioned above. So just to clarify, 'exporting' doesnt remove the package from this location - it is in effect just like copy and paste at a simple level - so the package actually stays on the server and performs as nothing has happened ??
Sorry for the hesitation on this, its just the first time i have done this.....:-)
Not a problem - I don't like the first time I do anything regarding SSIS!
Yes, it will save a copy of the package to your specified location and leave the installed package on the server. You can then edit the saved package/file without any impact on the package stored on the server.
September 2, 2013 at 9:48 am
Thanks for all your help.
I can now look at the package in BIDS !!
Brilliant - thanks:-)
April 22, 2016 at 1:47 pm
Thank for your solution, I had the same problem you saved me a lot of time.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply