You have been here long enough to realise that this is...

Read the text files, check the errorlog,...

Lynn Pettis (10/6/2016)

---

If you are accessing the tables on the linked server and doing all the work on the local server, you are pulling all the data across the network...

Ed Wagner (10/6/2016)

---

Yeah, that's a good one. Be...

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