SQL Server Performance

Dynamic DTS packs.

Discussion in 'SQL Server DTS-Related Questions' started by droesch99, Oct 24, 2003.

  1. droesch99 New Member

    Has anyone done, or found a tool that can build Dynamic DTS packs through a client application, or through a intranet ap, using asp pages...?

    We have some Data Clerks that run DTS packs, and we want to take away that direct access and make a intranet ap for more control and security.

    -David Roesch
    San Diego, Ca
  2. bambola New Member

    Could you explain a bit better what are they supposed to do?
    If for example those DTS are exporting the same structure with different parameters, you can do the following
    - Create a table in that format.
    - Create a DTS package that exports the content of the table into the desired format.
    - Write a stored procedure that excepts parameters if there are and populates that table.
    - Call the DTS package from the stored procedure.
    You might also be able to use bcp for your task. but without a better understanding of what you need to do it is hard to say more.

    Bambola.
  3. satya Moderator

    True, Bambola counter will help to assess the information.

    You can do it by changing owner of DTS package and schedule them to run with SQLAgent account.
    May also refer to books online about DTS SECURITY for more information.



    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page