As HappyCat said: add IMEX=1 to your connection string. IMEX stands for intermixed data types. In other words, if Excel notices that a column contains more than one data type,...

Nice question, thanks.

(but it surprises me that apparently 78% -for the moment- know the exact error message!)

Where is that SQL Task with the update located? Between the two dataflows?

If yes, then your situation is normal 🙂

You can keep everything in one dataflow, but then you must...

Good question, but an even better follow-up discussion.

Thanks for the code examples!

I like the point the question tries to make (which is a very important one), but the explanation is lacking. Some links would have been nice and an explanation of...

Thanks for the answer. The problem is that set-up fails directly after the set-up rules, so I haven't seen a UI yet where I can choose settings.

I've searched the logs...

WilliamD- (12/7/2010)

---

Slightly misleading wording. It should read "how many columns can be used in a nonclustered index key". The important part is to make clear that you are...

Nice and easy. Thanks!

Paul_Blackwell (12/6/2010)

---

Abhas,

You can use the Execute Process Task and File System Task to perform your operations. Create the necessary variables so that you can configure your package and applying...

That is like trying...

See my answer here:

http://www.sqlservercentral.com/Forums/Topic1030738-364-1.aspx

I have never done it before, but I'm pretty sure you can unzip files with a script task. There will already exist some .NET code on how to do this...

As other have already pointed out, you really need a question if you want an answer to your problem.

Please read the following blog post:

Need an Answer?

No. It just copies columns.

What is the error that you get?

Are you sure that all strings can be converted to a numeric format?

Normally you could use the Conversion component or the Derived Column Transformation.