April 8, 2013 at 8:20 pm
how do i modify a package which has been deployed to the server? This package is being used for dba purpose (like check integrity task). Will I need the "project" related to the package? Or can I just get the dtsx file and save it in my local and make changes to it?
April 8, 2013 at 10:08 pm
No, you do not need the original Solution or Project file. You can export the Package using SSMS or dtutil.exe and modify it on your local machine. You can also open a copy of the Package directly in BIDS. After modifying the Package in BIDS you can import the revised version into the server using your choice of those same tools.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 10, 2013 at 9:57 am
This might be obvious, but if you don't have version control on the project, its worth renaming the old package before you upload the new one. That way if you break it, you have a quick recovery.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply