OK. Then you are...

I just had another idea, which may or may not work in practice.

Create a 'master' package. This package searches a specific local folder and executes any packages it finds there.

Deploy...

SQL_Surfer (2/2/2016)

---

I've about 200 SSIS packages that needs to be run on 10 different instances. What is the best way to configure this dynamically? Ideally I'd like to store them...

Dave R (UK) (2/3/2016)

---

Hi all,

a, hopefully, quick question if I may.

I am creating packages for a client that utilises an FTP Connection Manager. I have set this up, tested...

roger.plowman (2/2/2016)

---

Phil Parkin (2/2/2016)

---

roger.plowman (2/2/2016)

---

Phil Parkin (2/1/2016)

---

roger.plowman (2/1/2016)

---

below86 (2/1/2016)

---

Here is the reason I would NEVER EVER...

roger.plowman (2/2/2016)

---

Phil Parkin (2/1/2016)

---

roger.plowman (2/1/2016)

---

below86 (2/1/2016)

---

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

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...