Lun

in fuzzy lookup transformation 2005, significance of _similarity_reference number? the fuzzy lookup working on outputs equal values _similarity , _similarity_reference number. john schroeder hi john, there no third additional column. third 1 mentioned similarity output alias. example, if create relationship x1-> referencecolumn1, third column should _similarity_x1. , if add relationship x2-> referencecolumn2, see 4^th column named _similarity_x2. meaning of column similarity of input column.   hope helps, raymond SQL Server  >  SQL Server Integration Services

hi experts, could please scenario. input: id | name ---|------- abc|india abc|america abc|china bcd|brazil bcd|japan output: grpkey|id | name -----|---|--- 1 |abc|india 1 |abc|america 1 |abc|china 2 |bcd|brazil 2 |bcd|japan i want generate group keys above. please help mus declare @temp table (id varchar(100),name varchar(100)) insert @temp(id,name) select 'abc','india' union select 'abc','america' union select 'abc','china' union select 'bcd','brazil' union select 'bcd','japan' select dense_rank() on (order id) 'grpkey',id,name @temp ramesh rathod SQL Server  >  SQL Server Integration Services ...

i upgraded sql2000 cube 2005 , using pc6.1.156.600 view results.  fine, dimensions (like account or client) don't display in hiercarchies window hierarchies below them - hierarchies display. in sql2000, had dimensions called account.all , account.exp_fixed_var.  in 2005, account-all (with hierarchy account all) , account-fix_var (hierarchy fix_var).  in pc using sql2000, hierarchies showed under grouping/dimension called account.  against sql2005, show individually no grouping. any ideas? dwight in 2000, there weren't reallly multiple hierarchies in single dimension; so 2-part dimension naming convention (like account.all) used indicate 2 dimensions same first part (like account) should treated hierarchies of same dimension. convention not needed for 2005 because multiple hierarchies can occur in same dimension. so, conform 2005 model, can create multiple hierarchies in single account dimension of your as 2005 cube, rather separate dimensions per hierarchy? - deepak ...

we have sql server 2008 r2 running on our windows 2008 r2 server publisher , distributor.  have sql server 2008 r2 express (windows 7) running on our desktops/laptops pull subscriptions running. have 6 subscriptions configured/running , 1 of getting error below.  using default distribution manager profile , not designating oledb streaming.  windows sync center on laptop/desktop being used sync subscriptions.  subscriptions can reinitialized pull of updates results in error.  here tsql used build subscription: use [dmlr] go exec sp_addpullsubscription @publisher = n'wsq00796', @publisher_db = n'dmlr', @publication = n'dmlrenf', @independent_agent = n'true', @subscription_type = n'anonymous', @description = n'transactional publication of dmlr database publisher wsq00796.', @update_mode = n'read only', @immediate_sync = 1 exec sp_addpullsubscription_agent @publisher = n'wsq00796', @publisher_db = n'dmlr...

hi, i'm trying response stream php script via webclient : webclient.openreadcompleted += new openreadcompletedeventhandler (webclient_openreadcompleted);   webclient.openreadasync( new uri ( script.tostring() + "?directory=" + directory, urikind .relative )); where script "php/getlisting.   now openreadcompletedeventargs.error shows me following :  webpage error details user agent: mozilla/4.0 (compatible; msie 8.0; windows nt 6.1; wow64; trident/4.0; slcc2; .net clr 2.0.50727; .net clr 3.5.30729; .net clr 3.0.30729; media center pc 6.0; infopath.2; officeliveconnector.1.4; officelivepatch.1.3) timestamp: tue, 20 oct 2009 16:07:17 utc message: unhandled error in silverlight application system.net.webexception: [httpwebrequest_webexception_remoteserver] arguments:notfound debugging resource strings unavailable. key , arguments provide sufficient information diagnose problem. see http://go.microsoft.com/fw...

i looking best method transfer sql data multiple db servers' site central db on internet one time or on-going? andy tauber data architect vancouver clinic website | linkedin posting provided "as is" no warranties, , confers no rights. please remember click "mark answer" and "vote helpful" on posts you. can beneficial other community members reading thread. SQL Server  >  SQL Server XML

  i working data stream date column either comes in date or comes in word na. want change na values nulls. how do this? you'll need use conditional expression operator http://msdn2.microsoft.com/en-us/library/ms141680.aspx  and null expression operator whatever data type you're using.   you'll end looks this:   code snippet code snippet [col] != "na" ? [string-col] : (dt_wstr, 255)null(dt_wstr, 255)         you may want take here: http://blogs.conchango.com/jamiethomson/archive/2006/10/12/ssis_3a00_-nulls-in-expressions-gotcha.aspx SQL Server  >  SQL Server Integration Services