Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Trudye
Posting Yak Master
169 Posts |
 Posted - 2008-07-29 : 07:06:22
|
| Hi Guys, I am creating a pkg that concatenates several files and processes them. How can I tell if one of the files is missing? In batch processing I can use 'If exists', does anyone know what the equivalent is in SSIS? If the file does not exist I want to send an email.Any ideas, is it even possible?Thanx,Trudye |
|
|
Trudye
Posting Yak Master
169 Posts |
Posted - 2008-07-29 : 07:08:54
|
| Can it be done without using VBA.Net? |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-07-29 : 07:47:09
|
| It's possible - If you have a set of filenames and its location, you can use Foreach Loop Item Enumerator (one of several ways). Add filename into each "Columns" collection so you can use "If Exists" as you know how.For example: Column 0 = c:\dailyfile1.txt, Column 1 = c:\dailyfile2.txt, etc.. I would use Script Task to evaluate file existence (If Exists or FileSize = 0) and send email accordingly.Might want to search on "Foreach Loop Item Enumerator" for detailed example as they are used in various ways. |
|
|
|
|
|
|
detecting missing files in a pkg