How to use a variable as part of a string in SSIS

Question

4.00/5 (1 vote)

See more:

SQL-Server

SSIS

Hi,

I'm a newbie to SSIS.

I want to send an email message with a Send Mail task that says,

The file C:\MyFile.txt was not found.

but where C:\MyFile.txt is from a variable; i.e., can I open up Expression Builder for the MessageSource property and do

The file @[User::myFilePath] was not found.?

Posted 24-Feb-11 12:46pm

Brian C Hart86.6K

Add a Solution

Comments

milenalukic 5-Mar-11 18:29pm

Do you need to know how to send the mail message?
How to create the body of the message?
How to include the file name that you have in the variable?
How to get the file name?

If you post an example of your code it would help

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sairam.bhat · Answer 1 · 2011-03-10T01:02:00

Solution 1

please see this link it may be helpful to youhttp://www.mssqltips.com/tip.asp?tip=1443[^]

Posted 10-Mar-11 1:02am

sairam.bhat