Sum (isnull (cola,0)) + ...

Should do it.

Lowell (7/13/2015)

---

i've done this with a script task, but i assume the file always has a header row for the column names, and that i know the delimiters, ie, comma/CrLf,...

Abhijit More (7/13/2015)

---

Describe what you mean by 'flat structure'.

Flat Table with all headers from files, if no header it should come with Column0, Column1, Column2...& so on.

Are the files all...

Ross.M (7/13/2015)

---

Thanks for the interesting post.

Genuine question to someone who uses this method frequently (without trying to sound argumentative):

Do you find this more useful than just highlighting the block and...

Abhijit More (7/13/2015)

---

I have challenge where I received data from multiple sources in different formats such as excel, csv, flat file.

Now the challenge is I have to load any received...

trboyden (7/10/2015)

---

Phil Parkin (7/10/2015)

I agree with you for production code. The general thrust of the thread, however, is around the creation of utility or setup scripts which are run and...

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