SSIS Tutorial Part 84-Attach Multiple Files Dynamically in Send Mail Task in SSIS Package

Поделиться
HTML-код
  • Опубликовано: 8 янв 2025

Комментарии • 30

  • @gurvinderkaur3008
    @gurvinderkaur3008 7 лет назад +1

    Awesomely awesome videos by Techbrothers!!! Very detailed and very clear explanation of each topic.

  • @nilayshah9861
    @nilayshah9861 4 года назад

    Very good explanation . Thanks for the video

  • @erwinda14
    @erwinda14 8 лет назад +1

    thanks for the video, worked like a charm

    • @TechBrothersIT
      @TechBrothersIT  8 лет назад

      +erwinda14 Glad to hear that it worked for you. Thanks for watching and leaving comments.

  • @jesflo4
    @jesflo4 4 года назад

    Very helpful, thank you!

  • @ourfiberworld7493
    @ourfiberworld7493 2 года назад +2

    Please make video on same task but the requirement is to select file from path based on the name.

  • @nellorebirdspets
    @nellorebirdspets 2 года назад

    Super video .could please tell the same that for the files which are present in folder and the which are small must be sent rest of the files shouldn’t be sent from the folder ….plzzz make a video

  • @madanamanohara4573
    @madanamanohara4573 3 года назад

    Really a nice vide. If no attachment it should not send mail. How to implement this?

  • @krismaly6300
    @krismaly6300 8 лет назад

    I enjoyed watching this video and recommend others.
    Suggestion.
    If the package fails is there a simple way to send email saying "Package failed"
    can you add this feature?
    Thanks for educating the community and appreciate.

  • @ChintanDave
    @ChintanDave 4 года назад

    However you mentioned that link of creating SMTP server is available in description, it is not the case. Please provide the link of Video ASAP.

  • @jovim3206
    @jovim3206 2 года назад

    How to delete the error files from the folder after sending them using send mail task. You mentioned about loop through the files and use file system task to delete the files. Is there any of your videos available for that or else can you make a video for that. Thank you! I have been learning a lot from your videos.

    • @TechBrothersIT
      @TechBrothersIT  2 года назад

      yes there are videos on that topic. plz check the list

  • @akjay143
    @akjay143 3 года назад

    Hi, I have setup SQL server mail configuration & using that SMTP name as SMTP server name in SSIS 'Send mail task'. This is correct ?
    While executing the SSIS. I AM GETTING BELOW ERROR.
    Error: 0xC002F304 at Send Mail Task 1, Send Mail Task: An error occurred with the following error message: "Failure sending mail. System.Net.WebException: The remote name could not be resolved: 'MailNotification'".
    Task failed: Send Mail Task 1
    Thanks in advance.

  • @nishaddheeraj2
    @nishaddheeraj2 8 лет назад

    Really great trick and knowledgeable video!!. Is SSIS know "|" delimiter or we can use any delimiter?

  • @krismaly6300
    @krismaly6300 8 лет назад

    I think I added another email task then set the
    Failure as Value
    Evaluation Operator as Constraint
    Doe this work?

  • @ggtk4448
    @ggtk4448 4 года назад

    Good job.

  • @sunilkumarkashyap199
    @sunilkumarkashyap199 6 лет назад

    Hi, not able to find the link/video, how to configure the SMTP on local system.
    Please share
    Thanks

  • @ejt5385
    @ejt5385 8 лет назад

    Hi, this for this, this helps a log How about send different email if attached file is not there?

  • @jeffersonromario5936
    @jeffersonromario5936 Год назад

    Does anyone know how to send emails? I do not understand well. Do I have to enable the gmail port? the 587? I have to give extra permissions? Do I have to enable something in the sql management? I have tried sending emails with a sql task where all the information including the email password is placed and it has worked for me, but using the messaging component does not work for me, I am already going crazy.

  • @leelavin
    @leelavin 7 лет назад

    Can you please let me know how to send ssrs report via mail in ssis ,Is it possible ?

  • @leelavin
    @leelavin 7 лет назад

    Basically I want to send matched records via mail ( excel attchment) ,based on matching key

  • @DA-lq3tz
    @DA-lq3tz 4 года назад

    [Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail. System.Net.WebException: Unable to connect to the remote server System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 172.****:25".

  • @nakshudhakshu472
    @nakshudhakshu472 7 лет назад

    How could we send the .zip files?

  • @Mrleothelion86
    @Mrleothelion86 9 лет назад +1

    Hi, where's the video on how to create an SMTP Server?

    • @TechBrothersIT
      @TechBrothersIT  9 лет назад +2

      +Leonard Mbah Acha , please check this link ruclips.net/video/DYMBNOE9EQs/видео.html

    • @Mrleothelion86
      @Mrleothelion86 9 лет назад

      Thank you!!

    • @asif92cool1
      @asif92cool1 7 лет назад

      Thanks a lot!!

  • @danieljoubert7937
    @danieljoubert7937 4 года назад

    Thanks

  • @julissadc6303
    @julissadc6303 5 лет назад

    I made the same thing and it still tells me I have no recipient