GilaMonster (8/25/2016)

---

Grant Fritchey (8/25/2016)

---

GilaMonster (8/25/2016)

---

If you were to attend a keynote presentation on "New features of SQL 2016", would you prefer brief demos of each new feature? Just discussion, along...

kevin_nikolai (8/25/2016)

---

Hi Phil, I used the section:

Data Warehousing »

Integration Services »

How to prevent disabled Sites in CRM from showing in SSAS and SSRS

So I was looking...

JALLYKAMOZE (8/25/2016)

---

J Livingston SQL (8/25/2016)

---

I asked a similar question on one of your earlier posts.....

for example

"ProgramFirstday" = 1

"ContractDetailFirstDay" = 7

how do you determine whether this is 6 day delay...

Luis Cazares (8/25/2016)

---

Are you serious? I think they're perfect. They're great to identify cheaters from people that actually know what they're talking about.

I couldn't get past the 3rd question, it's...

When you are entering SQL code in a post, please surround it with code="sql" IFCodes to improve its display.

A very ordinary moon currently, it would seem 🙂

What have you tried so far?

What problems did you encounter?

komal145 (8/25/2016)

---

Please see the pacakge hierachy. Let me know if i can cahnge anything with copying? As the move file should be locked but copying of file should work fine....

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?