Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2002
    Location
    Camden, NJ
    Posts
    3

    Question Unanswered: DTS a large file

    I currently have a DTS that runs a Stored procedure.

    The stored procedure does a hit from a few table and returns a large amount of data (100K + rows).

    I tried to set up the DTS to send me the file as a .csv, but it is simply to big of a file.

    Is there a way I can get this to work, do I have to use winzip or something of that nature?

    I simply want the sql hit to run each month and the DTS to run the command to email me the file.

    Any idea would be appreciated.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What other alternatives do you have to emailing ? What will you do with the file once it has been emailed to you ?

  3. #3
    Join Date
    Sep 2002
    Location
    Camden, NJ
    Posts
    3

    Lightbulb After I receive the file

    The file is used in a statistical program by the marketing department.

    Thanks
    Tom

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Instead of emailing, why don't you just ftp ?

  5. #5
    Join Date
    Sep 2002
    Location
    Camden, NJ
    Posts
    3
    Originally posted by rnealejr
    Instead of emailing, why don't you just ftp ?
    We were hoping to have the DTS run every month and send me the file.

    The idea was to make this an automated as possible.

    That is why I hoping I could just have the DTS email me the .csv.

    I am not sure what you mean by FTP, I know what FTP is, but are you saying that I should FTP the file after it has been created?

    Thanks
    Tom

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    One of the tasks available with dts is a "file transfer protocol task". How are you creating the csv using dts ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •