What software are you going to use...

I mean, like this

SELECT *

FROM

(

VALUES

...

Are you able to provide your sample data...

Who's got the ball?

wanttolearn1 (12/13/2016)

---

Thanks

i want the result to be in some hierarchy (this is after each ip "," followed by depth level

10.0.0.0,0

10.13.15.63,1

10.16.8.2,1

15.0.0.0,0

...

wanttolearn1 (12/13/2016)

---

want to build a table, which contains different ip and there sub-net.

when i pull the table i want to get result in way i know who os the...

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