Lun

in order try sharepoint list source , destination sample created ssis 2008 in ssis 2005, i have downloaded related code codeplex , i'm trying reverting code inside vsto 2008. but have error when in sharepointlistsource.cs used mappedcolumnid property of microsoft.sqlserver.dts.pipeline. wrapper. idtsexternalmetadatacolumn100: doesn't exist in microsoft.sqlserver.dts.pipeline.wrapper . idtsexternalmetadatacolumn90. i have tried comment statement in error, compiled project , imported corresponding objects in ssis 2005 have had warning "the component has inconsistent metadata". how can revert use of mappedcolumnid ssis 2005? how can solve issue? thanks. the mappedcolumnid property added in  microsoft.sqlserver.dts.pipeline. wrapper. idtsexternalmetadatacolumn100. it not available in microsoft.sqlserver.dts.pipeline.wrapper . idtsexternalmetadatacolumn90.   one of requirements stated sample in codeplex ( http://www.codeplex.com/sqlsrvintegrationsrv

ok, have been reading on project real ssis package config schema , have been trying implement it. have few questions remaining confusing me. far have done following things: created env. variable holding location of sql server configuration info. created .dtsconfig file holding connection string sql server configuration table. created package with: xml config variable set in package configuration, ole db connection corresponding .dtsconfig file, , sql server configuration in package configuration. here things tricky, when went setup package configuration sql server didn't want read info ole db connection xml file until closed , reopened project. did , inserted rows of connection information wanted ssis configuration table. set sql server config use filter used in rows. however, not want export information table, want package read connection information table. my questions are: when add ole db connection correct naming convention package , dummy information, how keep connection expor

hi, i'm creating a ssrs 2008 r2, nested drill-downs. when export report in excel format , explode drill-downs can see row sub totals. normal behaviour, isn't it? in publishing environment can see these subtotals when drill-downs compressed. thanks it depends on how have configured row visibility, can shown when drilldown collapsed or expanded. you should select row, right click , choose > row visibility > choose the default visibility (set hidden???) , choose textbox should toggle visibility. SQL Server  >  SQL Server Reporting Services, Power View

hi - i want add not null column existing table, table looks this:   create table [data].[factdata](  [timeid] [smallint] not null,  [dateid] [int] not null,  [actualtimestamp] [datetime] not null,  [objectid] [int] not null,  [datavalue] [float] null,  [headerid] [int] not null,  [threshold] [float] null,  [daylightoffset] [tinyint] not null,  [missingdata] [tinyint] not null,  constraint [pk_factdata] primary key clustered (  [headerid] asc,  [objectid] asc,  [dateid] asc,  [timeid] asc )with (pad_index  = off, statistics_norecompute  = off, ignore_dup_key = off, allow_row_locks  = on, allow_page_locks  = on) on [factdataps]([dateid]) ) on [factdataps]([dateid]) and want run:   alter table data . factdata add plannedoutage tinyint not null constraint addploutdflt default 0   to add additional column......   the thing there gazillion rows in table - 1,100,000,000 rows anyway (which close gazzilion)   the statement takes hours & hours & log gets

does have idea or solution fact can useful having full text search based on in memory table. it position mandatory have constraints between in memory , file based tables. in addition looks joke in memory stored procedures limited 1 action (one select, 1 update … ). not understand restrictions triggers added tables in memory (same stored procedures … ) have overview idea go way having tables in memory? for me painful hot having full control of definition “ at runtime – or define , restart database ” table, stored procedure located in memory , not. currently have create second database in memory schema , import date into. i ’ m interested learn ideas behind current version or field of database operations in memory function designed for. thanks sugestions hi mjeh1,  address points individually: 1. i'm not aware of workaround/solution fact fulltext not supported on memory-optimized tables. suggest open connect item that, doubt microsoft impleme

i have statement  select accountname account logindate > @startdate , logindate<= @enddate , accountname not in (select accountname account  logindate > dateadd(dd,-1, @startdate) , logindate<= dateadd(dd,-1,@enddate)) but database big , want optimize them , want left join replace don't know write statement left join above condition, can me ? and have idea optimize them , please me thanks all select r.accountname (select accountname account logindate > @startdate , logindate<= @enddate , accountname )r left join (select accountname account logindate > dateadd(dd,-1, @startdate) , logindate<= dateadd(dd,-1,@enddate))l on r.accountname=l.accountname l.accountname null vt please mark answered if i've answered question , vote helpful other user's find solution quicker SQL Server  > 

can connect tfs using rest client?  if yes , there standard url can used  connect server (my server tfs online) so can create issue  or issue using http post. unfortunately, have not published rest apis performing operations getting or creating work item, work underway. if want send me direct e-mail (wismythe @ microsoft.com), hear more trying do. will program manager team explorer everywhere, cross-platform, , extensibility Archived Forums V  >  Team Foundation Server - Eclipse and Cross Platform

it appear kb2752511 - fix: "arithmetic overflow error" message when run sys.sp_tables_info_90_rowset_64 system stored procedure on linked server in sql server 2012; has not been resolved. i have installed sql 2012 sp1 cu1 (http://support.microsoft.com/kb/2765331) not resolve issue. is there else can fix this. hi lance, does issue match of kb2752511 in have table 2.5 billion rows? if not, might have uncovered new - worthy of raising support call. can confirm "select @@version" reports 11.00.3321 or higher (just make sure sp1 cu1 installed)? it's going on linked server, version other server? SQL Server  >  SQL Server Database Engine

hi all, i using silverlight business application using wcf ria services. in domain class there method  public iqueryable<employee> getemployees() { return this.objectcontext.employees; } this method returns al field in table , can bind datagrid. table contains employee id,employee name , age fields. now want take 1 or 2 fields table. mean need employee name , age ,not id.  or need use employee name bind combobox.  how can this? duplicate post find answer in bewlow thread http://social.msdn.microsoft.com/forums/en-us/silverlightarchieve/thread/008c9ed2-1953-4803-9006-edcca067bcfe#f57e7e70-2825-45eb-8848-dfeeef28a412/1?p=true&t=634549488475806791 Silverlight  >  WCF RIA Services with Silverlight

hi , we have silverlight application ria services. it's works on pc application in oob mode on mac osx failed when call ria methode the  requiresauthentication attibuts...   we received "acces denied" message on mac application. if delete requireauthentification attribut it's works.... have idea why on mac authentification failed ?  thanks all take @ thread: http://forums.silverlight.net/forums/p/194104/451610.aspx#451610 Silverlight  >  WCF RIA Services with Silverlight

hi, im using ms sql 2005.. bit datatype define 0/1.. how define bit other 0/1, example want define male/female, red/green etc..is possible? or there other datatype more suitable define gender(male/female)? or need use varchar? tq..   a bit value may 0, 1 or null.  typically, 0 , 1 translate to boolean in programming appropriate data type when need true/false or yes/no values.  possible use bit gender not intuitive value might indicate male or female.  instead use "gender_code char(1)" check constrant allowing m or f.      dan guzman, sql server mvp, http://weblogs.sqlteam.com/dang/ SQL Server  >  SQL Server Data Access

  hi  this regarding sql sever 2000. ( upgraded form sql7). log file increasing in high manner. 40 gb, 50 gb , 57 gb. mdf file around 15 mb. created , tried restore system. asking 57 gb free space. how proceeed file recovery. have backups askes more space log file. how retrieve data. rgds pramod   check if database in replication or open transaction. run dbcc opentran , see result.   if have space issue , truncate , shrink file. take backup. once tl shrinked , keep more frequent tl backup keep tl size under control. , also, if don't need full recovery model change simple recovery model.     refer :   http://support.microsoft.com/kb/873235 http://support.microsoft.com/kb/272318 http://www.karaszi.com/sqlserver/info_dont_shrink.asp     madhu SQL Server  >  SQL

i tried change fonts eg: copperplate gothic when build, says font, copperplate gothic isn't built in silverlight font. must embed font fot display in silverlight application . i using expression blend 2 , project type, silverlight 2 application. can me on this?   many thanks. sya   hi sya, in text area of properties panel selected font there checkbox "embed".  checking include font in dll display on client.  xaml reference should fontfamily="./fonts/fonts.zip#copperplate gothic" Silverlight  >  Getting Started with Silverlight

hi all, we're having issues in importing data exported microstrategy, text file. flat textfile comes comma 1000 separator : "1,000".  while importing textfile in powerpivot, noticed no data superior 1000 imported (replaced void value). no value above 1000 present in power pivot. tried solve issue : changing data type , data format did not help. temporary bypass worked move 1 of data line (whose value > 1000) top of our extfile. reimporting modified file through "exiting connection -> edit" "refresh", directly visualize line moved @ top present correct value. interestingly enough, rest of data value > 1000 imported. i hope clear enough! so our question powerpivot community : did have issue, , there known bug fix, or consistent bypass use? thank you! romain. there similar problem not long ago importing text field. seems powerpivot has undocumented sampling behavior when importing text files. in case text longer arbi

hi folks, goal trigger ssis package after load data finish not using usual agent schedule; on contrary, on demand .   from 1 of erp , using odbc, data posted in set of sql tables. idea following: once copy of data finish, ssis raise , generate xml files in ftp.   1)defining trigger @ table level , execute sql server agent job , hence, 1 call @ same time ssis. here trigger not know when last row has been inserted apart of locks can generated.   2)send email trigger @ table level. act consequently, hand. option ridiculous.   3)remove dust old vb .net application used triggering dts, ssis, etc.. under criteria.   4)using wmi event watcher task within ssis. using loop task and   eval = true. memory leek?   5)using notification services? how?   thanks indeed sharing ideas , inputs, hi enric, i think it'd best set flag in status table ssis can poll periodically ssis can run every x min , when flag set process not check until package done exec

hello, we have installed sql server 2008 64 bit enterprise edition on windows server 2008 r2. has installed visual studio not showing business intelligence development studio. when have installed 32 bit version on windows vista showing sql server business intelligence development studio under sql server 2008 folder , ms visual studio separately.  i know can use ms visual studio bid, project templates not coming when create new project - > project window. did miss anything? becuae templates should come automatically in new project windows. many help. have installed ssrs, ssis , ssas? you need templated version of vs report, ssis package , olap design. kalman toth, sql server & bi training, ssas, ssis, ssrs; http://www.sqlusa.com SQL Server  >  Getting started with SQL Server

hey everyone i have combobox on page load needs entries column in table in sql database. table's name "name" , has 2 columns, "nameid", , "name". i've set ado.net entitiy model , web service refers in silverlight app already, proper linq code in vb.net refer specific column in specific table , load items in in combobox? what makesloaded?  should asynccallback.  http://msdn.microsoft.com/en-us/library/cc646858(vs.95).aspx Silverlight  >  Accessing Web Services with Silverlight

i have ssis chepoint file implemented. when package runs, creates checpoint file , upon completion deletes file. in case of failure doesnt delete cp file. when re-run same ssis, runs left off in earlier run , starts running there. in scenarion, after package completed successfully, doesnt delete checkpoint file ideally should. please suggest making mistake in setting property?? have set task level property failpackageonfailure true though. property settings fine , there scenarios checkpoints not work : 1 - concurrent/parallel  tasks . 2 - not work for , each loop. 3 - ignored event handlers. happy help! thanks. regards , wishes, deepak. http://deepaksqlmsbusinessintelligence.blogspot.com/ SQL Server  >  SQL Server Integration Services

i'm preparing exam , concerned haven't worked sql in quite time. pointers on should place focus exam scheduled on 8/29/10...thank you there mcts self-paced training kit exam. can use buck woody notes which help to prepare for exam - http://blogs.msdn.com/buckwoody/archive/2009/02/25/exam-70-432-ts-microsoft-sql-server-2008-implementation-and-maintenance.aspx . used them in preparation. SQL Server  >  Getting started with SQL Server

  hi all,  what best practice use i.e. button sample control when need different button styles inside same app? should make copy of both button.xaml , button.cs every different button. this takes me question: how know button.cs elements referenced objects inside defined in button.xaml? dont see x:class namespace inside of xaml of controls.  thanks in advance, alex for control samples, code controls loads xaml assembly a resource. depending on whether using button declaratively or through code dictate mechanism use. you add parameterized constructor button takes key style want, , load appropriate xaml based on key. don't think use declaratively call default constructor or  you sub-class button , in new class load right xaml. way stil treat button base class code, use different variants need to. can used declaratively there different classes each of styles. Silverlight

hi, i noticed can't access drm content via silverlight, long intel hd graphics driver installed.  have tried far , have been googling issue ages - no reuslts. answer find far seems issue graphics drivers there no apparent solution yet.  i using lenovo thinkpad x230t (34372yg) intel hd graphics 4000 chip , latest drivers , updates.  i have tried reinstalling/repairing silverlight installation multiple times, have reset drm cache, tried stream content in various browsers (as administrator) , different internet connections.  the thing seems work uninstall intel graphics drivers - @ least until windows automatically installs latest drivers, @ point stops working again. no real solution there, either.  this has become frustratin, since can't use single silverlight-based online streaming service machine.  appreciated! thanks, john hi, based on description,it seems intel graphics drivers have compatibility problems silverlight. i would suggest clean corrupted

hello, i have simple report created report builder. when run report form http://xxxx/reports work ok. when export report excel if number of row returned the query < 11251 work, if > 11251 error generated: [ioexception: impossibile leggere dati dalla connessione del trasporto: connessione chiusa..] system.net.connectstream.read(byte[] buffer, int32 offset, int32 size) +1321 microsoft.reporting.webforms.soapreportexecutionservice.serverurlrequest(abortstate abortstate, string url, stream outputstream, string& mimetype, string& filenameextension) +649 [reportserverexception: impossibile leggere dati dalla connessione del trasporto: connessione chiusa..] microsoft.reporting.webforms.soapreportexecutionservice.serverurlrequest(abortstate abortstate, string url, stream outputstream, string& mimetype, string& filenameextension) +1002 microsoft.reporting.webforms.soapreportexecutionservice.render(abortstate abortstate, string reportpat

hi, i developing raffle site   using silverlight, need 3d   prize wheel ,but don't know how in silverligt,please give me some   tips ,thanks in advance. hi tereoo yolsj, did search around net? here results... silverlight prize wheel animation using custom circular listbox control regards. christian amado | software engineer | mcpd: windows phone developer | mcts: silverlight developer Silverlight  >  Silverlight 5

i have think not large fact table (approx 20 mil rows) of invoice line items.  there approx 4 mil uniquie invoiceid's listed in fact table.  seem have trouble getting invoiceid return dimension.  i've tried creating dimension based on fact table , using dimension.  i've tried pulling invoiceid out in separate table in dw, , creating dimension off of it.  what happens is, i'll use filter (typically based on date , ship location) try , limit number of invoices in play.  then, when try add invoiceid dimension query usually fails due lack of memory.  i should note, use cube browser testing client tools tableau, excel, , proclarity.  users won't know mdx, hope solution can done in as.   sam hello! think way solve problem build separate invoice number dimension , create artifical levels in dimension. the first level can first character/number in invoice number. on second level can use 2 first characters/positions , on. with technique avoid problem of having

hi, in order deploy ssis 2012 project project deployment model working directly inside prod environment without using ssdt in dev environment, can .ispac file, copy prod db server , use deploy project feature? thanks hi, yes, can copy , run file opens import project wizard, intended use  arthur myblog twitter SQL Server  >  SQL Server Integration Services

i had above error, , since there hardly found on internet, post solution problem here, in case else runs in well... i have class person property jobs, of type entitycollection<job>. error occured when had added new job jobs property , tried delete it. the problem had forgotten set 'association-id' of new job. example code on webserver side: public class person { private list<job> _jobs = new list<job>(); [key] public uint personid { get; set; } [include] [composition] [association("person_jobs", "personid", "job_personid")] public list<job> jobs { { return _jobs; } set { _jobs = value; } } } public class job { [key] public virtual uint jobid { get; set; } //property, necessary association person public uint job_personid { get; set; } } in example, had forgotten set job_personid of job, before adding job.j

hi, i'm using sql 2000 , dts load data deferent tables. prevent queries tables i'm loading data to. most of users use ms access to data dw , want prevent queries during load of data worng data if request data during load. thank in advance not sure how implement in dts (it's been while) seems table lock on table. in ssis, using ole db destination, you'd check table lock option. john welch | www.mariner-usa.com | www.agilebi.com | ssisunit.codeplex.com SQL Server  >  SQL Server Integration Services

i upgraded computer , have lost ability create new or modify existing dts packages. old computer running win xp worked should, new 1 cannot. have lenove thinkpad running win xp pro v2002, service pack 2 , using sql enterprise manager v8.0. if click properties existing package, layout window opens there no tools choose, running transformations, etc. not availble (visible) work with. it's same if try create new package -- nothing present in window work with. is there fix this? should point out that, packages still run scheduled , can manually started, can't modify them on machine. can use machine on network edit, not mine. help! trying edit them tools of sql server 2005 (or above) ? if yes, have bad news you. way edit old dts packages open them in old tools (sql server 2000). there no support in sql server 2005 edit packages anymore sql server 2005 mad big step in terms of etl functionality , shifted on ssis packages (sql server integration services) jens k. suessmeyer

hello everyone, i want to develop google interface. in google if user log in on google.com then he don't need log in again gmail, orkut, picasa etc. how achieve same? thanks in advance.  look isolatedstorage sitesettings.  can store information can accessed site on same domain. i'm taking guess , assuming cookies similiar, have no experience them. Silverlight  >  Visual Studio & Silverlight Development Tools

hi, in ssis package reading data stage table , storeing in main table between need derive 1 column have use derived column transformation. cloumn values input:2009-898978-1 want output: 898978  i have write code in sql this [substring(substring( avtalsnummer,charindex('-',avtalsnummer)+1,len( avtalsnummer)),1,charindex('-',substring( avtalsnummer,charindex('-',avtalsnummer)+1,len( avtalsnummer)))-1)] above code return values between special character "-". when put code in derive column transformation in ssis give error .expression syntex become red. please tell me how convert above code per ssis coding standard. solution: substring(avtalsid,findstring(avtalsid,"-",1) + 1,(len(avtalsid) - findstring(avtalsid,"-",1) - findstring(reverse(avtalsid),"-",1))) SQL Server

hi, i new ms sql server 2008 multiple language support. all text data type using unicode (nvarchar or ntext). i need help and clarification.  i can insert record sql server  e.g. insert into multi ( fname ) values ( n'維他命是' ) however, when run select query in management studio, display boxes instead of actual text . why??  however, using asp.net (vb.net) applicaiton, can bind , display text in chinese in browser. also, can enter text in web application , filter chinese properly...   que 1: however, in management studio display boxes?    suggestions? also, record may contain simplified chinese, thai, spanish, french and other languages well... @ moment, i'm using windows xp sp3 , vs 2008 developmet.. que 2: have install languages using regional settings... que 3: since there many languages, have set collation 1 language?? http://social.msdn.microsoft.com/forums/en-us/sqltools/thread/36f83399-88ef-459d-9514-7698b0bee584 http://msdn.microsoft.com/en-us/library/ms18017

have sql 2000 database instance 4 databases. 2 fine, 2 randomly stopped. detached and reattached them , in "read-only" mode , when try change them writable file permission errors: help/hints appreciated: i know old customer has process require 2000 version.  on 1 reattahced in 2008r2 , 1 apparently cannot moved. title: microsoft sql server management studio ------------------------------ alter failed database 'mydatabase'.  (microsoft.sqlserver.smo) ------------------------------ additional information: exception occurred while executing transact-sql statement or batch. (microsoft.sqlserver.connectioninfo) ------------------------------ device activation error. physical file name 'e:\mssql\data\mydatabase_data.mdf' may incorrect. device activation error. physical file name 'f:\mssql\data\mydatabase_data_1' may incorrect. device activation error. physical file name 'f:\mssql\data\mydatabase_data_1' may incor

hi need there connection manager in ssis connect report manger url.. for example if upload excel file in report manger..is there way connect ssis package excel file in report mnager you may able connect reporting services web service. or setup subscription, run report , access output file destination point (i.e. file share). have @ following includes .net code connecting ssrs webservice... http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx ...you can embed similar in package. gives starting point. ...and more here... http://msdn.microsoft.com/en-us/library/ms152787.aspx   thanks /neil moorthy - senior sql server dba/developer (mcitp (2005), mcad, oca 11g) please click mark answer button if post solves problem SQL Server  > 

i in process of designing fact , dimension tables use ssas cube. i little unclear columns should share same dimension table. example have columns source tables such provider , provider description. assume these share same dimension? i have columns in sources tables not have any relevance other columns. should these types of columns placed in own dimension table?       i have number of yes/no columns. should make dimension has reads?   id answer 1    yes 2    no is body able advice me?   mr shaw shaw, in general source tables contains more columns required in dimesnion table. can expect might have happend source table designed meet requirement of source application. having said answer question, need design dimension including required fields (attributes) reporting. advisable keep minimum fields in dimension table. regarding second question including yes/no columns include in dimension or not. if have requirement of differentiating data flat, answer yes other wise not r

hello! i create progressbar textblock in it, in middle of progressbar, how can that? @ moment, have several controls , not 1 control that. so, have progressbar , place textblock-control on it, when shrink progressbar, textblock isn't understandably in middle of progressbar anymore. thank in advance answers! best regards dellarocco you can see following links http://forums.silverlight.net/forums/p/54784/141252.aspx or can use databinding bind text property inside progress bar see link below http://forums.silverlight.net/forums/p/163280/368266.aspx Silverlight  >  Silverlight Controls and Silverlight Toolkit

hi, have data this time customer material position lines content value 1 1 1 1 115 48598 423 1 1 1 2 5631 1099365 195 1 1 1 3 4014 1532612 382 1 1 1 4 260 98811 380 1 1 2 2 442 92063 208 1 1 2 3 355 110936 312 1 2 1 1 5555 2119206 381 1 2 1 2 1935 504330 261 1 2 1 3 2100 845247 402 1 2 1 4 120 78384 653 1 2 2 2 411 130254 317 1 2 2 3 433 176397 407 1 3 1 1 191 79057 414 1 3 1 2 520 70626 136 1 3 1 3 476 233265 490 1 3 1 4 69 26865 389 1 3 2 2 378 61295 162 1 3 2 3 128 77186 603 1 4 1 1 10 3896 390 1 4 1 2 2162 279256 129 1 4 1 3 558 213501 383 1 4 1 4 14 5684 406 1 4

hi expert, i being troubled these days kind of problem, can me?!!!! platform: windows 2003 server, data source: sql server 2008r2, cube: ssas 2008r2 the db of datasource , cube local, cube building is timout bids, sometime. the db size around 300gb (no paritition), checked options db , cube, looks not timout configuration. generally cube deploy finished in 6-7 hours, error occurs after 3-4 hours beginning. -- thanks, justin hi, i happy if problem solves. however, suggest download , read whitepaper below provided microsoft. believe helpful: http://www.microsoft.com/en-us/download/details.aspx?id=17303 please share experience. cheers please mark answer or vote helpful if post solves problem. mcp, mcts, mcitp SQL Server  >  SQL Server Analysis Services

sql server 2008 sp1 ssas: changed behavior of ignore unrelated dimensions it's behavior of ignore unrelated dimensions has changed since sp1. with 2005 , 2008 rtm behavior expected. example: measuregroup dimensions product , customer , measure sales filtering on customer, product , other dimensions region gives following set: product customer sales a           w               20 a          x              10 b          y              20 c          x             15 measuregroup b dimension customer (and others) , measure #visits filtering on customer gives following set, product=[product].[product].[all]: product customer #visits all          v              1 all         x             2 all         z             3 before sp1 complete set of customers v, w, x, y, z but since sp1 looks customers matches filtering of measure group returned in result set of measure group b. in case x. complete set of customers now: w, x, y??????????   is bug? think so, or has changed?   i don&#

how go comparing row values? lets have report has 2 records paricular id. need compare values , put visual cue. there group based on id , in background color section have tried these =iif(runningvalue(fields!recorddelimiter.value, countdistinct , "table1_feed_code" ) = 1, "white" , "red" ) =iif(runningvalue(fields!fieldqualifier.value, max , "table1_feed_code" ) = runningvalue(fields!fieldqualifier.value, min , "table1_feed_code" ), "white" , "red" )   the odd thing seems work purely text fields...but of cells contain data \t, or " or 2 or , help! but seem work. hi, you can add 2 calculated fields usage instead of original fields recorddelimiter , fieldqualifier, , replace special character regular ones in the expression of calculcated fields' value, i.e. =iif(fields!fielddelimiter.value = "/t","slasht",fields!fielddelimiter.value). in color expression, convert numer

i love idea special geo type make easier , faster find places in data table in radius of given lat/long.. so thinking should able write relativity simple query create , populate new column or new table  geo information (if new table linking id) something of course not working @ all... create table geolocatons select places.id,  geography::stpointfromtext(lat & long) geodata places i have no idea @ point syntax of geography::stpointfromtext(lat & long) part is... seems common need can't find straight forward example...           - 10spotdomain domain , domain related needs ok here answer have found works, below link whole thing... http://www.sql-server-helper.com/sql-server-2008/convert-latitude-longitude-to-geography-point.aspx here part needed: the problem format 'argument' geography ::stpointfromtext function odd - must string contains text ==> point... etc see in example below.  works! using geography::stpointfromtext the fi

i have lot of code developed in visual basic 6.0. me dificult try migrate code visual basic .net 2003. want begin use visual team server, question , how can access vb6 source code uploaded visual studio team server?. in vb6 don't expect use of improvement in new source control server. don't want shelve, policy or other, thing want able check-in , check-out  code visual basic 6.0. thanks much. a team foundation source control plug-in vb6 made available around time team foundation ships. buck Archived Forums V  >  Team Foundation Server - General

the configuration 2 sql 2008 tcp/ip , namedpipes enabled. both servers bound 1433. when users browse sql servers (we have two) on network, intermittent list of servers. see both server servers , other times dont see any. have ports 1433 tcp , 1434 udp open on both servers sql browser started. any guidance great! mike mike hartman hi, appending lekss, server display list can vary depending on factors such timeouts , network traffic. can cause list different on 2 consecutive calls. servers on same network listed. broadcast packets typically won't traverse routers, why may not see server listed, stable across calls. additionally, when cannot browse sql server instances, can test network connection using ping grogram: 1. on client, type cmd in run dialog box, , click ok. 2. at command prompt, run following command: ping <server name> if fails, think issue caused network problem , not sql server problem. suggest contact network administrator resolve problem. reference: enumerati

is possible access claims aware wcf service(which requires caller token) silverlight5 application?hence silverlight not support microsoft identity model,is der other way it? thanks in advance. hi since silverlight supports basichttpbinding , custombinding, so you cannot use wshttp, ws2007http or anyother binding. of course trying call directly client never happen because of binding issues , because client auth awareness security of sl (windows/forms/wif/etc.). so silverlight not support claims based authorization , ws-trust out of box. there elegant , usable "silverlight" version of wif identitymodel stuff available in identity training kit. the solution consists of base authenticationservice translates wif authentication tokens claims server side, , silverlight client library "sl.identitymodel" containing building blocks such silverlight version of claimsprincipal. please identity training kit here . best regards, amy peng we trying better

hi, creating simple package load 100 records 'microsoft excel 2010' sheet  into sql 2012 database using ssis 2012. have simple data flow task as excel source,  a derived column transformtaion and  a oledb destination. but, simple task not running , keep on giving below error -  [excel source [30]] error: ssis error code dts_e_cannotacquireconnectionfromconnectionmanager.  the acquireconnection method call connection manager "excel connection manager" failed error code 0xc0209303.  there may error messages posted before more information on why acquireconnection method call failed. made delayvaldation true still getting same issue. can please resolve this? hi vskindia, based on error message, package cannot run because specified connection failed in excel source. message might appear because of 1 of following problems: the connection string specifies provider not supported. please make sure use correct provider. use microsoft jet

ultimately want add copyright notice. need @ moment $year$ parameter keep copyright notices date. please can tell me how achieve this. thanks. hi timb, thanks reply. does copyright notices display in web page? if yes, try solution in post: http://forums.asp.net/t/1677755.aspx?dynamically+change+the+year+of+copyright . for other source files, try solution’s methods in post: http://stackoverflow.com/questions/12199409/inserting-copyright-notice-banner-in-all-source-code-files-in-visual-studio-2012 . we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Archived Forums V  >  Team Foundation Server - Source and Version Control