SSIS Tip – Save Package to MS SQL Server (Integration Services)

ben.marckTechnical TipsLeave a Comment

In order to save your SSIS package built using Business Intelligence Development Studio (BIDS) to Integration Services MSDB, you’ll need to: In BIDS, right-click the solution and select Properties Under Deployment Utility, change the CreateDeploymentUtility option from False to True Rebuild the solution Now find in your solution project folder under the bin\deployment file path an Integration Services Deployment Manifest. Right-click this manifest file and select Deploy. Follow the wizard steps to deploy to your server and choose where to save to the database. The package should then appear in SSIS in SQL Server Management Studio under Integration Services in /MSDB.

Request XML from URL in SSIS C# Script Task

ben.marckTechnical Tips1 Comment

Occasionally, I’ve needed to pull XML from the internet via an URL. This allows you to dynamically pull XML from sources than your local.In order to do so, you’ll need a string variable (to populate with the XML from the internet) and the code below in a Script Task. Every time you need to reference the XML in the variable, change your XML Data Sources and XML tasks to pull XML from a variable. string Url = (string)Dts.Variables[“Url”].Value; XmlDocument doc = new XmlDocument(); doc.Load(Url); //You can use a string here if you’d like…I pull from a variable for the URL … Read More

SQL Server Management Studio Shortcut Keys

AshokTechnical Tips1 Comment

Here are quick shortcut keys I use when using SQL Sever Management Studio’s query editor (I happen to be on version 2008 R2). Comment selection: CTRL-K, C (while holding CTRL) Uncomment selection: CTRL-K, U (while holding CTRL) New Query Editor Window: CTRL-N Find: CTRL-F (F3 for next occurrence, SHIFT-F3 for previous occurrence) Replace: CTRL-H Word completion: ALT+RIGHT ARROW List members: CTRL-SPACE Next Editor Window: CTRL-TAB (previous CTRL-SHIFT-TAB) —- this works like Textpad These are some of my favorites out of the full list of SQL Server Management Studio shortcuts published by Microsoft. More to come in an update, but wanted … Read More

Oracle BAM and SOA Suite – Potential Conflict On Same Machine

AshokTechnical TipsLeave a Comment

We had an issue where BAM stopped working after installing SOA Suite on a Windows 2003 Server (BAM only runs on Windows at the time of this writing). After trying to uninstall/reinstall many times ourselves, Oracle Support suggested that this was not a compatible configuration. We have done it before (in play environments), but this clearly can cause some issues that are not easy to resolve. So, in this case, we ended up splitting the installation to different machines and have been sleeping much better at night.

SQL Server 2005 Service Pack, Version, Edition

AshokTechnical TipsLeave a Comment

Here is how I find out what SQL Server 2005 DB I am playing with: Log into any DB in your SS 2005 instance Run the following query SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)