• Replies 2 replies
  • Subscribers 331 subscribers
  • Views 57 views
  • Users 0 members are here
Related

need SQL help

Former Member
Former Member $organization

Hi

I need guidance to do following excercise.

I have a SP which I need to schedule to run every night and get the output in TXT file. It’s a quite huge file which I need to compress and send by FTP. I believe this whole process can be scheduled in SQL Jobs.

Can anyone suggest correct coding of it?

Thanks for help.

Varsha

Sydney Symphony

Database Analyst

Parents
  • Former Member
    Former Member $organization

    Thanks Ben

     

    I’m trying to get SSIS set up properly here..

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Ben Gu
    Sent: Wednesday, 3 November 2010 10:23 AM
    To: Varsha Karnik
    Subject: Re: [Tessitura Marketing Forum] need SQL help

     

    Hi Varsha,

    Good day.

    Maybe you can check this out.

    Using SSIS to zip files and email the zipped files

    http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/64028/

     

    have fun

    Ben

    From: Varsha Karnik <bounce-varshakarnik2805@tessituranetwork.com>
    Sent: 11/2/2010 6:12:47 PM

    Hi

    I need guidance to do following excercise.

    I have a SP which I need to schedule to run every night and get the output in TXT file. It’s a quite huge file which I need to compress and send by FTP. I believe this whole process can be scheduled in SQL Jobs.

    Can anyone suggest correct coding of it?

    Thanks for help.

    Varsha

    Sydney Symphony

    Database Analyst




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Former Member
    Former Member $organization

    Thanks Ben

     

    I’m trying to get SSIS set up properly here..

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Ben Gu
    Sent: Wednesday, 3 November 2010 10:23 AM
    To: Varsha Karnik
    Subject: Re: [Tessitura Marketing Forum] need SQL help

     

    Hi Varsha,

    Good day.

    Maybe you can check this out.

    Using SSIS to zip files and email the zipped files

    http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/64028/

     

    have fun

    Ben

    From: Varsha Karnik <bounce-varshakarnik2805@tessituranetwork.com>
    Sent: 11/2/2010 6:12:47 PM

    Hi

    I need guidance to do following excercise.

    I have a SP which I need to schedule to run every night and get the output in TXT file. It’s a quite huge file which I need to compress and send by FTP. I believe this whole process can be scheduled in SQL Jobs.

    Can anyone suggest correct coding of it?

    Thanks for help.

    Varsha

    Sydney Symphony

    Database Analyst




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data