dbaforever (10/17/2016)

---

I am attempting to migrate 2012 packages that are stored in the SSISDB catalog to a 2014 instance. After migrating the catalog failed, I moved on to a more...

river1 (10/17/2016)

---

Hello, Thank you for the feedback. Both on same machine. The ssis package performed much better then the script. With the package I take 16 minutes. With the script...

You should also be aware that it runs against the system databases (master, model etc.)

This command runs in its own context. What that means is that you have to put all of the SQL - including the variable declarations - into your variable and...

Aha, that explains it. I was looking on Developer edition, so did...

sqlfriends (10/17/2016)

---

Yes, by directly entering the URL you told me I can see, there is a download and remove, and upload brand package there.

But it is still not on the...

How did you implement that WHILE loop in your SSIS package?

Brandie Tarvin (10/17/2016)

---

No. But I'll give it a shot. Last time I saw behavior like this, it was because SSIS was running on an...

Try navigating to the URL directly and see what happens. It should...

sqlfriends (10/17/2016)

---

I read the article https://www.mssqltips.com/sqlservertip/4483/customize-sql-server-reporting-services-reports-manager-portal/

for SSRS 2016 brand, I think which is a good feature.

But I could not find the Brand on the setting menu. It is missing.

I am...

Steve Jones - SSC Editor (10/17/2016)

---

Phil Parkin (10/17/2016)

---

Spammers have upped their game recently. Some are starting to mention 'SQL' or 'database' in the subject line, the ****ers. What's the latest...

Brandie Tarvin (10/17/2016)

---

rodjkidd (10/17/2016)

---

So hands up who loves the idea of a production db being called Test_Autos on a server that was the test server...

Yes a production server details were...

Spammers have upped their game recently. Some are starting to mention 'SQL' or 'database' in the subject line, the ****ers. What's the latest on migration to new forum software?

Actually, this bit is not quite correct. SSDT and SSDT-BI were...

After attaching the databases, you should consider upping their compatibility levels, to take advantage of all the new features. After testing, of course.