Posts

Import/export packages giving TDS Stream Error

hi all, we fetching data in our cloud server internal server through packages developed through import/export  wizard scheduled through agent. all these schedulers running fine, yesterday few schedulers failed due tds error. could please check below error , suggest me work around executed user: nt service\sqlserveragent. microsoft (r) sql server execute package utility  version 11.0.5058.0 64-bit  copyright (c) microsoft corporation. rights reserved.    started:  5:30:00 am  error: 2015-05-19 05:46:40.74     code: 0xc0202009     source: data flow task 1 source - xxxxxxxxxxxxxxx [33]     description: ssis error code dts_e_oledberror.  ole db error has occurred. error code: 0x80004005.  ole db record available.  source: "microsoft sql server native client 11.0"  hresult: 0x80004005  description: "protocol error in tds stream".  ole db record available.  source: "microsoft sql server native client 11.0"  hresult: 0x80004005  description: "p

Release Management 2015 custom tools not installing past first stage

i rebuilt our workflows in new rm 2015 install. contain few custom powershell scripts created tools/actions , installed throughout 6 stage deployment (3 stages per environment, stage 1 machines, 2 odd numbered machines included in stage 1, stage 3 numbered machines included in stage 1). worked fine in rm 2013 seems custom tools installed remote machine (agent driven) on first stage. tools part of stage 1 installed on machine , tools part of stage 2 (same machine) not installed , deployments fail. what doing wrong? did change or what? the reason deploy way keep half of our machines in order customers access our system without interruption. i able track down cause of tools not deploying. since entire process went through included building new 2015 rm environment talking agents assigned previous rm server, , re-assigned... tools directory in user/account/appdata/local/rm/t/rm had existing folders/tools. agent not smart enough create new folders or whatever tools. once dele

Using OUTPUT parameter in Entity Framework

hi all, i have stored procedure returns 3 output parameters later want to use parameters next subsequent inserts. stored procedure. 1 create procedure [dbo].[sptransactioninsert] 2 @transactiontype varchar (255) , 3 @transactiondate datetime , 4 -- .... (more fields) 5 @transactionid varchar (50) output , 6 @transactionno varchar (50) output , 7 @transactionserialno bigint output 8 9 as 10 begin 11 12 -- transaction id if parameter value 0 13 -- (i.e) first time generate transaction id , send 14 -- next time same transaction id used 15 if @transactionid = '0' 16 select @transactionid = [......] from transactiontable 17 else 18 set @transactionid = @transactionid 19 20 -- transaction no if parameter value 0 21 -- (i.e) first time generate transaction no , send 22 -- next time same transaction id used 23 if @transactionno = '0' 24 begin 25

Export to First Row in Excel

hi all- quick question: how export data first row of excel spreadsheet?  have tried: 1) making named range in target spreadsheet.  not work data export row beneath named range. 2) using openrowset property (sheet1$a1:d).  think should work, problem cannot map fields field appears in destination on mapping page "f1". i not need/want field names in destination spreadsheet. thank you! bonediggler ok - it.  there no way stop creating fieldnames - there connect issue open on problem , not fixed in 2012 either. http://connect.microsoft.com/sqlserver/feedback/details/573247/ssis-export-to-excel-creates-column-names-even-first-rows-has-column-names-is-unchecked see here couple work arounds: http://social.technet.microsoft.com/forums/en-us/sqlintegrationservices/thread/2aa5769f-f4f6-43a1-9481-afdd98346dc6 chuck SQL Server  > 

Shared Database SaaS - DataAccess Layer

approach i we implementing saas shared database. having following schemas dbo.tbl_users client1.tbl_users client2.tbl_users dynamic connection string : datasource:local; userid=client1user password=client1pwd (we had created login user in database default schema client1. but though code , connecting dbo.tbl_users. instead of client1.tbl_users. approach ii we can add dynamically schema name based on client. in these case , need changes entire application. is possible approach i   hi, if object (including tables, view , ect.) without explicit schema name specified in query, object located searching default schema , dbo schema. in approach 1, if connect sql server using login client1 default schema client1, query should use client1.tbl_users in case. please make sure make connection using correct login, , default schema configured. fore more information, see how refer objects section in  http://msdn.microsoft.com/en-us/library/dd283095(v=sql.100).aspx . best

How to add accdb into SQL 2008

Image
  how add accdb system database shown in sql 2008 r2? jason you have migrate access db sql server ! refer http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#access thanks manish please use mark answer if post solved problem , use vote helpful if post useful. SQL Server  >  Getting started with SQL Server

trigger certain event based on which marker reached

i have video wth markers embedded. each marker has unique name. i'm trying trigger events based on marker reached. so far have: void theplayer_markerreached(object sender, timelinemarkerroutedeventargs e)  {             htmlpage.window.alert("pow!!"); }   what i'm looking like: if (sender == marker1) {             htmlpage.window.alert("pow!!"); }  or if (marker == marker2) {             htmlpage.window.alert("bam!!"); } how done?   movie.markerreached += new void m_markerreached( object sender, timelinemarkerroutedeventargs e) { string mtype = e.marker.type.tostring(); // determine whether // marker 1 or 2 if (mtype == “name”) //suppose let marker1 name "name" { htmlpage.window.alert( "pow" ); } if (mtype == “name2”) //suppose let marker2 name "name2" { htmlpage.window.alert( "poww" ); } }   e.marker.type string name timeline markers ---