Well, as I mentioned, it gets messy...

The problem here is that you have to consider this a multi step process.

1) You have to get the letter by itself.

2) You have...

rkota2008 (7/16/2014)

---

Hi,

'1047383658000012345678990000002014083J354310020140850000005335R0000'

In this string '0000005335R' is the amount with 2 decimals 000000533.5R

We need to decode A = 1, B= 2 till I = 9 and J = 1 with...

Apologies, I forget not everyone has beaten their heads on authentication before. Oops.

I have no idea what cURL is or any of that, unfortunately. I couldn't tell you what's...

The exit code comes from something in the .bat file, not SSIS. My guess is you've got a double-hop of some kind going on, messing with the rights to...

Sean Lange (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

patrickmcginnis59 10839 (7/16/2014)

---

Jack Corbett (7/16/2014)

---

Eirikur Eiriksson (7/16/2014)

---

No implied either, my respect on handling the situation! So far, JC is the only one that has...

When he did his test, did he use the same source data? When he did, did he remove the new data (or changes) from the target table? I...

Lynn Pettis (7/16/2014)

---

Anybody? Can anybody please step in again and try helping me with WC? Frustrated, can't seem to get him to realize I just don't know what...

I'm a proponent of the centralized SSIS server, but mostly because of organization and not having to worry about if you found all the pull subscribers out there. If...

below86 (7/15/2014)

---

The concern I'm hearing is the overall size of the transactional log. And that doing the 'Insert' into these tables using the SSIS dataflow does not add to...

Only because I forgot to calibrate the tranquilizer gun for more windage due to the slower dart at range...

... welcome back. 😉

is250sp (7/10/2014)

---

I already have CONVERT( VARCHAR(10), column, 101) in my SQL command in my OLE DB Source. Also in my Flat File Connection Manager, the Properties for that column...

Tammy-274861 (7/10/2014)

---

The member 88888ANTHONY doesn't meet the requirements, because even though he is enrolled for 2013, he has a bigger than 45 days gap between 2013-05-31 00:00:00.000 and 2013-10-01 00:00:00.000.

That...

autoexcrement (7/10/2014)

---

I swear I remember reading somewhere about an alternate, shorter JOIN syntax in cases where the column being joined has the same name in both tables. But I can't...

ChrisM@Work (7/10/2014)

---

Koen Verbeeck (7/10/2014)

---

Jack Corbett (7/10/2014)

---

Koen Verbeeck (7/10/2014)

---

So I tried to endorse Jeff on LinkedIn for BCP, but somehow it doesn't work.

I saw Jeff was endorsed 9 times...

Track the metadata in the flow and determine where you switch from DBDate to String (or if you even do).

If you don't, and it's DBDate from beginning to end, the...