Post #129,634
12/8/03 11:58:06 AM
|
You mean MTS objects?
[link|http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mts/mtxpg04_0eb7.asp|http://msdn.microsof.../mtxpg04_0eb7.asp]
-drl
|
Post #129,723
12/8/03 5:04:15 PM
|
DTS = Data Transformation Services
[link|http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_21rn.asp?frame=true|http://msdn.microsof...rn.asp?frame=true]
I have no first hand experience though.
-- Chris Altmann
|
Post #129,726
12/8/03 5:07:20 PM
|
ok, my bad thought that was "distrib transact"
-drl
|
Post #129,799
12/9/03 6:43:55 AM
|
Thanks
Exactly what I was looking for. Now if only I can implement it in Perl!
|
Post #129,828
12/9/03 11:29:51 AM
|
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
12/9/03 6:47:41 PM
|
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
12/10/03 8:55:30 PM
|
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
12/10/03 9:28:49 PM
|
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
12/11/03 6:46:29 PM
|
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
12/10/03 9:48:34 PM
|
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
12/11/03 8:08:50 AM
|
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"
|