|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Seeing the heart of a DTS from a Query Analyzer session*Dear all,
I would like to avoid this time VB Code or any script out of SQL so then, the question is easy: Is it possible go across of a DTS, seeing its global variables, main properties and so on, using Transact-SQL? Has anyone ever user or have any experience with this? Thanks a lot, That's an odd request, sort of like using a wrench when what you need is a
screwdriver. You'd have to use the dreaded sp_OA* procs and pick through the various properties with that. Why not use VBScript? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinpub.com .. "Enric" <En***@discussions.microsoft.com> wrote in message I would like to avoid this time VB Code or any script out of SQL so then,news:15557B27-AC71-4884-BC54-08A96ADDDA1C@microsoft.com... Dear all, the question is easy: Is it possible go across of a DTS, seeing its global variables, main properties and so on, using Transact-SQL? Has anyone ever user or have any experience with this? Thanks a lot, hi Tom,
The answer is easy. I did that four months ago using a VB project and for..each statement, dtspkg.dll and so on. But now I don't want use the same tools. Only for to change. Show quote "Tom Moreau" wrote: > That's an odd request, sort of like using a wrench when what you need is a > screwdriver. You'd have to use the dreaded sp_OA* procs and pick through > the various properties with that. Why not use VBScript? > > -- > Tom > > ---------------------------------------------------- > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA > SQL Server MVP > Columnist, SQL Server Professional > Toronto, ON Canada > www.pinpub.com > .. > "Enric" <En***@discussions.microsoft.com> wrote in message > news:15557B27-AC71-4884-BC54-08A96ADDDA1C@microsoft.com... > Dear all, > > I would like to avoid this time VB Code or any script out of SQL so then, > the question is easy: Is it possible go across of a DTS, seeing its global > variables, main properties and so on, using Transact-SQL? > > Has anyone ever user or have any experience with this? > > Thanks a lot, > > hi
you can check it from SQL Server's Enterprise Manager. Just go to the packages section and look for the code there. -- Show quotebest Regards, Chandra http://chanduas.blogspot.com/ http://groups.msn.com/SQLResource/ --------------------------------------- "Enric" wrote: > Dear all, > > I would like to avoid this time VB Code or any script out of SQL so then, > the question is easy: Is it possible go across of a DTS, seeing its global > variables, main properties and so on, using Transact-SQL? > > Has anyone ever user or have any experience with this? > > Thanks a lot, Yes, Chandra. I'm be able to see things pulling from
msdb.dbo.sysdtspackages table but it's not sufficient. It might be an automated task to sql server level. Regards, Show quote "Chandra" wrote: > hi > you can check it from SQL Server's Enterprise Manager. Just go to the > packages section and look for the code there. > > > -- > best Regards, > Chandra > http://chanduas.blogspot.com/ > http://groups.msn.com/SQLResource/ > --------------------------------------- > > > > "Enric" wrote: > > > Dear all, > > > > I would like to avoid this time VB Code or any script out of SQL so then, > > the question is easy: Is it possible go across of a DTS, seeing its global > > variables, main properties and so on, using Transact-SQL? > > > > Has anyone ever user or have any experience with this? > > > > Thanks a lot,  |
|||||||||||||||||||||||
Other interesting topics