Posts

Addin in VS2005 & VS2008 using TFS OM

  hi,   i've written visual studio addin uses tfs client om dlls. it adds menu item source control explorer , uses om access version control & wit.   the addin references 2008 dte dlls , loads in both vs 2005 & 2008. but, if references 2005 tfs dlls (microsoft.teamfoundation.* & microsoft.visualstudio.teamfoundation.* ) can access 2005 sce, , vice versa.   the command fails is:   code snippet   versioncontrolext vce = _applicationobject.getobject( "microsoft.visualstudio.teamfoundation.versioncontrol.versioncontrolext" ) as versioncontrolext ;       is there way access both versions in single addin? is there way detect running version , load sce accordingly?   thanks, shay shay,   if not reference specific version (8 or 9) of dlls , not use 2008 specific functions, add-in should work vs2008.   but guess of menus etc. may different in vs2008; solve problem having 2 versions of add-in (same code base,...

SSIS package

Image
hi, i ve ssis package. there table in database following columns: excel used          table      no.of records          status abc.xls                  xyz            1234                    successfull i want after package debugged completely,the above table automatically gets filled corresponding values used in package. description of table colums : excel used: excel used transfer data in database. table : destination table no.of records transferd excel to the table status : whether package debugged or not. please let me how implement this. you need gather bits of information ssis variables.  example, should have filename in variable already, , destination table name should assigned variable (if isn't already).  use row count transformation in data flow count rows , place result in variable.  don't know how collect "status" information - depends lot on package. once have information in variables, need create string variable hold insert statement.  you'll set...

Succesfully Installed SQL 2005 over Windows 2008 SP2 32 bit

i had succesfully installed sql 2005 on windows 2008 sp2 when check in start > programs>microsoft sql 2005. can c configuration tool. remaining sql server  management studio ,analysis service, documentaion tutorial, performance tools  are missing. do me out.... hi, have select features during feature selection of installation, please post setup summary.txt %programfiles%\microsoft sql server\90\setup bootstrap\log? besides, there 2 cds/folders of sql server 2005 installation media, make sure copy server folder (from cd1) , tools folder (from cd2) folder such d:\sqlserver2005\; , start setup.exe d:\sqlserver2005\servers\setup.exe. regards, chunsong please remember mark replies answers if , unmark them if provide no help. SQL Server  >  SQL Server Setup & ...

Why is my Package just stopping when going from one Execute SQL Task to another Execute SQL Task

Image
i have 1 flow constraint going 1 execute sql task execute sql task. it's executing #1 , , stops there rather continuing on execute sql task #2. why stop? constraint not conditional...just straight ole flow constraint. any appreciated , in advance help. psulionrp maybe second task disabled? color precedence constraint have? mcse sql server 2012 - please mark posts answered appropriate. SQL Server  >  SQL Server Integration Services

Unexpected function sequence error when using SQL_CO_FFO on stored procedure

hi all, in odbc program, try execute stored procedure returning unique result set, using fast forward cursor (sql_co_ffo), "function sequence error" when fetching first row. ffc forces odbc driver use sp_cursoropen, fine me because need multiple active sql statements. i appears content of stored procedure matters. when procedure implements simple select statement, works fine. when adding simple set statement or even if block, sequence error! not expected. i same problem sql server 2000 , 2005. can check if known bug? here odbc program reproduce: /*     create table t1 ( k int, c char(10) )     insert t1 values (1, 'aaaaaaaa')     insert t1 values (2, 'bbbbb')     insert t1 values (3, 'ccccccc')     create procedure myproc @key int     begin        set @key = @key - 1        select * t1 k > @key     end  */ #include <windows.h> #include <stdio.h> #include <sql.h> #include <sqlext.h> #include <odbcss.h...

Hyper V 2012 - Hyper V Manager Services Stops Every day for no reason. No specific error found.

Image
we have 2 windows server 2012 servers running hyper v 10 virtual machines each.  every day hyper v manager service stops no reason. not have virtual machine manager in our environment (saw article this).  in world causing this? crdnind pcmd ************ hi, do mean virtual machine management service (vmms.exe)? please check event log , collect possible related event logs, post further troubleshooting. a similar case, resolved after delete empty scsi controllers, may check that. for more information please refer following ms articles: hyper-v host services stop unexpectedly http://social.technet.microsoft.com/forums/en/virtualmachingmgrhyperv/thread/f450af68-134a-4bd6-8bc8-e870f03c945d event id 16000 — vmms http://technet.microsoft.com/en-us/library/dd582103(v=ws.10).aspx lawrence technet community support Windows Server  >...

Internet not working in my test lab

hi all, learning exchange 2003 making test lab setup trainsignal’s exchange 2003 video training course. please see attached picture network configuration, stuck problem not able use internet on test network. owa, , emails working fine internally of course send/receive emails outside network internet should working i’ve stuck. please let me know can resolve issue. info on nat1 pc, on second nic interface don’t know dns address should use because don’t know isp’s address, i’ve tried google’s public dns 8.8.8.8 , 8.8.4.4 still no joy. quick reply highly appreciated.   please click link below see network diagram.   http://img29.imageshack.us/img29/2742/exchagelab11.jpg   that looks little better. assuming the cable modem smc unit, disable dhcp services. puts "bridged" mode nat server handle traffic. if not smc unit, please contact cable provider on how put bridged mode. see if helps: ======...