SQL Server Performance

New to DTS, help needed to create new package!

Discussion in 'SQL Server DTS-Related Questions' started by Jaybee from his castle, Apr 19, 2004.

  1. Hi all,

    I was wondering if it were possible to automate the following processes:

    Have a DTS package unzip a winzipped csv file in my Outlook inbox, import the contents to a new table according to the existing layout of the csv (rather like the 'Select Into' command in SQL Server), and every subsequent day append the contents of a new, zipped csv (which will always have the same layout) into the database.

    I suspect it'd be simpler to manually import the first file, along with the in-process creation of the table, in advance of the first running of the package. The biggest problem I foresee is getting the package inside Outlook, which would keep the csv file in a .dbx file, I believe.

    I'd be grateful for some tips, and perhaps an overview of how I should go about this.

    Thanks in advance,


    JayBee.

    France.

    The finest wines.

    The tastiest cuisine.

    The most delicious women.
  2. satya Moderator

    First of all you should prepare the output file to a .CSV format from the outlook, otherwise there is no possibility to task the DTS to pickup the file from Outlook.

    I think it may be possible using VBScript, for this may refer to http:/www.sqldts.com website for goodies and tips.

    If you can accomplish this in DTS then schedule it as a job and ensure the SQLAgent service account has required privilege to complete the task.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. CanadaDBA New Member

    Let's forget DTS package and just do the process manually using "Import Data" under "All Tasks". Were you able to do the process, this way?

Share This Page