You can still configure the Excel connection manager to skip the header, but you can't configure it to skip additional rows.

You can try to add a conditional split to remove...

At my previous project, I had BIDS 2005/08 installed and SSMS 2005/08 installed.

SSMS 2005 is still useful as you can only connect to Integration Services 2005 with SSMS 2005.

Agreed. For some reason most (business) people tend...

If you really want to keep your % sign, then you'll have to import it as strings.

Maybe you can use a small script task to create the folder and an empty file.

Then, copy the 3 files to the archive and just append the data.

Hugo Kornelis (10/26/2010)

---

Thanks for the question. I missed a point, but learned something new.

The reason I missed a point is because, when doing some research, I found this text:

"If you...

Nice question about an unknown subject.

Soulfly73 (10/25/2010)

---

Hi da-zero,

Thanks for your reply, the update will be on less than 1000 records per day, so performance (at night) isn't all of a issue. I have solved it...

Why? The query has obviously the purpose the return a scalar result, hence the Single Row resultset.

A variable of type Object is typically...

How are you looking at the variable?

After you have run the package, or while the package is running using a breakpoint?

To make it easy for your management:

SQL query to database: find the needle in the haystack

Cube: look at the whole haystack

If there is such an object (that can tell you how many rows are affected), I would like to hear about it. It would be very useful.

If you keep audit...

Another option is to use to data conversion component to convert the boolean values (which are by nature true or false) to integer. This should return your 0 or 1...

Institute. That explains a lot. 😉

(how come this thread is already 5 pages long and yet contains so little value?)

Alvin Ramard (10/22/2010)

---

What do you mean by: "extract the package"?

I can't help but wonder what the client...