Brian has nailed this, however there is one extra consideration which may help avoid hair-pulling-out if (a) you do decide to use a Conditional Split Task and (b) you are...

Hey, KT,

No worries - sounds like you solved this in a way which is far superior to a technical solution - change the requirements! 

Matt

Hi,

The Excel connection is a bit lumpy - it uses the Jet db engine which is not the most modern & seems to get upset by the slightest thing.

I have solved...

I found this potentially very useful and so implemented it happily... however, a warning; when designing/debugging I couldn't get it to fire the event if I just executed the individual...

Try View - Output on the VS menu.  The Output window gives you detailed error info, not treeviewed, so errors tend to be near the bottom of the list.

When in design mode, choose "View Output" - this will give you an output window.  When execution is done, this will contain all your execution info (it is actually easier...

Is this a similare issue to this question on the forum...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=148&messageid=304480

...?  Hard to say without any detail of the error, but if it is, that thread might help.

Have also been having fun importing (165 column) workbook (date columns!  aargh!).

Anyways, to your problem: much simplified once you have the following:

1. The use of the Conditional "?" i.e. IF......

There's a discussion on this here: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=285015&SiteID=17

...which indicates it's a bug.

It also suggests that it would be fixed in SP1... have you got that installed?

With you there.  There's more to GO than meets the eye, and it doesn't even have to be "GO" either!

Thort it might be fun to share this early tale of...

Thanks!  Those are good links.

I am hoping for some comments from anyone with practical experience of using remote partitions e.g. "It's great" or "It's a nightmare"!  I think we all know...

One last point, maybe... if you create the report using the wizard you can't get past the "Cannot find temp table" bit. If you create the report without the...

Hi Barab,

We had some problems with running RS on the same physical box as the database providing the data for the report. It seems that (a) there were issues...