Lun

we have ssis package contains 1 data flow task.  (that's it) it connects database , sharepoint list (using "sharepoint list source" control codeplex).  compares data , sends updates , inserts sharepoint list.  i'm not 100% sure, think actual error that's happening has sharepoint returning data ssis package isn't expecting... like... the content type text/html; charset=utf-8 of response message not match content type of binding (text/xml; charset=utf-8). that data flow task has ssis log provider text files set record onerror, onpipelinerowssent, onprogress, ontaskfailed events.  every day in july (with exception of morning) ssis package has run , written 2 messages log per day.  ("beginning of package execution" , "end of package execution").  i've appended example below: #fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message packagestart,pbhq002cn,bud\svcpbhq002n,...

hi everyone, i trying execute ssis 2008 package on 64-bit os , import excel 2003 files sql server 2008. i have created oledb connection excel file connection string retrieves excel file variable, inside foreach loop container. the run64bitruntime set false. the connectionstring oledb connection "data source=" + @[user::dataexcelfile] + ";provider=microsoft.jet.oledb.4.0;extended properties=\"excel 8.0;imex=1\";" i not able edit sql command on oledb source in data flow task. returns error : error 2 validation error. load list staged table: load list staged table: ssis error code dts_e_cannotacquireconnectionfromconnectionmanager. acquireconnection method call connection manager "list oledb excel" failed error code 0xc0202009. there may error messages posted before more information on why acquireconnection method call failed. 0 0 any ideas wrong? set connection string property of excel connection manager as: data source=" + @[user::dataexc...

hello. i have chart on a  usercontrol. (call chartcontrol) i have user control on header. ( call header control) have header on usercontrol. (mainuc) when on mainuc want data on chartcontrol updated. here i'm trying do... on chartcontrol have exposed property observablecollection   < datastuff > dataroot = new observablecollection < datastuff > { new datastuff { date = datetime .now, totalvalue=10} };   public observablecollection < datastuff > bindingdata {   get { return dataroot; }   set { dataroot = value ; } }  public smalllinegraph() {          initializecomponent();          //buildsampleset();          datetimeaxis oxaxes = (datetimeaxis)totalchart.axes[0];      ...

*bump* hi, i have x64 windows 2008 server running hyperv role. 1 of vms 32-bit windows 2008 server, trying install sql server 2008 standard edition, install team foundation system 2008 trial. i've tried several times, without luck. everytime end exact same error message: "microsoft sql server 2008 setup: the cabinet file 'sql.cab' required installation corrupt , cannot used. indicate network error, error reading cd-rom, or problem package." the error happens while status info of installer says: "installation progress. performing windows installer actions. install_sql_fulltext_cpu32_action: installfiles. copying new files." the installer finishes job, reports @ end full text search not installed properly. see log of error @ bottom of post. i'm newbie @ installing windows server, sql server , tfs, perhaps have missed 1 or more obvious steps....? i've tried following tfs install guide. i've tried installing injecting iso-file hyperv server. ...

i using wpf , silverlight bookcontrols mitsu http://www.codeplex.com/wpfbookcontrol the wpf example alows every page in book xaml file, silverlight example dont. is there way load xaml in every book page in silverlight example ?   i have page.xaml <usercontrol x:class="slbookdemoapp.page" xmlns="http://schemas.microsoft.com/client/2007" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:local="clr-namespace:slmitsucontrols;assembly=slmitsucontrols" width="800" height="600" loaded="usercontrol_loaded"> <grid> <local:ucbook x:name="book" margin="50" /> </grid> </usercontrol> , correspondent page.xaml.cs    using system; using system.collections.generic; using system.linq; using system.windows; using system.windows.controls; u...

hello guys, i've been searching day , didnt resolution. i have query: select c.cor_id, c.cor_description, case month(tur_start) when 1  day(tur_start) end j, case month(tur_start) when 2  day(tur_start) end f, case month(tur_start) when 3  day(tur_start) end m, case month(tur_start) when 4  day(tur_start) end a, case month(tur_start) when 5  day(tur_start) end m, case month(tur_start) when 6  day(tur_start) end j, case month(tur_start) when 7  day(tur_start) end j, case month(tur_start) when 8  day(tur_start) end a, case month(tur_start) when 9  day(tur_start) end s, case month(tur_start) when 10 day(tur_start) end o, case month(tur_start) when 11 day(tur_start) end n, case month(tur_start) when 12 day(tur_start) end d v_turm t inner join course  c on t.cor_id = c.cor_id t.cor_id = 113 , year(tur_start) = 2011 that returns this: cor_id    cor_description    j  ...

ok, designer came nice simple design in photoshop looks great need xaml implimentation. basically, have semi-transparent border overlays user control.  i've simulated user control below gradient.  2 issues. 1.  want border have rounded corners on outside , square corners on inside.  how?! 2.  how clip user control has rounded borders, in way works when webpage resized.  i tried a manual clipping path solve #2 doesn't work when resize webpage. any ideas?    <usercontrol xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:local="clr-namespace:test" mc:ignorable="d" x:class="test.tesb1"> <grid x:name="layoutroot" h...

hi, a user wants special fixed average. first calculcates normal average of month , puts in fixed average. now calculates averages of next months. if month average of last 7 months higher fixed average fixed average should equal month average of last month . example : we got months (1,2,3..) , averages (10,20,30 ..) . fixed average month (1,2,3,4,5,6,7) = 10 in month 8 there 7 months above 10 fixed average 80. now suppose average in month 3 = 9.  in month 4 ,5,6,7, 19, 29,39,49... fixed average month 1-9 10. in month 10,11,12,13 79 fixed average. i hope propblem clear. how do in ssas ? constantijn hi constantijin, i'm confused requirement described above. please elaborate issue more detail? why want special fixed average? technet subscriber support if technet subscription user , have feedback on our support quality, please send feedback here . regards, bin long technet community support ...

hi all, in our system whenever have restored data other server , processed cube throwing error saying 'rigid relationships between attributes changed during incremental processing of dimension'.  this error occurs if there records in analysis server dimensions not there underlying database. doing redeployment of ssas cube. to resolve issue redeploying cube , processing same.  1. there other option resolve issue without redeploying cube? 2. , processing dimensions using "analysis service processing task" , using "parallel processing". causing issue rigid relationships? regards, sindhu hi sindhu, this problem occurs when have defined rigid relationship in dimension's attribute relationship. when processing dimension using incremental processing , attribute changes hierarchy. for example, we have rigid relationships defined under: personid-->person-->department when, during incremental processing, ssas finds out person in dep...

hi have table in tabular model id investmentcode parent rootparent level rownumber rollupto percentage 9 aaa null 9 0 1096 null null 224 bbb 9 9 10 1097 1096 100.00% 671 ccc 224 9 60 1099 1097 75.00% 522 ddd 224 9 60 1098 1097 25.00% 818 eee 522 9 61 1100 1098 100.00% 944 fff 818 9 70 1102 1100 99.00% 943 ggg 818 9 70 1104 1100 1.00% 946 hhh 944 9 71 1106 1102 100.00% requried  percentage sum measure  below output format  row labels percetagemeasure aaa                     bbb 100.00% ccc 75.00% ddd 25.00% . . . . . . this seems rather trivial... about percentagemeasure:=average(table[percentage]) ? ...

hello every one, i facing different issue while porting data ragged right file table using ssis. problem there unknown value in middile of row in ragged right file not able read perticular record. seems ended perticular position, while manually opened file , find perticular record , trying drag entire record using cursor not selected perticular position end.if use keyboard select record upto end selected,but in file showing empty space. i didn't understand why happening. ragged right files ended {lf}, suspect causes end of line , tried changing crlf lf, though not reading record , in ssis not reading next record. package executing sussfully. tried different ways read type of records changing code page 1252 ansi 65001 utf8,ebcdic in ssis, not working. help me out on this. thanks earlier responce. thanks, ravikumar try looking @ file advanced text editor. enable show hidden characters. see {cr}{lf} characters. maybe there strange character in there coming...

i’m having trouble getting bound property changed events recognized treeview control.  in particular when add item or remove item itemsource property of hierarchicaldatatemplate, expect following work: ==================== divisionbusinessunit divisionbusinessunit     = new divisionbusinessunit(division); selectedbusinessunit.subclasses.add(divisionbusinessunit); ==================== instead have following: =================  divisionbusinessunit divisionbusinessunit     = new divisionbusinessunit(division); selectedbusinessunit.subclasses.add(divisionbusinessunit); list<businessunit> holder = selectedbusinessunit.subclasses; selectedbusinessunit.subclasses = null; selectedbusinessunit.subclasses = holder;  =================== note divisionbusinessunit implement inotifypropertychanged. any ideas doing wrong?   thanks, dogulas jerry, i figured out.  had defined subclasses property...

hi, i testing out new task groups option. put visual studio build steps in task group. each sln pass /p:outputpath=$(build.binariesdirectory)\[hardcodedslnname] msbuild. why task group step prompting me value build.binariesdirectory? doesn't tfs set this? thanks! dave s. i put $(build.binariesdirectory) in value , works. thanks, dave s. Archived Forums V  >  Team Foundation Server - Build and release management

ssrs 2005 hello guys, i label y-axis chart dinamically, going through chart prop see static value (tab: x axis, textbox: title). the problem label (title) dynamic, depending on data filtered please have suggestions?   many thanks hi fasttrack, the title static value, can or not show it, cannot make title dynamically in ssrs 2005, requirement easy in ssrs 2008 or r2 version, if possible can upgrade reporting services, workaround issue, can drag textbox under chart substitute title, in case, can control textbox' content dynamically. if have question, please feel free ask. thanks, challen fu forum support if have feedback technet subscriber support, please contact us please remember mark replies answers if , unmark them if provide no help. SQL Server  >  ...

i creating log files dynamically passing file name sql table. unable create it. suggest me right way. thanks here example, how create log file on each execution datetime dynamically. -how create text log file datetime in ssis package good luck! techbrothersit.com SQL Server  >  SQL Server Integration Services

i'm having trouble creating calculated member based on attribute in 1 of dimensions. i have fact table counts products (these financial products, have balances associated them).  stored based on date loaded [batch date].  each product has [added date] associated it; put date in product dimension.  since batch system (more of snapshot transactional), batch date isn't part of true date dimension. what i'm trying list count of products date , count of products added on each batch date.  i"m trying create calculated member give me count of products added on date, i'm pretty sure don't know i"m doing!:)  since intersection of [added date] , [batch date] gives me many added dates, i'm using hte lastchild give me items added on [batch date]. below query, keep getting error "the currentmember function expects hierarchy expression fo 1 argument.  member expression used.  know it's simple mdx issue, use help. with member [measures]....

i have table of agents, agent groups , agent group members.  agent can in many agent groups.  agent group members table links agent , agent group together. what best practice creating dimension , user defined hierarchy support this.  as user of cube may want browse data agent , may want browse agent group (seeing 1 line each agent) is there best practice this?  i think agent browsing use agent dimension.  i agent group broseing use agent group dimension.  means have expand agent group dimension include agent , agentgroupmembers tables.  attribute relationships.  understand how country, state, city.  agent group hierarchy have have agent group key, agent key , agentgroupmembers key?   hi, 1) can create single table contains agents & groups , create hierarchy agents groups -> agents. or if want keep both dimension tables separate can create hierarchy using both tables. check "product" dimension adventur...

i'm trying use speechmusic , tonegen extentions. have moved .dll , .xml files c:\program files\microsoft\small basic\lib instructed. when i start small basic don't see "intellisense" extensions , if run examples error "cannot find object". i'm windows xp , small basic v0.6. i don't know tonegen, speechmusic has been rebuilt v0.6 - make sure have recent version.  apart have no idea - there have been few issues these on different computers - have feeling may due directx libraries - without access system doesn't work hard diagnose. try 1 extension @ time in lib directory. other thing rebuild c# project using vs express 2008 - if install c# , interested can create step step procedure. simple c# procedure uploaded. http://cid-92f7df0e57232aba.skydrive.live.com/self.aspx/.public/smallbasic/speechmusic/c%5e3instructions.zip open zipped document wordpad or rtf reader. ...

hello all, i have 6 node geo cluster, 4 nodes in primary site + 2 nodes in secondary site. in primary node 03 , 04 has 2 pair of sql instances default + named. i planning to  move named sql pair wsfc 2008 + sql2012 wsfc 2012 + sql2014. has 1 ag group 4 tb of dbs. do guys have experience , options migration. planning go with  backup/restore. let me share yours inputs. 1. backup/restore 2. cross cluster migration 3.detach/attach 4. san migration thanks! muthukkumaran kaliyamoorthy helping sql dbas , developers >>> sqlserverblogforum since wsfc not support rolling upgrades, need have wsfc running windows server 2012/r2 (r2 highly recommended due features available maintaining high availability) , cross-cluster migration. refer documentation more details. https://msdn.microsoft.com/en-us/library/jj873730.aspx this requires you're comfortable powershell. the main challenge here dealing hardware resources since need addition...

there char(2) - char(5) fields in our database (sql2008 sp2). when applications work data spaces stored in char columns creating difficulties. there way store data in char columns when retrieve them sql server returned them rtrimmed similar varchar behavior without adding views etc database. similar "set ansi_nulls" behavior nulls when set null equal null or so. if database level setting set once awesome. if not considering rebuild our tables varchar columns , deal performance impact. thank you gokhan varol hi gokhan, it seems not available trim data char data type varchar. this, may need convert data specified length manually: declare @myvariable varchar(5) = 'abc'; declare @mynextvariable char(5) = 'abc'; select datalength(@myvariable) 'myvariable', datalength(@mynextvariable) 'mynextvariable',datalength(cast(@mynextvariable varchar(3))) 'convertlength' if not acceptable way, may consider using varchar data type in...

i'm starting visual studio development project in version control regression test (text), verification files (text) , documentation files (.docx) important source code files. (we have been using visual source safe years handle this). my understanding, such is, native version control (tfvc) on team foundation service handles source code files, , that, want, i'll have use git. can please confirm (or deny) understanding before in deep? if use git, have use command line instructions? hello jeff, you can still use tfs source control repository non-source files. note ide have set in case required perform compare operations on non-text files (i.e. set open files in application can handle comparison of such file types). you use git tfs if want. details , pointers here . not have use command line git. hope helps. regards, rahul Archived Forums V ...

in vs 2010 ssdt go tools->options->source control , there dropdown titled current source control plug-in:. however, value "none". can me going? thanks, rick do have source control software ( tfs ) installed? saeid hasani, sqldevelop.wordpress.com download books online sql server 2012 SQL Server  >  SQL Server Data Tools

i want report server ask input date parameter in 'mon-yyyy' format. how that? hi ulankz, i afraid requirement cannot achieved in reporting services. if parameter's data type datetime, can change format dd/mm/yyy or m/d/yyy or other format. cannot change 'mon-yyyy' format. thank understanding. regards, charlie liao technet community support SQL Server  >  SQL Server Reporting Services, Power View

hi, have ssrs reports deployed reportserver. want able view these reports using google chrome since chrome our default web browser. reports view fine on ie have issues controls in chrome. print button not showing, report page distorted, date picker not showing, etc any gurus' please.   hi collen, thanks post. however many features not supported in third-party browsers. internet explorer recommended if want use available report functionality. based on testing, browser compatibility root cause. suggest use internet explorer have try. moreover, suggest submit feedback @ http://connect.microsoft.com/  .if service request frequency, may improve the compatible chrome in next release. appreciate understanding. thanks, bill lu please remember mark replies answers if , unmark them if provide no help.if have feedback technet subscriber support, contact tnmff@microsoft.com. ...