Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Using Excel Inside VBScript inside DTS PACKAGE

Author  Topic 

bbasir
Yak Posting Veteran

76 Posts

Posted - 2008-04-04 : 13:45:24
Is there any good reference material/book on how to use excel inside the vb script inside a DTS PACKAGE?

nr
SQLTeam MVY

12543 Posts

Posted - 2008-04-04 : 14:01:35
What do you mean?
Accessing the object model from vbscript?
There's lot's of examples of how to do that if you search. Otherwise just ask specific questions and you'll probably get suggestions.
I usually find it best to develop in VB then convert to vbscript

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -