brad.mccollum (4/3/2014)

---

None at all of the examples I am finding actually work once I implement and modify the code for my particular situation. It only seems to loop through the...

Have a look here.

We don't use SSISDB in dev, just everything after dev.

Without actually looking at the bothersome data, I'm running out of ideas on this one. It sounds like you should be able to narrow down roughly where the problem lies...

Eric Mamet (4/2/2014)

---

Phil,

In previous versions, I found...

lmnorms (4/3/2014)

---

Thank you. Adding in:

Select '<?xml version="1.0"?>' + Cast((

[Original Select

]

) AS VARCHAR(MAX)) as XMLData

Worked nicely....

You mention SS2012 in your post, yet this is a 2005 forum, which is a bit confusing.

If you could post some source data in readily consumable format (see the link...

Koen Verbeeck (3/31/2014)

---

Phil Parkin (3/31/2014)

---

Apologies - I should...

Apologies - I should have mentioned that this...

Koen Verbeeck (3/31/2014)

---

happycat59 (3/30/2014)

---

Environment variables are actually stored in the registry. So, exporting them using something like "regedt32" will give you a ".reg" file that you can save into...

No.

Please do some research and at least try to make it work for yourself, then post back with...

If you are writing the value to a table somewhere, you can issue an ExecuteSQL query immediately after the data flow to retrieve it and assign it to an SSIS...

I agree - if you remove these, you are changing people's names.

dan-572483 (3/25/2014)

---

The Excel file contains data going back several years and I'm only looking for data entered in the past few weeks. (Honestly it is a personal...

Why are they being taken off-line?

dan-572483 (3/21/2014)

---

Good point. As I read more I see that CDC can also be configured to track and capture multiple changed to the same rows between SSIS job runs....