Are you sure that there are no other more-detailed error messages?

Do you know which step is failing? What is it trying to do?

Is there any chance that you could get the spreadsheet exported to .CSV format as step one of the process? Then you should find that the limitations are removed.

Check your 'State - 1' bit - you are performing arithmetic rather than subtracting one from the length. You need to rejig your brackets and all should be well.

captcooldaddy (2/22/2012)

---

the above is a quick and dirty solution w/ pseudo code because you're not really providing the proper preface to give a detailed solution however it should suffice. Pretty...

Thanks Jeff, I appreciate the genuine tone of your message. And I sympathise with the sleep deprivation - sense of humour is often one of the first casualties. I'm also...

Phil... go easy on us non-pro English abusers... we do this to help, not to get "A"s in grammer. I know many ESL's that absolutely trash the English language and...

I must apologise - I was being hard on you because I thought you were a native English speaker. But I reread your posts and I don't think you are,...

Hmmm, 'corrected' version:

I suggest you quit digging :w00t:

My answer to this question is: "Huh?"

Please reread Koen's response.

Have you tried with a SQL OLEDB connection?

subhaannai (2/17/2012)

---

im using script component in my data Flow.

For Example :

If my data soruce returns 10,000 records,

inside my script component im creating a...

subhaannai (2/17/2012)

---

Hi,

Thanks for your reply.Actually Inside my Script component ,i am creating a file and writing some data's into the file and in the mean time i have to update...

The...

This is not quite correct. Eugene...