August 20, 2008 at 9:10 pm
i am using SSIS to select a file from a server and email that to selected receipient.
Say the filename are
1. Appln1.txt then email should go to appln1@test.com
2. Appln2.txt then email should go to appln2@test.com
3. Appln3.txt then email should go to appln13test.com
How do i achieve this thru SSIS? Please let me know
August 21, 2008 at 1:22 am
Use a variable to hold the first part, use expressions on the filepath and email to build up the correct value.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 21, 2008 at 1:59 pm
Thanks for the reply. Since this is the first SSIS i am doing, could you please little more or give me some link which has some examples.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply