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 2000 Forums
 SQL Server Development (2000)
 How to find customized package?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-26 : 09:00:57
sandipanghosh writes "Hi
i my company we have one application for creating package when we are setting up any table for uploading the data.
sometimes we need to change (customize) that package manually.

Now i want to fine all customize package programatically.
Through QA ( quarry)

Any idea? any help ??????????

Thanks
SAndipan"

nr
SQLTeam MVY

12543 Posts

Posted - 2006-05-26 : 09:18:11
This will script most of the proerties of packages then you can search the scripts.
http://www.nigelrivett.net/DTS/ScriptDTSProperties.html
Or you can tailor it to just look in the bits that you need.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -