inevercheckthis2002 (8/25/2016)

---

The goal is to have an SSIS package run from a SQL Server Agent job access an Excel spreadsheet over a UNC path.

Which credential will need permission to read...

komal145 (8/24/2016)

---

Mine are xlsb files and they require retain same connection , as i am trying to load 2 xlsb files in foreach loop ...each file load process has...

komal145 (8/24/2016)

---

It runs fine with all the SQL agent owner when i diable to task which copies the file to a archive folder. This can be done in Dev...

komal145 (8/24/2016)

---

I am trying to load the excel file from variable in for each loop and load the file to a table. It runs fine in the BIDS / VS...

This sounds very much like the long-winded equivalent of restoring a...

Would you care to elaborate on how you have integrated a PoSh solution into an SSIS package or...

Have you double-checked that you are picking up the right version of sqlcmd.exe?

Which reference?

What do...

What do these workflows do?

If you are interacting with data sources and destinations, particularly SQL Server, SSIS offers built-in features which should help speed up development.

BrainDonor (8/24/2016)

---

Where I work they're considering upgrading from 2012 to 2016 for the enhanced JSON functionality.

Now I haven't looked at JSON within SQL Server - my fun with that has...

Correct suspicion.

This construction is probably causing issues:

final_salary = CASE when eng.placement_name IS NULL THEN '' else eng.final_salary end,

because '' is not numeric.

SELECT *

FROM @Cities c1

WHERE NOT EXISTS ( SELECT c2.CityName

...

SQL Guy 1 (8/23/2016)

---

We are in a process of migration from 2008R2 to 2014. We have a very complex query (it is a part of S.P.) that executes much...

If you tie the structure of your database to a VCS, this requirement should be unnecessary 🙂

I therefore assume that you do not have this in place (I suggest you...