Dynamic Table Names in DTS

From: Jeremy (anonymous_at_discussions.microsoft.com)
Date: 07/19/04

  • Next message: kk: "DTS - Text column and buffer size" 
    Date: Mon, 19 Jul 2004 13:40:33 -0700

    I am new to DTS packages and not familiar with the object
    model. I want to simply pull the results of a query on
    one Server to another and save the results in a table
    based on the date.

    I have figured out a way to name a table I created based
    on a text and date combination (i.e. BR200407) using DTS
    Dynamic Properties and global variables, but it just
    doesn't seem clean. Like I said, it works, just feels
    like there is a better way. I would greatly appreciate
    any suggestions. Thanks.

  • Next message: kk: "DTS - Text column and buffer size"

    Relevant Pages

    • RE: Recover SQL files & DST packages from server backup
      ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... >> Server Settings''. ... >> In order to backup and restore the DTS Packages, ...
      (microsoft.public.windows.server.sbs)
    • it all started on 5/27....
      ... individual DTS packages on SQL Server 2000 SP 4 that import and convert ... The SQL lives on a separate server than Pervasive. ... the same machine as SQL Server 2K SP 4. ... Now, if I execute the DTS packages individually on the server, all ...
      (microsoft.public.sqlserver.dts)
    • Re: Very Very Urgent, Please Help
      ... does your packages are stored in the MSDB database? ... Have you changed your main package to use the right SQL Server instance? ... When my main dts package calls other dts packages getting timeout immediately. ...
      (microsoft.public.sqlserver.datawarehouse)
    • Re: Very Critical, Please help
      ... Check with your Server team to make sure that nothing emanating from the SQL Server is being blocked from leaving the box. ... My Main dts package calls many other simple dts packages. ... >> Step Error Help Context ID:0 ... >> General network error. ...
      (microsoft.public.sqlserver.dts)
    • DTS periodic failures
      ... It runs 16 DTS packages scheduled to run once per minute via SQL Server ... server but each DTS package only accesses a single database. ...
      (microsoft.public.sqlserver.dts)
    Loading