Hello, I'm building my first DTS package with workflows, etc.
1) connect to an ftp site, dump a file into a folder on the server
2) send email task "file not there" kind of thing
3) A transform data task between two connections - the 1st is the text file and the second is a table in a SQL Server database
I put an "on success" workflow from #1 to #3 and an "on failure" from #1 to #2. My reasoning was that if the file was not there, #1 should fail and fire off the email. To my surprise, when it ran I got: "1 task(s) failed during execution." Oddly enough, #1 was successful and then #3 between the two visual connection objects failed (of course... the file is not there).
Could someone point out what I'm doing wrong?