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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date