DTS Package Complexity | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Package Complexity

Hi All, Can anyone tell me how can we determine a DTS Package’s complexity. I want to know the elements that determine the complexity of DTS Package.
The very little knowledge I have is number of Connections, number of tasks, Number of Activex Script Tasks. Can anybody please give some more data on this. Thanks in Advance Regards,
Ravi Kiran
It depends how much complexity you want to add, SQL Server books online andhttp://www.sqldts.com is your best resource in addition to your practicals on DTS packages. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Hi Satya, Thanks for the info. Suppose I was given an already developed package and asked for maintainence of the Package. How can I determine whether the package is complex or not. Is there any measure that the if number of connections more than "some number" we treat this package as simple or medium or high complex. Is there any standard measure through which we can categorize the complexity of the DTS Package. Thanks in Advance Regards,
Ravi Kiran
You can either open the package and have a look around the workflow properties and how many DTS tasks are defined, also look whether package log is enabled, this will give you more information that whether the package is complex or easy one. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>