RE: Modify DTS Package from Visual Basic

From: Nigel Rivett (NigelRivett_at_discussions.microsoft.com)
Date: 06/26/04 

Date: Sat, 26 Jun 2004 11:21:01 -0700

Sure you can change anything in the package from VB - you can even create it from scratch then run it.
Save the package to a VB file to see how to create and access properties.
After that play around with loading and looking at properties from VB.

My advice would be to think about what you want to be configurable and what to code in the package. You could just create everything from VB but that wouldn't probably be a good idea.
I usually configure in an activex script withing the package to keep it self contained.
And put anything generic that I need across all packages (setting server, databases, ...) in a loader.

"Igor Solovey" wrote:

> Hello. I'm trying to find out if it is possible for me to create some
> sort of a function to automatically modify a DTS package in a given
> SQL database. For example, I have 4 MS Access databases containing
> tables that I need to modify slightly and pull into one table in an
> SQL database. All 4 have the same fields and rules, they were just
> separated by the software for some reason. Either way, some day there
> will be an update to that software, a 5th, 10th file will appear. I
> want to have a program which asks for a new Access database name, then
> makes a new connection to it in the existing DTS package and uses an
> already existing ActiveX script to import the fields into a table in
> SQL. In a sense, it would automate what can be done pretty quickly in
> DTS editor in Enterprise Manager. Can anyone help?
>

Relevant Pages

  • RE: Resuming a failed DTS package - Proper ETL design with DTS package
    ... Somehow I'm supposed to be able to rollback and entire DTS package if it ... You use database transactions to bind multiple updates into a single atomic ...
    (microsoft.public.sqlserver.dts)
  • Re: Import data from Access to SQL2005 on daily basis
    ... You can use SSIS to execute your working 2K package by using the Execute DTS 2000 Package task. ... looking to transfer data on a daily basis from an Access database to ... in SQL 2000, but do not know how to go about it in SQL 2005. ... tried importing the 2000 DTS package into 2005 with little luck. ...
    (microsoft.public.sqlserver.dts)
  • Re: [Full-Disclosure] [SHATTER Team Security Alert] Multiple vulnerabilities in Oracle Database Serv
    ... Multiple vulnerabilities in Oracle Database Server ... > and Esteban Martinez Fayo of Application Security, ... > DBMS_REPCAT package ...
    (Full-Disclosure)
  • Re: Help with dtsrun and dts package.
    ... you need to have that on the box where the DTS package is ... What I have done is create an SQL database, ... Error string: The specified DTS Package ...
    (microsoft.public.sqlserver.odbc)
  • Re: perl MySQL using DBI - security issue
    ... Not sure if it's the best way, but the way I do it is to have that data stored in a config file that is owned by a dummy user and only readable by that user. ... All programs that need the database then have to be setuid that dummy user and then use the database package, 'drop' privs and then exit if privs can be regained. ... Allowing people to use these your DB-based code as libraries now requires you to vett the code since your users can't setuid their scripts to the dummy user. ...
    (comp.lang.perl.misc)
Loading