Home > Archive > MS SQL Server DTS > March 2006 > DTS Dynamic Properties Task









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author DTS Dynamic Properties Task
pearsons_11114

2006-03-26, 8:27 pm

Not finding much information out there about accessing a DTS dynamic
properties task from .NET. Apparently it can be done from COM, but not via
interop. You can access a dynamic properties task as part of the Tasks
collection, but the Assignments collection, the meat of a dynamic properties
task, doesn't show up at all. So, is this broken in some way? Why would it be
exposed in COM but not via interop? Thanks!

What I'm trying to accomplish is to create a user interface to running
aribtrary DTS packages with parameters at runtime. If I can interrogate the
dynamic properties task then I know what to prompt the user for. New packages
can be added without changing the application.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com