25 Nov 2010 00:00
Slightly before the announcement of StreamInsight being available for Linqpad I downloaded it from here. I had seen Roman Schindlauer demonstrate it at Teched and it looked a really good tool to do some StreamInsight dev. You will need .Net 4.0 and StreamInsight installed. Here’s what you need to do after downloading and installing Linqpad. Add a new connection The next thing we need to do is install and enable the StreamInsight driver. Choose to view more drivers. Choose StreamInsight Select the driver after install ... [More]
9 Jun 2010 14:41
Published today on CodePlex is the SSIS Expression Editor & Tester project. If you want to try it just pop over to CodePlex and download it. About five years ago I developed my own expression editor control. It first got used in our custom tasks as the MS editor didn’t become available until SQL 2005 SP1, but even then it had some handy features I preferred. For example resizable panes so that if your expression result was more than two lines you could see them all. It also meant I could change the functions available in the tree view, the most obvious use being to add some handy snippets... [More]
3 Nov 2008 22:04
How can you backup your SSIS packages? I've been asked several times, and the answer is it depends. Where do you store your packages? SSIS Package Store The SSIS package store is just a folder on disk, so regular file system backups should suffice, or you can backup that folder specifically. By default it is %ProgramFiles%\Microsoft SQL Server\90\DTS\Packages. It is possible that multiple folders can be used, or the default is changed. This can be explored further by reviewing the SSIS service configuration file %ProgramFiles%\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml. For more in... [More]
27 Aug 2007 14:00
We see this coming up quite a bit on newsgroups and even have people eMailing about it so we though we would put up an article explaining where to find packages when saved to SQL Server.
If you want to view them visually in SQL Server Management Studio then you will need to connect to the Integration Services Service for the Server on which you have stored the packages.
Below is an example of us connecting to the service by first opening up Object Explorer and then connecting to the Service by choosing it from the dropdown menu and then using Integrated security (no choice here) to... [More]