Luke Hayler - SQL Server developer

It’s almost time for another SQLBits, and in my [humble] opinion, it’s not soon enough. These free conferences are fantastic and if you do have the opportunity to attend I suggest you do so. Whilst I have only a small idea as to what goes into organising a conference, I am pretty sure that it [...]

 
OLE DB Source Adapter
The OLE DB source connection has several Access Modes:

Openrowset
Openrowset From Variable
SQL Command
SQL Command From Variable

For now, I am going to focus on the SQL Command options. Using the SQL Command Access Mode requires you to set the SqlCommand property (typing in your SQL query directly), effectively ‘hard coding’ [...]

This is the second part in my recap of SQLBits V. You can read Part 1 here.
Sessions
I was assigned as a room monitor on the Saturday, and as 3 of the sessions I was planning on attending were in the BI track, this is where I ended up. The day for Room 1 went as [...]

SQLBits is almost upon us. In less than 10 days, around 400 people will be descending on the Celtic Manor in Newport, Wales for the 5th instalment of what I am led to believe is a first rate conference. Great speakers, great sessions, awesome venue, _____________ attendees. That space is intentional. I plan to fill [...]

Technorati Tags: Trouble shooting,Informix,SSIS,database connections,ODBC connections
I have been setting up a number of ODBC connections in the last few days, that are to be used in an SSIS package. The connections enable me to access a number of IBM Informix Servers in various locations (DR & TEST sites) and extract specific data for reporting. However, [...]