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.

The question on itself is OK, but why a question about a deprecated SQL Server 2000 system table? (as BOL clearly states here)

I would have prefered the same question but...

payalvyas11 (11/30/2010)

---

I too answered incorrectly after reading the documentation of msdn. The statment "any object that can appear in a FROM clause, except synonym objects", made me assume that user...