There is an alternative (and better, because no temp tables are involved) way of doing this.

In your OLEDB Source, enter the following in the SQL command text:

EXEC msdb.dbo.sp_get_sqlagent_properties

with result...

roger.plowman (2/1/2016)

---

below86 (2/1/2016)

---

Here is the reason I would NEVER EVER want to be on call for...

only4mithunc (2/1/2016)

---

I'm using this stored procedure as data source in the DFT of SSIS. This Stored procedure has got two result set.. so just trying to see if I can...

only4mithunc (2/1/2016)

---

Nice.. that worked thanks for your help.

I have one more question.. if there are two result sets like below, is there any way map them in SSIS?

EXEC dbo.GetOrderInfo...

Sean Lange (2/1/2016)

---

I would think this is considered against the licensing for Developer edition. As Gail said if you are uncertain then maybe you should ask Microsoft directly. However I...

Here is a formatted version.

create FUNCTION isArbeitstag ( @cDatum DATETIME

, ...

Instead of that, strip out the outer EXEC:

EXEC dbo.UseTempTable [params here]

WITH RESULT SETS

( ( ColInt INT NOT NULL, ColVarChar VARCHAR(99)) )

So what? It's still...

Well done on solving your problem.

Generally though, we aren't big fans of two of the techniques you have employed here: namely WHILE loops and scalar functions, for performance reasons.

Should you...

I'm with the DBA: the true version of code is what's in Production.

And if your development and release processes are strict enough, the version in SC will match what's in...

What have you tried so...

Hugo is heading in the right direction. This is quite tricky. Here is an outline solution.

Create a flat file connection pointing to your source file. Set the connection to have...

What do you mean by the following?

Lynn Pettis (1/28/2016)

---

Hey Phil, can you add a rollback in the CATCH block? I just noticed that I forgot that in the code I uploaded.

I fixed the code I...

Lynn Pettis (1/28/2016)

---

Tried posting how I might approach writing this update, but couldn't do it directly from work. When I got home last night, didn't even get on my...