Viewing 15 posts - 1 through 15 (of 22 total)
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...
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 24, 2010 at 2:27 am
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)...
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 24, 2010 at 12:23 am
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...
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 23, 2010 at 5:18 am
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.
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 23, 2010 at 3:48 am
How about "Top 10 ad revenue generator regions", you know, thas what pays for his company 😎
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 23, 2010 at 3:39 am
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...
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 23, 2010 at 3:36 am
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,...
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 23, 2010 at 3:30 am
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)
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 23, 2010 at 12:15 am
The remote executable should be specified as a local path on the remote server
Really important point to remember. Once a colleague of mine scheduled SSIS packages on SS Agent and...
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 22, 2010 at 2:20 am
I will suggest the same solution as Alvin. PsExec utilities are really handy for performing remote actions.
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 22, 2010 at 12:52 am
da-zero (9/21/2010)
.........as stated already in this thread.
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...
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 21, 2010 at 6:31 am
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?...
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 21, 2010 at 1:29 am
How about a left join? It will give you all matching values.
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
September 21, 2010 at 1:02 am
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...
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
August 23, 2010 at 2:00 am
This article on MSDN might help you in what you need:
http://technet.microsoft.com/en-us/library/ms141053%28v=SQL.90%29.aspx
_____________________________________________________________
[font="Tahoma"]'Some people still are alive simply because it is illegal to shoot them... o_O 😎 '[/font]
August 23, 2010 at 1:52 am
Viewing 15 posts - 1 through 15 (of 22 total)