Sorry for being impatient 🙂

So you are actually on right track. Use my statement in Dataset2 (for drop down list)

But to make it work, you need few little modifications:

1. Are...

Teradata and IBM has Data Warehouse models for very large businesses. I have worked on one of them for a brief time. Teradata's FS-LDM (Financial Services - Logical Data Model)...

Look at my example. I did not add null value to the table, but just to the dataset of drop-down list. Use the same query and you can use existing...

One more thing. If people are specific about look and feel of reports, and you already have MS Sharepoint in your org, look no further. PPS is enough.

How about "Top 10 ad revenue generator regions", you know, thas what pays for his company 😎

Assuming you are using SQL Query (and not MDX), you can add a NULL value in your Data. No need to use built in "Allow NULL value" option.

e.g.

select CustomerName...

I will keep it short. Last project proposal I wrote was for a client who just wanted any alternative to QlikView. Few reasons they gave were VERY high hardware requirement,...

Ref:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=18281

You can use REPLACE(<<String>>,char(9),'') and then trim it again just in case 😀

Edit: CHAR control characters

Tab: char(9)

Line feed: char(10)

Carriage return: char(13)

Really important point to remember. Once a colleague of mine scheduled SSIS packages on SS Agent and...

I will suggest the same solution as Alvin. PsExec utilities are really handy for performing remote actions.

Why so formal??? :-P:-D

@ns.sharath

See I told you so 😉 , do a left join anywhere (T-SQL, SSIS). That is the bset way...

I prefer SP's over Exec SQL Task most of the times. And if its a looping work, SP's are aways better. And we (nearly always) make a deployment plans right?...

How about a left join? It will give you all matching values.

You can try following:

1. Use fast load option on OLE DB destination, experiment with batchsize option and find your optimum number.

2. Drop the indexes on target table and recreate them...

This article on MSDN might help you in what you need:

http://technet.microsoft.com/en-us/library/ms141053%28v=SQL.90%29.aspx