SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


package opens up as xml file


package opens up as xml file

Author
Message
PearlJammer1
PearlJammer1
SSChasing Mays
SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)

Group: General Forum Members
Points: 660 Visits: 1444
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 :-)
Steve Hall
Steve Hall
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2859 Visits: 11573
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.

Steve Hall
Linkedin
Blog Site
PearlJammer1
PearlJammer1
SSChasing Mays
SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)

Group: General Forum Members
Points: 660 Visits: 1444
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 ?
Steve Hall
Steve Hall
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2859 Visits: 11573
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.

Steve Hall
Linkedin
Blog Site
PearlJammer1
PearlJammer1
SSChasing Mays
SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)

Group: General Forum Members
Points: 660 Visits: 1444
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.....:-)
Steve Hall
Steve Hall
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2859 Visits: 11573
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.

Steve Hall
Linkedin
Blog Site
PearlJammer1
PearlJammer1
SSChasing Mays
SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)SSChasing Mays (660 reputation)

Group: General Forum Members
Points: 660 Visits: 1444
Thanks for all your help.
I can now look at the package in BIDS !!
Brilliant - thanks:-)
YOUKHANIS.JAMES
YOUKHANIS.JAMES
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 580
Thank for your solution, I had the same problem you saved me a lot of time.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search