March 7, 2011 at 8:36 am
Can I open an existing dtsx package in business intelligence development studio?
Thanks.
March 7, 2011 at 8:39 am
Sure - that's what it's for 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 7, 2011 at 9:25 am
Just File | Open.
Is this stored in SQL Server or the file system?
March 7, 2011 at 10:21 am
its stored in sql server. I was able to open the package in BIDS.
But if I modify the package on my local copy(visual studio) , how can I update these changes on the package that is on the server?
Thanks.
March 8, 2011 at 2:52 am
sql_2005_fan (3/7/2011)
its stored in sql server. I was able to open the package in BIDS.But if I modify the package on my local copy(visual studio) , how can I update these changes on the package that is on the server?
Thanks.
You need to deploy the package back to the server.
It will overwrite the package on the server with the new one.
There are several methods to deploy a package:
* use the deployment utility (http://msdn.microsoft.com/en-us/library/ms365338.aspx)
* use the dtutil utitlity (http://msdn.microsoft.com/en-us/library/ms162820.aspx)
* use the Integrations Services Import/Export wizard in SSMS (http://msdn.microsoft.com/en-us/library/ms140052.aspx)
* install BIDS Helper and use it's very simple right-click deployment (http://bidshelper.codeplex.com/)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply