Unfortunately, the author is not available in my outlook.

But even I was thinking why to put additional code and ask SQL engine to decode the same which looks like overhead...

Thanks Johan.

However just wondering why someone writes code like that "1 = " instead of simple AND / OR conditions.

Is there any benefit in writing such form?

Brandie Tarvin (2/25/2016)

---

What logic determines IN verses OUT?

Hard coding based on the dates given is not wise. Ideally, code should be written to logically decide what fits either circumstance depending...

Thanks for sharing nice question 🙂

Thanks Hugo for sharing all history.

John Mitchell-245523 (7/3/2015)

---

Probably because you haven't specified the config file. Check out the documentation for dtexec - it'll show you what switch to use to point it to your...

For incremental load, I guess you should use encryption techniques to find out actual updated records.

In case loading the updated records in temp table.

Also please let us know your package...

Will loading the id values in a temp table and making join with source to avoid For each loop container help me in it ?

Are you able to execute package from BIDS ?

If you are able to execute in BIDS, it would be permission issue for user to the path where your package is...

Any help ?

Eirikur Eiriksson (4/6/2015)

---

rhythmk (4/6/2015)

---

Hi All,

I am getting strange error mentioned below while executing my package.

Error: ForEach Variable Mapping number 0 to variable "??" cannot be applied

I am using SSIS 2012.

I...

Something like below.

SELECT ClientKey,VendorKey,

(SELECT eno,ResumeText,Email,Active,postalcode,country

FROM Candidates

FOR XML Path('Candidate'), TYPE, ROOT('Candidates'))

FROM CareerBuilderdatafeed

FOR XML RAW('CareerBuilderdatafeed')

Hi Ashok,

Why don't you have below approach.

1.A separate connection config which will have all the connections and would be common to all packages.Please make sure that connection variables name would...

How will you achieve it ?

Think of the scenario where OP wants to do this exercise for...