Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Can I access DTS objects using SMO?

 
   Database Forums (Home) -> DTS RSS
Next:  Timer Code  
Author Message
Snake

External


Since: Sep 29, 2008
Posts: 23



(Msg. 1) Posted: Fri Nov 21, 2008 1:39 pm
Post subject: Can I access DTS objects using SMO?
Archived from groups: microsoft>public>sqlserver>dts (more info?)

I would like to write a DMO/vbscript/activex control in DTS to access other
DTS packages' connection objects properties. It it possible and if so where
can I find a code snippet or example?

Thanks

 >> Stay informed about: Can I access DTS objects using SMO? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
After DTS Copies Objects, MS Access client cannot read data - I have an MSDE database in a desktop environment. I wanted to move it to a shared SQL Server instance so I used DTS to copy the objects to an existing database on the server. Using Enterprise Manager I can design/open the objects on the server but when...

DTS objects and methods - Where can I find SSIS DTS objects and methods so that I can understand and use it in the script component etc?

Copy Objects Dependencies - I am trying to copy a "snapshot" of a remote sql server 2000 database to a local sql server 2000 database. I just want to run a simple Copy Objects dts, but it is choking on a user defined function. Another object needs the udf but the udf ...

SSIS transfer sql objects: table does not exist - I am trying to create a SSIS package that copies a bunch of tables from a SQL Server 2000 DB to a machine with SQL Server 2005. I can see and select the tables in the editor, but when the package runs, I get: Table "XXXXXX" does not exist a...

Transfer SQL Server Objects Task - Change Schema - SQL 2005 - Hi there, I have a development server where I have tables that are bound to the dbo schema, I tried to use the "Transfer SQL Server Objects Task" to transfer these tables to my hosting providers SQL 2005 server. However for obvious reasons I'm...
   Database Forums (Home) -> DTS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]