Email attachment

More
3 months 5 days ago - 3 months 5 days ago #22830 by hanisultan
Email attachment was created by hanisultan
Not sure what I did wrong but when I have an email with attachments using *.* in this project, it uses a different mask and strangely enough, it adds the mask all the files but it only grabs one file, it is hard to explain it so I have included some screen shots and if you need the log files let me know.  Thank you 
Attachments:
Last edit: 3 months 5 days ago by hanisultan.

Please Log in or Create an account to join the conversation.

More
3 months 4 days ago #22831 by Peter.Jonson
Replied by Peter.Jonson on topic Email attachment
I have a silly question

I can see that you have 3 attachments.

Do they have the same name?

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
3 months 4 days ago - 3 months 4 days ago #22832 by hanisultan
Replied by hanisultan on topic Email attachment
I not the same name but I think I need to explain to you how I name these files  - I use a variable <company> at the start of the package - and I loop through a list of companies and process them using sqlcmd and I use the variable there to create the name of the file which is nothing but the execution log of the SQL command and I place the files in a folder (this folder is cleared of previous files at the start of the package.   I have attached some screen shots but let me know if you need more information.  The strange thing is if I run the sendemail object by itself it works fine but only if I make it the starting point and run the package so it is running only the sendmail object.  I thought maybe I need to reset the <company> variable before I send the email but that didn't work.  A clue - when it uses the same name for all files, it is always the last variable value - does that make sense?  Let me know if you need more info.  Thank you 
Attachments:
Last edit: 3 months 4 days ago by hanisultan.

Please Log in or Create an account to join the conversation.

More
3 months 4 days ago #22833 by Peter.Jonson
Replied by Peter.Jonson on topic Email attachment
Sorry, still confused.

Can you email us your package, please?

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
3 months 4 days ago #22834 by Peter.Jonson
Replied by Peter.Jonson on topic Email attachment
Just a suggestion

Maybe some files are locked when you try to send them.

Can you try putting 5-second pause before sending the email?

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
3 months 3 days ago #22835 by Peter.Jonson
Replied by Peter.Jonson on topic Email attachment
Thank you for sending the package over.

I can see that your "send email action" has only one file selected as an attachment.

I am really struggling to understand the issue and since it is taking so long to resolve I am happy to connect remotely and assist.

I am available for the rest of the day.

We can use Microsoft teams

Peter Jonson
ETL Developer
The following user(s) said Thank You: hanisultan

Please Log in or Create an account to join the conversation.

Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.