How can I modify .dtsx file .?

Question

Post reply

How can I modify .dtsx file .?

Joy Smith San

SSC-Insane

Points: 24877
More actions
June 7, 2011 at 5:35 am

#251307

Hi All,
How can I modify .dtsx file .? Its SQL Server 2005 SSIS package.
If I simply open in notepad and make the changes will it work .?
Pelase guide. Thanks in advance.
Smith

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

krypto69 SSChampion Points: 13604 More actions · Answer 1

krypto69

SSChampion

Points: 13604

June 7, 2011 at 9:14 am

#1335080

open it in BIDS and modify

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 2

Thanks for your response..

I did it this way as I dint have entire solution.

I created new package in BIDS. Imported this particular DTSX file. Modified it. Build the package and JUST COPIED the .DTSX file from Bin directory.

I created a test job and it's working fine.

Did I do right.? My doubt is that if I SIMPLY COPY THE UPDATED .DTSX in the folder in production server and rename the original existing file to something else, will it work.?? Will the updations reflect.?

Thanks.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

That works, as you've seen. The .dtsx file contains the changes you've saved. It's also a good idea to save the package\solution in source control also.

Greg

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 4

Thank you somuch.

Will update in production server and see.

Thanks to all again.

Rich Mechaber SSChampion Points: 11130 More actions · Answer 5

As Greg said, that works...

.... but only if you are running an Agent job against that particular DTSX file, stored on the file system.

You may know this already, but I thought I'd add: if you store your jobs in MSDB and not on the file system, to change the package you must (1) export the package from MSDB to the file system; (2) edit the file in BIDS and save it; and (3) re-import the package from the file system back into MSDB.

Once you've done this, the DTSX file on the file server is no longer needed. Again, this is true only if you are storing packages in MSDB.

Rich

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 6

Thanks. I was not aware about it as well. Hardly worked in Integration Packages. Thanks again.

trikha.ishan SSC Enthusiast Points: 101 More actions · Answer 7

Hi,

I tried to update the .dtsx file using notepad in development server and that change is in Script Component but when I ran the package that change didn't reflected in my DB.

So I did the change in my local and again copy pasted the package in dev. after that everything worked well.

Just wondering is it like we cannot modify the .dtsx file directly or we always we need to do it through BIDS.

Thanks in advance.

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 8

trikha.ishan (6/18/2014)
Hi,
I tried to update the .dtsx file using notepad in development server and that change is in Script Component but when I ran the package that change didn't reflected in my DB.
So I did the change in my local and again copy pasted the package in dev. after that everything worked well.
Just wondering is it like we cannot modify the .dtsx file directly or we always we need to do it through BIDS.
Thanks in advance.

You can change most things except the compiled VSTA scripts, that is the script task and script component. Changes in those means it has to be re-build.

😎