July 2013 Entries

SSIS: My Toolbox is Missing!
I work with BizTalk (BTS) and SSIS frequently. In one of my environments, whenever I've programmed in BTS, then jump back to SSIS, the SSIS toolbox is missing in action. Here's what I do to solve the problem in that environment:Save the application and close Visual Studio.Go your AppData\Local\Microsoft\Vis... version]Rename the *.tdb files there to something else like *.tdb.xOpen Visual Studio (Note: You will see the progress status bar re-initializing all available toolboxes.)Open ......

Posted On Thursday, July 11, 2013 4:19 PM | Comments (6)

How do I know what Version of BizTalk is on my server?
There are 2 ways to do this, the first is to query the BizTalkDBVersion table:use [BizTalkMgmtDb]goSELECT DatabaseMajor, DatabaseMinor,ProductBuildN... ProductRevision FROM dbo.BizTalkDBVersion; Here is a list of possible BizTalk versions (CUP = cumulative update package, SP = service pack) :BTS20043.0.4902.0BTS2004SP... 3.0.7405.0BTS2006 3.5.1602.0BTS2006R23.6.1404... 3.9.469.0BTS2010CUP13.9.522... ......

Posted On Tuesday, July 2, 2013 5:59 PM | Comments (3)