mandavli (12/12/2016)

---

I created a package in visual studio data tools , SQL connection works fine. and Package ran fine.

Then I loaded that package on to the server in Integration services...

SQL-DBA-01 (12/12/2016)

---

This gives me the list of packages, thanks for that. But each package has few configuration associated to it.

If I could get the config details, would have been excellent...

Also starting from SQL 2016, whenever there is an upgrade of SSMS, do I need to uninstall the old one and install newer version? It seems there is no upgrade...

--Comment deleted

SQL-DBA-01 (12/12/2016)

---

Hi Experts,

If I need to list out all the SSIS packages under the Integration services catalog folder how to get the details by writing simple T SQL and...

Thanks, Tim. It's reassuring to know that I...

alicesql (12/9/2016)

---

I have an SSIS package that has an Execute SQL task to

SELECT SUBSTRING(MAX([InvoiceDate]),1,2) as Monthsql

FROM BJmm (Table has a string date field per recipient requirement)

The Sql Source...

alex.sqldba (12/9/2016)

---

Aye. Well, ive been experimenting.

If I set the Transaction Option to 'required' rather than supported, I get an error about being unable to start a distributed transaction.

Edit: This is...

I had always assumed that the whole thing was a single implicit transaction. I'm not...

alex.sqldba (12/9/2016)

---

Hiya, thanks! I like this approach of using the delete/output as an SSIS Source.

However.

I am using the ADO.NET provider. And it's working fine, except in one particular occurrence: Should...

alex.sqldba (12/8/2016)

---

Evening All,

I have an archive routine that runs every night, it inserts some rows and then performs a delete. Basic stuff.

I have had to move the archive database to...

You need to make the updates conditional. Add something like

WHERE a.load_id <> q.load_id or a.load_id is null

to both queries.

You still haven't explained why.

Lowell, that's a neat trick!

Next step would be some refinement to return the actual SQL needed, ready for cut & paste. This sort of thing (borrowing your code):

IF OBJECT_ID('tempdb..#temp', 'U')...

I think you are out of luck. There is no magic 'reduce the size of files without shrinking them' command.