November 9, 2006 at 3:11 am
Hi All,
Can anyone tellme 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
November 10, 2006 at 8:48 am
If there are no complexity metrics for DTS packages you might consider Googling for "complexity metrics" with "SQL Server", etc. I doubt if there are any. You might be a pioneer and will have to come up with your own, based on McCabes, et.al's work. If you do, please publish it on this forum so that all of us can benefit.
There is a script that I found most helpful, written by Nigel Rivett at http://www.nigelrivett.net/ScriptDTSProperties.html It extracts DTS package properties and should make your job easier. You may want to modify the script to either put the output to tables, etc.
May 31, 2011 at 3:55 pm
I can't figure out what to do with this portion of Nigel's script. If I put it in the script portion of the ActiveX Script Task, it does not parse. Also, not sure what to put in the EntryMethod.
Create a Activex Script Task and include the following script.
Call it via (for a trustedt connection include a blank uid/password)
declare @sql varchar(1000)
select@sql = 'dtsrun /NScript_DTS_Packages /S(local) /E '
+ '/A"ServerName":8="' + (local) + '" '
+ '/A"Path":8="' + c:\test\ + '" '
+ '/A"UserName":8="' + myuid + '" '
+ '/A"Password":8="' + mypwd + '" '
exec master..xp_cmdshell @sql
June 16, 2011 at 12:30 pm
Check out the Profiler portion of DTSxChange (note:I work for Pragmatic Works).
Profiler is made to tell you how much time our tool will save you in automatically converting said package versus manual method. It spits out a pretty nice report showing you all the different components involved in your package. Report can be very high level or granular. Download a trial and give it a shot, no licensing involved for Profiler and trial gives you 3 free conversions.
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply