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

Excellent, thanks for posting back.

Without sample DDL or test data, I've had to 'make something up'. This may or may not work as a result 🙂

select *

from employee e1

where ...

OK....

GilaMonster (3/16/2015)

---

The worst comment I've ever seen (as opposed to one I wrote) was in MS Access. The previous developer had written a lot of profanity-filled comments. Anyone who's worked...

Hi Dave, did this happen? If so,...

Michael.Ramirez (3/13/2015)

---

The only thing wrong w/ bad comments is no comments at all.

On a number of occasions I have found that various co-workers will add a comment that...