trboyden (7/10/2015)

---

As a point of clarity in code purpose, re-usability, script length, and the "what the heck was this guy thinking" factor, I find commented out code to be a...

caojunhe24 (7/9/2015)

---

Hi all,

Now Im trying to schedule a ssis job run from 12th business day to 20th business day for every month.

(The package should run 12th-20th everyday).

Can anyone tell...

Last day of previous month is this, but not in the format you want.

(DT_WSTR, 40) dateadd("d",-1,Dateadd("m",DATEDIFF( "m", (DT_DBTIMESTAMP) "1900-01-01", getdate() ), (DT_DBTIMESTAMP) "1900-01-01"))

I'll leave it to you to...

First day of previous month:

right("0" + (DT_STR, 2, 1252) MONTH( dateadd("mm",-1,getdate())),2) + "/01/"+ (DT_STR, 4,1252) year(dateadd("mm",-1,getdate()))

endayagilbert (7/9/2015)

---

Hi,

Thank you.

What I want to achieve are:

a) get the first day date of the previous month based on current date

b) get the last day date of the previous month...

If you will take a step back and tell me

a) What you are trying to achieve and

b) What format you want the result in

I might be able to help you...

This converts a datetime to a string.

(DT_WSTR, 30) GETDATE()

You can execute SSIS packages from SQL scripts (see here for more info).

So you can script the execution fairly easily.

Not always. Depends on the requirement.

It can be found under Project Properties...

According to the documentation (here), the INSERT INTO ... FROM construction does not appear to be valid.

I don't know much about Redshift syntax, but wouldn't it be

insert into table(col1, col2)

...

ie, with the columns in brackets?

karthik82.vk (7/7/2015)

---

Hi,

I have a data that with month values ranging from jan 2012 till july 2013 with some values associated with it.

I want to generate months automatically after july 2013...

Orlando Colamatteo (7/6/2015)

---

Make sure the called app isn't asking for user input, e.g. a login name or license required.

If you run the app from a cmd shell directly under...

spaghettidba (7/6/2015)

---

djj (7/6/2015)

---

Worked at a place that if you came in early that was okay but not seen as overtime. (not that you got payed for it but they...

So do a GROUP BY first and then break the results into groups. After that, 'explode' the results back into multiple rows if needed.