Thanks for the question.

6.5 to 2000 with DTS. Ouch.

peacesells (6/26/2014)

---

Koen Verbeeck (6/25/2014)

---

The SSIS error messages are logged in the SSIS catalog. The reports in the SSIS catalog fetch their data from the SSISDB database.

In previous versions, the error...

DECLARE @multiplicator INT = 3;

--SELECT 1 AS ID

--INTO dbo.id_log

--UNION ALL

--SELECT 2

--UNION ALL

--SELECT 3;

WITH CTE_Tally AS

(

SELECT TOP (@multiplicator) n = ROW_NUMBER() OVER (ORDER BY a.object_id)

FROMmaster.sys.columns a

CROSS JOINmaster.sys.columns b

)

SELECT ID FROM

dbo.id_log

CROSS JOIN...

Greg Edwards-268690 (6/26/2014)

---

I am doing a bunch of things.

Now I want to do another thing, and it is similar, just in...

P Jones (6/26/2014)

---

Visio is my favourite tool for documentation and design (and the one available when you work in a restricted Microsoft shop!).

I reverse engineer my databases into Visio Premium...

Duplicate post.

Original query can be found here:

http://www.sqlservercentral.com/Forums/Topic1586319-391-1.aspx

Please do not crosspost. It wastes peoples time and fragments replies (like Phil Parkin).

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1586306-2799-1.aspx

You can use perhaps this piece of code:

Limit SSIS Package Execution At Any One Time

Put it in a for loop and loop until you can execute the package.

... and another one

http://www.sqlservercentral.com/Forums/Topic1586022-2799-1.aspx

CREATE PROCEDURE (Transact-SQL)

If I'm not mistaken, you can also let the cube wizard build dimensions for you.

Very interesting question, thanks.

meridius10 (6/25/2014)

---

Many thanks for all the advice. I might just buy and do a clean install of SQL Server 2014 Developer edition. I guess it works on Windows 7 64...

Crystal ball needed!

http://www.sqlservercentral.com/Forums/Topic1585731-3412-1.aspx