IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / IIRC SQL Server can export to a VB Module
Post #130,149
by orion
Picture of orion
12/10/03 9:28:49 PM
Reply
New 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
New 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]
     Home made DTS objects in SQL/Server - (broomberg) - (11) - Dec. 8, 2003, 10:48:11 AM EST
         You mean MTS objects? - (deSitter) - (10) - Dec. 8, 2003, 11:58:06 AM EST
             DTS = Data Transformation Services - (altmann) - (9) - Dec. 8, 2003, 05:04:15 PM EST
                 ok, my bad thought that was "distrib transact" -NT - (deSitter) - Dec. 8, 2003, 05:07:20 PM EST
                 Thanks - (broomberg) - (7) - Dec. 9, 2003, 06:43:55 AM EST
                     That might be doable - (ben_tilly) - (6) - Dec. 9, 2003, 11:29:51 AM EST
                         Further reading shows much worse - (broomberg) - (5) - Dec. 9, 2003, 06:47:41 PM EST
                             VB works well doing this. - (mmoffitt) - (4) - Dec. 10, 2003, 08:55:30 PM EST
                                 IIRC SQL Server can export to a VB Module - (orion) - (1) - Dec. 10, 2003, 09:28:49 PM EST
                                     My past experience - (lincoln) - Dec. 11, 2003, 06:46:29 PM EST
                                 Re: VB works well doing this. - (deSitter) - (1) - Dec. 10, 2003, 09:48:34 PM EST
                                     VB.NET is sort of like Visual C++ now - (orion) - Dec. 11, 2003, 08:08:50 AM EST

To boldly go where no LRPD has gone before.
68 ms