Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jul 17, 2000

VBS option for (SQL Server 2000 Beta) DTS Previewed

By Anthony Loera

I have lucky enough to be working with SQL Server 2000 Beta for a little while. I read a lot about it from everyone, but I have yet to notice anything on the new Package option for DTS. This is in the beta that I have been working with, and it works wonderful, so I hope it will be in the released version.

Currently in SQL Server 7 we have a GUI workflow that we can manipulate and then save as an Internal Package in SQL Server, or outside SQL Server. The only problem (at least for me in the past) is changing the connection of the created package if I wanted it to run without the whole GUI setup... (for example if I wanted to include it in a VB program, and let the user change some variables, and connections.)

In SQL Server 2000 Beta, you can save your DTS package as a VB Script file. This is a tremendously great option!! Now someone like me (Simple Dev guy) can look at the VBS file, cut/paste into a VBA module (like access), or VB 6 Module, and completely rapidly create changes in connections, variables, etc. Even create a class object based on the VBS file... and on and ON!! Wahoo!! (Can you tell I'm excited?)

This brings the rapid speed of the DTS Pump into my own custom SQL applications, using my connections, variables, and UI. Which may be slower than BCP for one table or data transfer, but if you have 2 table/Data or more transfers(or Transformations of Data) that you need to do(or want to do) in parallel for speed in an easy way, it kicks BCP's butt!

Anthony Loera has been goofing around VB for more than 5 years. Has coded for Bell Atlantic, & Americatel Telecom companies. Currently contracted on a couple projects for a small unknown company called Microsoft, and doing a side project for another small pharmaceutical company, which would kill him if it's name was ever divulged. ;)

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM