Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Compatability

Author  Topic 

carumuga
Posting Yak Master

174 Posts

Posted - 2009-10-21 : 06:26:17
Hi,

Would like to modify the package which is deployed in the server's file system and copied to the local machine to perform some of the changes in the package. When I noticed, it has the 3rd party component, file watcher task used in it and gripe me that the component is not registered. My changes are nothing to do with this component but other are task involved in it.

My question arises here is, when i do the changes and copy back those changes in the server system and On invoking from the job, will it be able to execute with out an error because my changes should not cause any issue though i dont modify the 3rd component.

Thanks in advance.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-10-21 : 08:09:27
Maybe. It depends on the change required.

It is possible to edit the package as an xml file. For example, if you wanted to change a configuration setting from 4 to 6.
Backup the *.dtsx file first!

I'd strongly suggest you register the file watcher component on your machine and continue as usual.



Go to Top of Page
   

- Advertisement -