Change the properties of your lookup component so that its lookup is not cached.

It will hit performance hard, but it should do what you want.

OK, the desire to find out how to do this has been only tepid, so I'm not going to spend hours writing things out in great detail. Let's consider one...

Thank you for the informative response.

mckyn (11/20/2014)

---

Thanks for the responses.

Phil - I also did manually run the job from server itself using SSMS and it went fine. Will check again tonight.

Koen - Appreciate the tips...

mckyn (11/20/2014)

---

Hi,

On running the parent package in nightly schedule job gives an 'Invalid access to memory location' error but running from MS VS works fine without error. Log file giving...

Which edition of SQL Server 2012 do you have installed?

How are you trying to execute the package?

monilps (11/18/2014)

---

Hi,

Can anyone please help me how to write query with PRINT Statement for below query.

WITH CTE1 AS (SELECT * FROM table1),

CTE2...

scuby.me (11/18/2014)

---

Hi,

I have two tables in SQL server database. i want to compare both tables and differentiate like if the rows match then go to matched output otherwise to no...

kriskumark96 (11/17/2014)

---

Hi,

The three queries is of the same tables with different where condition are used , so that we cannot have a join or cross join on it

Or

Is there any...

kriskumark96 (11/17/2014)

---

Hi,

Thanks for the Reply, Union All Condition combines the Values , but i need a query

like

select col1,col5,col8 from queries 1 ,2 ,3.

i need to take each column...

Try configuring the SQL Agent job to run the package in 32-bit mode in the Configuration / Advanced section of the Job Step properties.

It does involve data migration and the databases power our websites, so we need to...

Jeff Moden (11/15/2014)

---

That sounds like a lot of work. My question would be WHY? ...

Can you provide a link or some background to your question please? I don't know what you are referring to.