Eric M Russell (10/6/2016)

---

Jeff Moden (10/5/2016)

---

komal145 (10/5/2016)

---

i have check other tables and do lot of stuff to get this point . So , i have to do it in ssis....

The sensitive values cannot be retrieved, unless the user who originally saved the project opens it again.

Redgate SQL Prompt and SSMSBoost both save a history of queries.

Why are you doing this, out of interest?

SQL-DBA-01 (10/6/2016)

---

Hi Phil,

While deploying getting the below Warning. But able to deploy the packages successfully. No error.

Is there something to look into against this warning?

TITLE: SQL Server Integration Services

------------------------------

Warning:...

SQL-DBA-01 (10/6/2016)

---

Hi Phil,

It worked...:) I am able to import/deploy the .ispac packages. Thanks much.

If I need any further help from you on this will let you know.

Thanks much for your...

And good luck handling Excel's semi-random data-type guesswork 🙂

Sure. Skip the header rows by setting 'Data Access Mode' to 'Table name or view name variable'.

Set the variable's value to a range which excludes header rows, eg:

sheet1$A2:D

which...

Yes. Create first, then folder structure and finally deploy.

SQL-DBA-01 (10/5/2016)

---

Hi Experts,

I need to transfer SSIS Packages which are under "Integration Services Catalog" under SSISDB.

Basically I need to get packages exported to Non Prd servers so that dev team...

Luis Cazares (10/5/2016)

---

If you haven't closed the window, use Ctrl+Z until you undo all changes. Then run the code to restore the procedure to its original code.

If not, follow Phil's...

deekadelic (10/5/2016)

---

I was working in the "Modify" script of a stored procedure just now. I accidentally selected only a small part of the code of the script, then ran it...

Based on what you said about grouping, the results look OK to me. This is difficult to troubleshoot when we don't know what the source data looks like and we...

tfoley 60758 (10/5/2016)

---

Hi All,

We have an on-premise CRM 2016 setup that's using SQL 2014 in Denver, CO. We have a large office in Australia and CRM access is pretty slow...

Eric M Russell (10/5/2016)

---

Phil Parkin (10/5/2016)

---

If there is one feature I'd love to see added is the ability to stronly type worksheet columns, meaning for example that all values within...