Change the 'Sensitive' property of either the environment variable or of the package...

PSB (12/13/2016)

---

Hi,

I am getting the error below from the SSIS package scheduled from a SQL agent job . Locally the package works fine.

Description: Unable to map an environment...

zouzou (12/13/2016)

---

Hello all,

The same query with a group by clause I try to run on SQL Server 2005 and on SQl Server 2014 but it seems that every time i...

sqlfriends (12/12/2016)

---

Thank you, will give a try.

Also my other part of the questions, if SQL data tool not installed, but just installed SSMS, can I edit or create maintenance plan?

It...

OK, yet a SQL Agent job which runs the package gives that error ... are you certain?

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