Viewing 15 posts - 8,281 through 8,295 (of 13,876 total)
trboyden (7/10/2015)
July 10, 2015 at 6:04 am
caojunhe24 (7/9/2015)
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...
July 9, 2015 at 9:28 am
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...
July 9, 2015 at 5:51 am
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()))
July 9, 2015 at 5:35 am
endayagilbert (7/9/2015)
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...
July 9, 2015 at 5:20 am
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...
July 9, 2015 at 5:11 am
This converts a datetime to a string.
(DT_WSTR, 30) GETDATE()
July 9, 2015 at 4:25 am
You can execute SSIS packages from SQL scripts (see here for more info).
So you can script the execution fairly easily.
July 9, 2015 at 12:31 am
In SQL Server 2008 you had to Set the SSIS Run 64 bit property False or it would fail.
Not always. Depends on the requirement.
It can be found under Project Properties...
July 8, 2015 at 11:10 am
According to the documentation (here), the INSERT INTO ... FROM construction does not appear to be valid.
July 7, 2015 at 5:08 am
I don't know much about Redshift syntax, but wouldn't it be
insert into table(col1, col2)
...
ie, with the columns in brackets?
July 7, 2015 at 4:45 am
karthik82.vk (7/7/2015)
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...
July 7, 2015 at 4:09 am
Orlando Colamatteo (7/6/2015)
If you run the app from a cmd shell directly under...
July 6, 2015 at 1:03 pm
spaghettidba (7/6/2015)
djj (7/6/2015)
July 6, 2015 at 6:53 am
So do a GROUP BY first and then break the results into groups. After that, 'explode' the results back into multiple rows if needed.
July 6, 2015 at 12:55 am
Viewing 15 posts - 8,281 through 8,295 (of 13,876 total)