Spiff (9/29/2016)

---

MMartin1 (9/29/2016)

---

In the SSIS expression builder , enter:

(DT_DATE)((DT_WSTR, 4) year(getdate())+"-"+ REPLICATE( "0", 2-LEN((DT_WSTR, 2)(month(getdate())+1) )) + (DT_WSTR, 2)( month(getdate())+1) +"-01")

EDIT : This will give you...

xr280xr (9/29/2016)

---

drew.allen (9/26/2016)

---

Luis Cazares (9/26/2016)

---

drew.allen (9/26/2016)

---

xr280xr (9/26/2016)

---

I don't specifically care about short circuiting. I just need to only evaluate b if a is false and only evaluate c if a...

In the SSIS expression builder , enter:

(DT_DATE)((DT_WSTR, 4) year(getdate())+"-"+ REPLICATE( "0", 2-LEN((DT_WSTR, 2)(month(getdate())+1) )) + (DT_WSTR, 2)( month(getdate())+1) +"-01")

EDIT : This will give you the first...

If you absolutely are identifying a row here base on the values of emp1, emp2 and emp3, then you can create a calculated field that persists in the table. This...

Another option you can try is the fixed width delimiter in SSIS. THere is no guarantee here though as it totally depends on the way your data is laid out.

You are in a tight spot here. You have text files with commas as the field separators and some of those fields are strings with commas within them. You cant...

RonKyle (9/28/2016)

---

I have trouble imaging this, and certainly...

So you would not use SSIS to pull into Access? I think the user wants...

If you are able to access the folder and file then you may want to study creating a proxy account for the SQL SERVER Agent account. This allows the agent...

I am not totally certain but you may want to install the appropriate version of the provider (32 bit, 64 bit) on both the machine where Office is installed and...

If DAX in any way resembles MDX then I would say yes it is hard. Like any language, if you dont use it you begin to lose this. This holds...

In a Where clause you may have a situation as

WHERE (a>20) OR

...

Just out of curiosity, what was your language setting?

If you want to preserve a static definition of territory over time, I am guessing this is by your definition and not the clients. I think of having a extra...

Kazmerelda (9/26/2016)

---

Sorry foe the delay, I was out last Monday on holiday so couldn't test it properly.

So I went in to test this morning all hopeful....and sadly I am getting...