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

fanindrabhortakke (8/23/2016)

---

Hi,

I have one sql job scheduled every 10 min to run. It mainly does some calculation and then dumps results into one table. It sometimes takes 6-7 minites maximum...

Drew is correct. But here is an outline of what I think you are trying to do:

insert tableC (c1, c2, c3)

select c1, c2, c3 from tableB b

where exists (select 1...

Cool, no problem.