Archive | October, 2008

Cross Page Posting in ASP.NET

I answered a question on the forums today with someone asking about the PreviousPage property that we have access to now. Basically, the question was Okay now I have the previous page but I want to cast it to that partial class type and it says it can’t find it. So if we have a […]

Read more

SMO Tips & Tricks: BEWARE the scary Connect option!

So if you are playing around in the SMO codescape you may have noticed the in the server object you have a connect method available …specifically Server.ConnectionContext.Connect While it may seems perfectly reasonable that you would want to control the destiny of your connection object…you will want to be wary. The Server Management Objects do […]

Read more

SMO Tips & Tricks: Improving SMO Performance.

One of the few limiting factors with SMO is that if you do not know what you are doing and iterating through large numbers of databases it will seem extremely slow…..If you would look through profiler you would see why. Everytime you call on an object property it makes a new call to the database. […]

Read more

SSIS Tips & Tricks: Easiest way to implement SFTP

So if you are trying to use SSIS to do SFTP for a project and do not have a budget to just go out and buy a widget then here is a pretty quick solution for you. 1. Download and install WinSCP from here 2. Create a stored session for the ftp session. This is […]

Read more

Using SMO Part I : Enumerating Servers

I should be posting a couple of different smaller application that I have had to code in the last week or so to help me out with things at work. Both demonstrate the amazingly helpful architecture of Server Management Objects(SMO) to help automate some otherwise daunting tasks. I thought it would be helpful if I […]

Read more

Clustering SQL Server 2005 Integration Services

For those of you that have ever clustered SQL Server 2005 before. Here is a good reference from Microsoft about clustering Integration Services. As you may well know, Integration Services is not ‘clusterable’ out of the box during the installation which is kind of a drag when your trying to pitch Integration Services as part […]

Read more

SQL Server 2005: Using Web Services in SSIS Data Flow

Here is a good trick.I have used this to teach people how they need to ensure that they know what limitations there are in SSIS. Basically, if you are only using what SSIS, or any system for that matter, gives you out of the box, then you are missing out on large opportunities that can […]

Read more

Writing to a Variable in SSIS Script Component

Someone had asked me over the weekend a very interesting question. They are needing to grab the values from a particular column and then input them into a series of variables. 1 column entry = 1 variable. They were wondering how to accomplish this with SSIS. So I thought I would blog a simple solution […]

Read more

IndyTechFest 2008!

Well for those of you whom decided to miss IndyTechFest because you slept in on Saturday missed out on one hell of an event. With about 500+ people in attendence this was one of the most electrifying events of the year and it’s good to see Indy flexing its IT muscle. I am trying to […]

Read more

SSIS: Using IF(IIF) logic in Derived Column

Just a short reminder for myself really. A lot of people tend to use a custom script in order to accomplish this logic simply because the interface for the derived column data object simply does not spell out how to accomplish this. In order to place an IF statement for the derived column you would […]

Read more