Well, I find it weird that the requirement actually includes doing it in a script task because normally requirements don't care how you get it done as long as the...

I don't know dude... I just created your same structure and it worked just fine for me. I used your code, your var names, everything. And it works...

Let me run it through some more gray matter to see what I can come up with, but I doubt you'll find too much love there. I'll get back...

Yeah, you're actually making this harder than it really is. There's no need to build this statement the way you are:

"update wptable set ErrorRecodCount = " + (DT_WSTR,12)@[User::varNameBadRC]...

Look at this topic, this is what you want:

http://www.sqlservercentral.com/Forums/Topic522708-148-1.aspx

While logging can add a little time to your package, I doubt it's what's dragging down your package that much. I would look at how my package is constructed...

It seems like it ought to be possible, though I've never done it.

I would look at the Recordset destination if I were you. It takes a var (object data...

Yeah, that's not how that works. You can't just move cols around in a physical flat file. If you want to move them, you have to create a...

It seems that the fastest way to get this done would be to put it into a table first and then select the rows you want out of that table....

Well, for starters, I'm not sure why you're working with strings to begin with. You're doing a count(*) and converting it to varchar and I'm not sure why. ...

You asked me to elaborate so I made you another video. Hope this helps.

http://midnightdba.itbookworm.com/ssisforcepackagefailure/ssisforcepackagefailure.html

Try my videos below. They're all free.

W/O knowing too much about what your package looks like, it looks to me like you're pushing some kind of int data type. Try casting them as decimal or...

Yeah, I would do it in a script task.

I have a snippet here for accessing file properties so you should be able to make it to what you want.

...

y, I really don't think so.