That might be doable

Post #129,828 by ben_tilly 12/9/03 11:29:51 AM Reply	That might be doable The state of the art a few years ago was that Win32::OLE could be used to access COM interfaces, but couldn't be used to publish them. To publish them you had to buy an extension from ActiveState. So if you just need to use a COM interface that someone else has exposed (eg to drive Excel), then you are fine. If you want to create your own, that is a different story. That may have changed since then. I would ask on Perlmonks to find out if it has. If it hasn't, then your first problem is figuring out which product you have to buy from ActiveState to get the COM interface in Perl. And then when you get it, you may find it unmaintained for lack of interest... My understanding (confirmed by google) is that the situation in Python is [link\|http://www.python.org/windows/win32com/COMTutorial/index.htm\|much better]. Cheers, Ben "good ideas and bad code build communities, the other three combinations do not" - [link\|http://archives.real-time.com/pipermail/cocoon-devel/2000-October/003023.html\|Stefano Mazzocchi]
Post #129,921 by broomberg 12/9/03 6:47:41 PM Reply	Further reading shows much worse This particular environmnets (SQL Server / DTS) demands C++ according to the evil docs. While MS docs usually lie, I'm not feeling very adventuresome. I'll shell out to external Perl code to deal with flat files.
Post #130,139 by mmoffitt 12/10/03 8:55:30 PM Reply	VB works well doing this. It's been a while, but I have done several. bcnu, Mikem Java, Junk. Both start with a "J", both have four letters. Coincidence? I think not.
Post #130,149 by orion 12/10/03 9:28:49 PM Reply	IIRC SQL Server can export to a VB Module which will generate the tables, etc for DTS. Been a while since I used it, but I do remember doing just that at my last job. I also remember having to edit the modules because they had bugs in them that the DTS function created. SQL Server 2000 did this, not sure about earlier versions. *"Lady I only speak two languages, English and Bad English!" - Corbin Dallas "The Fifth Element"*
Post #130,387 by lincoln 12/11/03 6:46:29 PM Reply	My past experience At my last job we used a lot of DTS packages that we created by hand and were run as an object within our VB programs. One thing that we found out the hard way was, if a DTS package failed, the package would not return a failure message - it just sent back a integer zero, (or whatever it was) that signified everything executed perfectly. lincoln "Windows XP has so many holes in its security that any reasonable user will conclude it was designed by the same German officer who created the prison compound in "Hogan's Heroes." - Andy Ihnatko, Chicago Sun-Times [link\|http://users3.ev1.net/~bconnors/resume.htm\|VB/SQL resume] [link\|http://users3.ev1.net/~bconnors/tandem_resume.htm\|Tandem resume] [link\|mailto:bconnors@ev1.net\|contact me]
Post #130,151 by deSitter 12/10/03 9:48:34 PM Reply	Re: VB works well doing this. It's likely that all MS compilers have the same sticky, doughy internals, and that the syntax is only a thin sugary crust. -drl
Post #130,202 by orion 12/11/03 8:08:50 AM Reply	VB.NET is sort of like Visual C++ now they got rid of Gotos and Gosubs, and made a try/catch method of debugging. Just remove the semicolons, rewrite the code a bit, and you can convert from C++ to VB.NET without too much of a hassle. VB 6.0 is a totally different matter. :) *"Lady I only speak two languages, English and Bad English!" - Corbin Dallas "The Fifth Element"*

Welcome to IWETHEY!