Thanks Gary !:-)

Hi Gary,

I am still facing problems:

I am using following final script.

Foreach ($file in get-ChildItem \\serverName\NewFolder\SSIS_Script_Runner_Test\OutputLogs\ -include *.txt -recurse)

{

# Assuming it is an array returned

$messages...

Gary Thanks again !

I modified what you have mentioned as below:

# Deal with each text file in turn

Foreach ($file in get-ChildItem \\servername\OutputLogs\ -include *.txt -recurse)

{

# Assuming...

Gary,

I am using your 2nd code as that will send less emails to the team with all files attached, but I am getting following error:

Missing 'in' after variable in foreach...

Gary Istvan Varga (12/13/2009)

---

See Jeffrey Snover comment to this question: http://www.searchmarked.com/windows/how-to-send-an-email-using-a-windows-powershell-script.php

FYI Jeffrey Snover is the MS guy for PowerShell. No Jeffrey Snover, no PowerShell (some of his colleagues will have...

John Rowan (12/11/2009)

---

If you've set up the script task...

Gary Istvan Varga (12/11/2009)

---

My point is that you cannot take the output from the second part as an input to the third as you are then trying to treat the...

Gary Istvan Varga (12/11/2009)

---

Sorry but I only have 30 seconds...

The first part is selecting all .txt files (output: file objects).

The second part is selecting each line of text that matches...

Jack Corbett (12/11/2009)

---

You'd use Move-Item to move the files. Like this:

get-ChildItem -include *.txt -recurse | select-String -pattern "Msg","Level"|Move-Item -destination [path]

I don't know how to email the files in...

John Rowan (12/8/2009)

---

I am stuck with the event handler part and send mail task !

Why the event handler has execute SQL task with a dummy statement ?

Also the variables...

John,

Any ideas for the issue I am facing.

1. I want to fail the execute process task only if the script fails and log the error message.

2. Send email.

You can refer...

As it was a string manipulation question, so thought of posting here....

Perfect paul and steve !

After posting this I was playing with SSIS string function and I was able to figure out:

@[User::ScriptFolder] + RTRIM( SUBSTRING (@[User::filename],31,40) )

Thanks for help,

\\K...

becklery (12/4/2009)

---

I was also interested in this. In case someone is still looking for a solution, have a look here:

http://cognitivecache.blogspot.com/2008/08/log4j-writing-to-dynamic-log-file-for.html%5B/quote%5D

Can this be used in SSIS ? If yes,...

Thanks John for your detailed post !

Your approach is very good, but I have a limitation that I cannot modify the package, but can add functionality to it.

The only point...