• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • Last Modified:

RE : SSIS mail task

Hi,

Please help to let me know how can i send the attachments through Mail task in SSIS.

Attachment is placed under one folder in my disk and file name is dynamic so Mail task should pick up attachment path from my variable.

Thanks
0
rajneesh1978
Asked:
rajneesh1978
1 Solution
 
jonaskaCommented:
You need to use Expressions. Look at the attached screencast.
jonaska-423645.flv
0
 
Alpesh PatelAssistant ConsultantCommented:
Hi,

Save file path in Variable and assign it to FileAttachment in expression. Screen shot
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
Hello,
You can use the file watcher task to look for a specific EXTENSION and populate a variable with the file name and use that variable in the attachment expression as Patel Mentioned.

Please let me know if you need more info.
Thanks
Jason

file watcher task:  http://www.sqlis.com/post/file-watcher-task.aspx
0
 
rajneesh1978Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now