I myself advocate for the lowest possible granularity unless you know for sure you wont need the details. For example, can one of those transactions be reversed at a later...

I am curious about this requirement. Would you mind sharing why?

Another way to approach this is if you have a rowID column in your table , you can derive one into a temp table from the base table if you...

Hmm, I would rather do this in the SQL code ...

I scrapped up the following >>

with cte as

(

selectcast('20140701' as date) as cteDate

Union all

selectdateadd(d, 1,c.cteDate)

fromcte as c

wherec.cteDate <'20140731'

)

,nextCte as

(

select top...

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