That's nothing. You should see me with a hangover:-)

Is this related to SSIS?

Yes - you can assign the result of an execute SQL task such as

SELECT COUNT(ID) FROM TABLE

directly to a variable.

Between source and destination.

Nice solution Jeff.

That's not as easy as you've made it sound - unless you know a method I haven't thought...

--Oops, please ignore!

John Rowan (11/6/2009)

---

Good to hear that you're up and running Tim. I agree, it's simple when you know how, but I'm not sure I'd call using a script task...

I already thought that SSIS was tough enough in English, but this takes it to another level 😀

Looks like a problem on the AS/400 side - can you give more...

I have a couple of Excel suggestions for you:

1) When entering numeric data that you want to to be treated as text, enter a single quote as your 1st character....

Can you post the exact syntax of your expression field - sounds like it may need a tweak.

You have made a statement without asking a question, leaving us to guess.

Are you saying that the problem does not happen unless you are in debug mode, or is it...

Formatting as text does not affect how Excel holds data.

Specifically, if you format a number as text in Excel and then import it, it will still come in as a...

Beat ya! 🙂

Create a derived column & set it to the value of your variable before firing through data conv ...