Lun

i saved ssis package straight forward import table local access database table same name in sql server using wizard in ssms.  is possible have package drop table if exists before import? sure, execute tsql command: if exists (select 'x' sys.tables name = 'mytablename') drop table mytablename don't forget mark helpful posts, , answers. helps others find relevant posts same question. that statement parses a-ok, message says  "this operation has no effect since "bypassprepare" property set true. have tried set "bypassprepare" false? please click "mark answer" if post helped. SQL Server  >  SQL Server Integration Services

hi, i'm having trouble mvvm pattern build tool printing functions. here's i've done, simplified: 1st created silverlight class library, childwindowtest, created mychildwindow (the view): <controls:childwindow x:class="childwindowtest.mychildwindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:controls="clr-namespace:system.windows.controls;assembly=system.windows.controls" width="400" height="300" title="mychildwindow"> <grid x:name="layoutroot" margin="2"> <grid.rowdefinitions> <rowdefinition /> <rowdefinition height="25" /> </grid.rowdefinitions> <grid x:name="contentarea" grid.row="0"> <!-- rest of w

hi guys, i have http login page (with username , password fields).  on submit, wish send silverlight page users attempting login to. i not having luck in finding how access data fields (if done via "post" rather "get").  i.e. seems easy process fields if embedded in url (as in "get"), unsure how access them http form if "posted". any ideas? cheers, scott you cannot post html form silverlight application, because server-side concept. can process post values on server side wrote in first reply, , use values dynamically set initparams of silverlight object (what linked to). however, since talking credentials should passed around not recommend @ all. maybe better turn things upside down. can create custom screen prompts users install silverlight, , once have done that, handle login in application directly. another way use html form integrate asp.net authentication (membership), , let silverlight application ask logged in

i want read data backup file of ms sql 2000 without restoring database backup file. based on data selected manage further functionality such restoration of backup file. is possible read data ms sql 2000 backup file without restoring? if yes please let me know how? i don't think can read data without restoring backup file...................also need restore entire backup file , after restoring can choose data need..........may if have db take backup before restoring backup (overwrite) , choose data , if needed can export , once again restore original backup of db........... SQL Server  >  SQL Server High Availability and Disaster Recovery

i trying setup connection system using sql failover mirror. i given instructions use  failover partner in sql connection string if "keyword not supported" in event log i tried   failoverpartner , failover_partner , result same errro. am missing or there keyword use. help appreciated. dave dave kozlowski failover partner keyword not supported in .net 1.0 or 1.1.  can check .net version? whats sql version trying? also, can post connection string. string  cs =  @"data source=server_a;failover partner=server_b;initial catalog=mirroreddabase" ; reference http://blogs.msdn.com/b/spike/archive/2010/12/08/clarification-on-the-failover-partner-in-the-connectionstring-in-database-mirror-setup.aspx --prashanth SQL Server  >  Database Mirroring

hello. i have problem scheduling ssis package run. ssis package consist of 3 tasks, first execute process task (runs batch job an host application (summarum) with arguments), if success execute sql task (updates log table), if failure mail task. the package runs in visual studio, , stored package in management studio. can check in host applications batchlog. when create scheduled job run package every 3 minutes, job runs successful, nothing happens in host application. log job history: date,source,severity,step id,server,job name,step name,notifications,message,duration,sql severity,sql message id,operator emailed,operator net sent,operator paged,retries attempted 02/26/2010 13:30:00,summarumbatch_1,success,0,srv-dbs-05,summarumbatch_1,(job outcome),,the job succeeded.  job invoked schedule 10 (hvert_3_min).  last step run step 1 (kjøre pakke summarumbatcher_1).,00:00:02,0,0,,,,0 02/26/2010 13:30:00,summarumbatch_1,success,1,srv-dbs-05,summarumbatch_1,kjøre pakke summarumbatcher_1,,exe

does know how dtexec verbose reporting report elapsed time in minutes if elapsed time greater 60 seconds? didn't see option reporting parameter , wondered if has tried similar. thanks unfortunately option not available /rep switch.  without testing right off think create package use logging, script task(s), , variable create type of dynamic logging, not available natively. david dye my blog SQL Server  >  SQL Server Integration Services

i build project in asp.net future , add web services in it. gives error..... description:--> error occurred during processing of configuration file required service request. please review specific error details below , modify configuration file appropriately. parser error message:--> not load file or assembly 'system.data.datasetextensions, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089' or 1 of dependencies. system cannot find file specified error in web.config file,in following line. line 69: thanx ur time system.data.datasetextensions, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089'   please try change version: 3.0.0.0 or 3.5.0.0.   Silverlight  >  Programming Silverlight with .NET – General

i have following xml file: <multirslist>    <rs id="blah">       <fg name="me"/>      <fg name="pe"/>       <sg name="support team"/>       <sg name="sales team"/>    </rs>   <rs id="blah">       <fg name="ce"/>      <fg name="de"/>       <sg name="support team"/>       <sg name="sales team"/>    </rs>  </multirslist>   i'm trying foreach lop container pass script task rs element. possible? i have enumerator = foreach nodelist enumerator enumeratortype = elementcollection outerxpathstrungsourcetype=directinput outerxpathstring = /multirslist/rs/ innerelementtype = node innerxpathstringsourcetype = directinput innerxpathstring = @*   also map user variable type string index =0   i have variable contain entire rs tag in script task can manipulate.   with above s

hi i have project named...lets say sampleproject which has packages lets say package1 package2 package3 package4 now have build , want deploy in sql server.. to deploy in sql server ..do need create folder called sampleprojectpackages in msdb database in integration services connect integration services before can deploy project double click on sampleproject.ssismanifest file deploy in sampleprojectpackages folder created in msdb database ? is right way of doing it... please guide me ilikemicrosoft you dont have to... create folder make more organised!! after you've created folder rt.click on folder you've created sampleprojectpackages , select import packages , import package you've created... SQL Server  >  SQL Server Integration Services

hi,    when images selected local drive, images have stored in silverlight application folder. possible in silverlight 2..     thanks in advance.. i have got solution here, http://www.c-sharpcorner.com/uploadfile/nipuntomar/fileuploadsilverlight03182009030537am/fileuploadsilverlight.aspx     thanks replies.. Silverlight  >  Getting Started with Silverlight

 i inheriting  procedure 2 classes.. problem error because adding control 2 times. how around ?it looks cant inherit controls   class1   public overridable sub loadequationinput()         canvas.setleft(tb6, 200)         canvas.settop(tb6, 45)         canvas1.children.add(tb6) .. class2 inherits class1   public overrides sub loadequationinput()         mybase.loadequationinput()   class3 inherits class1 public overrides sub loadequationinput()         mybase.loadequationinput()               canvas1.children.add(tb6) 'gets called 2 times  can once. inheritance not easy silverlight looks of it. going need re-write whole class again Silverlight  >  Getting Started with Silverlight

server id : sync server: 5ad087df-3eea-4bfa-b44d-5892e02247ed_east us spoke server error msg: vm0ieob8y6 region : west us time / date : every 5 min since 11:35 ast feb 26th tracing id : ‘1500480b-42a1-4d59-b001-bf3526346a4b’ error msg data sync stop synchronizing changes sync group member in 44 days if failures not resolved. upload -  errors first 5 rows failed apply: error #1: sqlexception error code: -2146232060 - sqlerror number:547, message: insert statement conflicted foreign key constraint "fk__xxx__5e8a0973". conflict occurred in database "xxx", table "dbo.xxx", column 'id'. sqlerror number:3621, message: statement has been terminated.  error #2: sqlexception error code: -2146232060 - sqlerror number:547, message: insert statement conflicted foreign key constraint "fk_xxx". conflict occurred in database "xxx", table "dbo.xxx", column 'id'. sqlerror num

hi,  i trying use dax formulas run problems.  here example:  i have following data in powerpivot table named query: columns are: tsports,ts1 , calculatedcolumn1 the column calculatedcolumn1 contains following fomula: =mid('query'[tsports],len('query'[ts1])+1,len('query'[ts1])) it seems me incosistent results returned if 2nd , 3rd parameters go on length of string in parameter 1. here examples: 1) tsports contains the following value: direct     ts1 contains following value: none     calculatedcolumn1 returns following value: ct --> value expecting. 2) tsports contains following value: le havre     ts1 contains following value: le havre     calculatedcolumn1 returns following value: e  --> here problem. given formula expecting empty string!?!? in case number 2, per understanding, dax formula returning invalid result. can confirm if bug or if using dax in way not supposed to? thanks! hi santiago,   i reproduced behavior using ctp 3 , have filed report

hi, i'm getting below error. tried stop & start port. resumed partner also.. mirroring still disconnected. can help. "the database mirroring protocol transport disabled or not configured. the database mirroring protocol transport has stopped listening connections. database mirroring connection error 4 'an error occurred while receiving data: '64(the specified network name no longer available.)'.' 'tcp://db1:5022'." hi winoa, the issue may happen in following cases, can try solution each scenario. 1.if install snp, disabled snp. 2.the nic card driver not upgraded latest version, or if nic teaming not appropriate, or other hardware related errors. ensure nic card drivers upgraded latest version; check nic card team correct h/w vendor/network administrator; perform thorough hardware diagnostic check on sql server boxes (all 3 servers) , upgrade drivers, firm-wares, bios latest version , system in healthy state. can run below co

hi, there,   dose know how upgrade sql server 2005 standard edition enterprise edition?  thanks. you need use skuupgrade=1 swtich command prompt setup. here details: start /wait setup.exe addlocal=sql_engine instancename=mssqlserver upgrade=sql_engine skuupgrade=1 /qb http://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade SQL Server  >  SQL Server Replication

i 2 comboboxes on work item: 1 "group" , 1 "assigned to".  group combo have list of ad or tfs groups (i know how this). when value of group combo changed, 2nd dropdown (assigned to) should repopulate show members of selected ad/tfs group. example: tfsgroup1 contains user1, user2 tfsgroup2 contains user3, user4 when select tfsgroup1 group combobox, "assigned to" contains user1 , user2. when select tfsgroup2 group combobox, "assigned to" contains user3 , user4. how accomplished? thanks! david hi david, i don't have better way of doing "dependent combos" implementation have suggestion making easier maintain (depending on corporate security rules).  you can load each tfs group corresponding active directory group , maintain other ad group.  allow move users around in ad when change roles inside team.  groups have varying permissions in reporting services , sharepoint kept up-to-date via ad group memberships. here's caveat.  if ha

hi, i need run azure data base related unit tests running part of vnext build definition. running these tests need add hosted agent ip in whilelist range on azure portal(else getting system.data.sqlclient.sqlexception: login failed user ). stuck @ point since don't know how find ip of hosted agent can add. possibly ip change everytime build runs. can guide me on scenario how proceed. -naman hi, greetings vso build agents hosted in cloud,so there no changeless ip range them. regards, asha Archived Forums V  >  Visual Studio Team Services

hi all, i have transfer data xl sheet mysql database.i have created linked server excel in  sql 2005  , able retrive data excel sheet .i have down loaded connector mysql database.my problem data flow destination need use in ssis mysql data base. can 1 me resolve this.... thanks murali you can refer 2 posts http://blogs.msdn.com/mattm/archive/2008/03/03/connecting-to-mysql-from-ssis.aspx http://blogs.msdn.com/mattm/archive/2009/01/07/writing-to-a-mysql-database-from-ssis.aspx - chintak SQL Server  >  SQL Server Integration Services

recently operating system upgraded windows 7. basic installation contains configuration tool set of sql server 2005. need isqlw keep daily work simple. can download isqlw , sure legal , allowed me? thanks hello, isqlsw sql server 2000 ( no more supported ) please, have @ link ? http://social.msdn.microsoft.com/forums/en/sqlexpress/thread/e0694280-63a2-41b0-8784-c6b0f0db1652   or may sqlcmd replacing isqlw http://social.msdn.microsoft.com/forums/en/sqlexpress/thread/e0694280-63a2-41b0-8784-c6b0f0db1652   and search be careful choose download (x86 maybe ) , furfill requirements have nice day mark post helpful if provides help.otherwise,leave is. SQL Server  >  SQL Server Data Access

hi everybody, i'm developping silverlight 4 application silverlight-enabled service. application works fine on computer , when publish on server (server 2003) i'm not able browse silverlight-enabled service. error: page cannot found 404. does knows why? thanks maxime hi,    after deploy, need modify endpoint address in web.config.    change endpoint address in servicereferenceclient.config best regards Silverlight  >  Visual Studio & Silverlight Development Tools

hi everyone,   i've currently re-installed machine with (new) xp os.  install sql server 2008 r2 evaluation edition, install visual studio.  don't know order , edition of visual studio work server 2008 r2.  i've searched online for the information and got more confused.  can suggest links or sites 1 can understand edition of visual studio need install 2008 r2 , in order please?  i've browsed microsoft pages, including forum, couldn't find helpful link.  thanks in advance i recommend visual studio 2010 -  http://www.microsoft.com/downloads/en/details.aspx?familyid=06a32b1c-80e9-41df-ba0c-79d56cb823f7 i recommend setup visual studio first, de-select sql 2008 express option. setup sql server after completion of visual studio setup. be sure install service pack 3 on windows xp required both applications. SQL Server  > 

hi all, need solve problem: select a.machine_id, b.src_file_name as source, a.created_dttm as date case when b.src_file_name like '#%' then 'na' else ( select src_file_name from fct_machine_evnt_dtl ed where ed.machine_event_detail_id = ( select top 1 ed1.src_file_name from vw_fct_machine_evnt_dtl ed1, vw_fct_machine_event me where a.machine_event_id = ed1.machine_event_id --and m.machine_id = ed1.machine_id and a.event_type = 13 and convert ( varchar , a.created_dttm, 101) between '11/21/2010' and '11/27/2010' and cast (ed1.created_dttm as float ) = ( select min ( cast (ed1.created_dttm as float )) from vw_fct_machine_evnt_dtl ed1, vw_fct_machine_event me where a.machine_event_id = ed1.machine_event_id and m.machine_id = ed1.machine_id and a.event_type = 13 and

backward compatability failed while doing upgrade sp2 sp4. it not processing anything. please help below errolog 2013-09-27 16:28:33.18 server      microsoft sql server 2005 - 9.00.5000.00 (x64)  dec 10 2010 10:38:40  copyright (c) 1988-2005 microsoft corporation  enterprise edition (64-bit) on windows nt 5.2 (build 3790: service pack 2) 2013-09-27 16:28:33.21 server      (c) 2005 microsoft corporation. 2013-09-27 16:28:33.21 server      rights reserved. 2013-09-27 16:28:33.21 server      server process id 6336. 2013-09-27 16:28:33.21 server      authentication mode mixed. 2013-09-27 16:28:33.21 server      logging sql server messages in file 'd:\sindiatd01\data\mssql.1\mssql\log\errorlog'. 2013-09-27 16:28:33.21 server      instance of sql server last reported using process id of 5124 @ 9/27/2013 4:28:12 pm (local) 9/27/2013 10:58:12 (utc). informational message only; no user action required. 2013-09-27 16:28:33.21 server      registry startup para

hello    i santosh using sql server 2005 on server hp ml-350 g5 16 gb ram.i problem facing server take long processing time for  quarry .so shift  another  server configuration 48 core processor & 128 gb ram windows 2008 enterprise 64 bit os.but problem not solved .to take long time processing quarry .                                please me  solve  problem . santosh thorwat ( incharge) patil group pune visit :-www.patilgroup.co.in/www.patilconstruction.com email:edp@patilconstruction.com/edp.patilconstructions@gmail.com what process (roughly) doing? guess it's ssis process. packages designed? poorly disigned packages can dramaticly worsen performance. there lot of design/performance best practices available on web. here list of easy implement performance best practices . please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com SQL Server

can tell me find microsoft sql server 2008 express edition: management studio express 2008??? please need know can find it. want learn how use tools.   thanks help.   reboot you may download here . have download either sql server 2008 express tools   or sql server 2008 express advanced services . when install , if need tools , select only workstation components, .   madhu   SQL Server  >  SQL Server Tools

  i new mdx. in sql have wild card search. example. select * products product "aa%".we records product start aa. how same in mdx? hi rakam,   the easiest way achieve using filter function to filter members caption property following sintax: code block select non empty filter ([product].[product]. members , left([product].[product]. currentmember . properties ("caption"),1) = "m") on rows , [measures].[internet sales amount] on columns from [adventure works]       but has drawbacks when querying big sized cubes filtering scan every dimension member. you can otherwise create user hierarchy groups products first letter instead of filtering member can select product group following:   hierarchy: product letter ----------------------------------- first letter group product   so can build mdx this:   code block select [products].[product letter].[first letter group].[a] on rows measures.[int

question: best way handle cross entity operations? the obvious (problematic) example can think of entities in many-many relationships, 1 side of many acts "child" of parent side. i.e. when of child.parents deleted, child should delete self also.(i should point out client side can not see parents, have access limited scope, lazy loading/auth reasons) initially thought modify delete entityservice method, if child null query db child, query child's join entities, if count 0, delete child. however, problem is...e.g.: delete 2 joinentities, deleting first, result in querying second. when second delete method gets invoked, give exception (entity same key exists) what best way deal scenario? i can think of few possible solutions. a) handle error, search entity manually in context (this sounds horrible idea thou) b) instead of doing query+check in delete method, in override e.g. after base.executechangeset() (or possibly beforepersistchangeset thou

hello, a have report that's build in report builder 3.0 - ssas cube datasource. in report have several parameters that's build cube dimensions. now implement cascading parameters example if user selecting specific company (from company dimension/parameter) products (item groups) company shown in next parameter the product parameter/dimensions.  i've understood should supported default when dragging , dropping parameters in query designer - have problems getting to work. the structure of company dimension [company].[company]&[ukcompany] the structure of products dimension (item group attribute)which i above company to be passed is:   [products].[item group].&[ukcompany].&[chairs] how can manage above ?  seem in hidden dataset of product parameter takes: ( select ( strtoset(@company, constrained) ) on columns@company  - pass on product dimension - , not seems enough in above described structure of product parameter help ...what can ?

i couldn't find way access column options links tab on tfs 2012 web access. missing feature or can turned on via settings? insight appreciated.   hi, thanks feedback! as far know, not supported in add column options in links tab in bug work items. for more information, please refer http://social.msdn.microsoft.com/forums/en-us/03e6abb2-9167-4ea2-b4f6-e74869e2f4af/links-tab-work-item-status best regards, cathy kong msdn community support | feedback us develop , promote apps in windows store please remember mark replies answers if , unmark them if provide no help. Archived Forums V  >  Team Foundation Server - General

  <datatemplate x:key=" mycontrolitemdatatemplate " >         <local: mycontrol />     </datatemplate> listbox. itemtemplate =application.current.resources[" mycontrolitemdatatemplate "] datatemplate; when dealing list box items, best way access mycontrol . done traverse down visual tree visualtreehelp, when listbox has large number of items, slows app lot. any suggestions? i can't see way of doing that.  i guess try geting hold of them on loaded event. it's more memory not have traverse visual tree. just crazy idea. Silverlight  >  Programming Silverlight with .NET – General

hi, looking way define dns cname form "named sql instances" i.e. if want give name dbsqlp01 sqlserver1\instance1. instances listening on static ports. possible ? if yes, can me in regards, ? regards, deepak dns not contain port information design.  may work iff have 1 instance per computer listening on default tcp port.  i'm assuming wish have multiple instances per machine, hence question.  afaik, not possible, sql instances not treated virtualhosts in webserver. you may consider adding server alias deployed client machines, e.g. reportingdb -> centralsqlserver\reporting SQL Server  >  SQL Server Data Access

i trying install business scorecard manager server , have installed sql server 2000, analysis services , service pack 4 , have taken mixed mode of authentication . have installed sharepoint portal server 2003 , extended site . when install bsm server @ end of installation gives me error user administrator not exist in scorecard server database( database created during installation process ). error comes when installation package trying create query string existing sql server database. same thing happens if take sql server 2005. in regard appreciated. thanks inder if problem occurs during installation of business scorecard manager server, should post on forum dedicated product. for example, see there posts installation issues bsms on following forum: isv open discussions . try posting question on fourm if not answered there. thanks laurentiu SQL Server

hi,       have simple package, has bulk insert task in control flow, , trying load count out of task keep in table balancing purposes, there way this?  have checked bulk task logging , getting begin time , end time, nothing on how many rows inserted.   thanks pam once done bulk insert task, may want use execute sql task issue select count(*) table loaded records to.  there, can use resulting count , perform balancing. otherwise, may want use data flow process records, enable @ more detail. SQL Server  >  SQL Server Integration Services

howdie, everyone.  if selected wrong forum this, apologize. i should qualify subject line of discussion saying using visual studio 2010 (10.0.30319.1 rtmrel) ultimate.   can reproduce same behavior on visual studio 2010 premium. we have team project *collection*.  title of thing implies, have multiple team projects in collection.  trouble comes in popup checkin window, pending changes checkin window, show items checked out entire collection.  appropriate, since may need make changes several projects in course of fixing problem, or may need start making changes in one project, , switch on project before completed or checked in. once have pending changes multiple team projects, can witness behavior checking checkboxes items in different team projects, , clicking paper/red circle/white minus sign icon evaluate checkin policies.  when have items multiple team projects selected, evaluates none of policies in of projects, rather falsely tells "all check-in policies satisfied