Well, your...

Take a look at the Export Column transformation in SSIS.

SSIS is not build to be interactive.

This means there are only work arounds, such as looping and using WAITFOR in TSQL or even messageboxes in the designer.

It seems splitting it...

The job steps are stored in the [msdb].[dbo].[sysjobsteps] table.

You can filter on the subsystem (only TSQL) and then search inside the command for email addresses.

peacesells (6/24/2014)

---

I know in previous versions, msdb database would log/capture all sql server agent job details. Now with 2012 and SSISDB, if a job fails in SQL Agent where...

Can you give the table DDL if possible, some sample input and the desired output?

In the first link of my signature you find an article that helps you with those...

Very interesting question, thanks!

ag1975 (6/24/2014)

---

Koen,

Thanks for your advice.

I ended up recreating the entire data flow, and now the error has disappeared. I think I may have run into some strange corner case...

Luis Cazares (6/24/2014)

---

Congratulations Koen. You're certainly one of the top posters on Bi.

On a completely different subject, I'm taking 20467BC course this week and found some surprises like using...

Can you check the data types of all the columns in the data flow and compare them with the data types assigned in the input buffer? (you can find this...

Grant Fritchey (6/24/2014)

---

Well, not quite so close...

If you don't specify any package configurations in the package itself, it should normally run successfully.

You can leave the default protection level, but you will get some warnings about SSIS...

Easy one thanks!

Yes, I'm getting closer 😉

Try debugging the old school way. Add messagebox at every line and see how far you get...