I just noticed another thing ...

If you do a LEFT JOIN from table A to table B, you are telling SQL to return all rows which match, plus all rows...

Perhaps. If you frequently need to filter based on year.

Alternatively, if there is already a suitable index on the datetime column, change your filter from

Year(col) = 2013

to

col >= '20130101'...

I see no way (or reason) to introduce windowing functions here.

I suspect that you would see a large performance improvement if you were to add a QuotaDateYear column to your...

I've read your posts and I don't understand 100% what...

Here you go

where (

dbo.ocsTimeHeader.tshStatus = 'ACTIVE'

or dbo.ocsTimeHeader.tshStatus = 'IDLE'

...

Steve Jones - SSC Editor (3/18/2015)

---

You can use datepart to extract the month, and day, and then concatenate them together.

cast( datepart(mm, mydatecolumn) as char(2)) + '/' + cast( datepart(dd, mydatecolumn)...

aarionsql (3/18/2015)

---

Hi Phil,

I am building a SCD 2 package and there is date field for current records and expired records where I have traditionally used a GETDATE() funtion to populate...

aarionsql (3/18/2015)

---

Hi All,

If any one has any ideas on converting GETDATE() to a DATETIMEOFFSET(0) within the Data Flow.

I am getting truncation / conversion errors when I am trying to convert...

goaziz 51438 (3/17/2015)

---

Thank you in advance. I have defined two parameters. Just a simple SELECT. It works fine if I execute the task but it does not work when I...

Then you should read Dwain's article!

raj.prabhu001 (3/17/2015)

---

lols.................

ok so i have process where we need to download daily 1000 pdf file from website

and store them for refrence we currently do it manually.

but i think creating package...

..maybe gaps are ok. Otherwise, it's unclear why you would ever need to...

--Removed

Perhaps there is an alternative.

There is a system variable in SSIS called the ExecutionInstanceGUID.

This is a GUID generated every time a package runs – it uniquely identifies a single run...

raj.prabhu001 (3/16/2015)

---

1.excel file will have one column which will contain links of pdf file to be downloaded

2. i want to run a package that will go through individual links one...