I think the priority needs to be on separating testing and development from production, and you can worry about mxiing ETL into production at a later date. ...

Umm.... how about the double back-slashes ("\\") ? Shouldn't those be single back-slashes ("\") ?

Finding out the file size isn't difficult, but the real question is why the size matters. What do you intend to do differently if the size is 512KB...

Hey, "Round Hole" ... My name is "Square Peg" ... care to JOIN ???

Yeah, that's SELECT, ain't it ??

Last time I heard that I fell off my dinosaur...

I can certainly re-engineer this, but I was hoping for some clear indication as to exactly what this error really means before I go off and do something different that...

There may be an easier way. If the data source allows an SQL Query, and supports the ISNULL function, then your SELECT statement could look something like this:

SELECT...

How about using a derived column to cast the strings to code page 1252 ? I suspect a code page problem of some kind.

I don't know enough about SSIS to know about the Pre and Post methods, and I'm at a loss as to the scoop with the post one not running, but...

Yet another question that deserves to be removed along with all associated points (or lack thereof), as this is clearly dependent on not only WHEN you answer the question, but...

Sorry folks, but the correct answer is NOT among the choices. This question and all points associated should be removed from the system, and it's about time these...

I'm not aware of any solution other than that originally offered for this chain of posts.... In your case, use PowerShell to run a VBScript with ADO code...

The closest thing I can think of is a package variable with a scope that allows access across an entire package, and to refer to such as a global variable...

dwain.c (12/18/2012)

---

sgmunson (12/18/2012)

---

Honestly Dwain, I'd love to see you find a solution here, but I'm afraid I'll have to see it to believe it. My primary reason for holding...

dwain.c (12/18/2012)

---

SG,

BTW. In case you haven't, you should probably read this article by Jeff Moden: Solving the Running Total and Ordinal Rank Problems[/url]. Look for the section on...

dwain.c (12/18/2012)

---

sgmunson (12/18/2012)

---

Dwain,

A "Quirky Update" isn't going to work here, as the problem isn't just a matter of retrieving a value from a previous record. It's a matter...