Tuesday, August 23, 2005 - Posts

Using the Foreach Loop with files in SSIS

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Using the Foreach Loop with files in SSIS
The new RSS feed is here

The Foreach Loop in SSIS is not the most intuitive of editors in the SSIS suite. There is a nice article on SQLIS.com, with pictures, explaining how to use it and how to use variables to set connection strings etc.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Using the Foreach Loop with files in SSIS

posted Tuesday, August 23, 2005 6:35 PM by SimonSabin with 0 Comments

Insert, Update and Deleting in a View in SSMS

Erland is looking for support on the ability to be able to insert, update and delete rows in a view when there is an instead of trigger on the view.

http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?FeedbackId=ab8e717d-8087-4337-9c27-1b4aa12a47f5

I think this is a usability issue and I find it out that MS say they won't fix it. Bottom line is anything is possible and this is just not nice behaviour in a user friendly product.

posted Tuesday, August 23, 2005 5:41 PM by SimonSabin with 0 Comments

SSIS presentation at the UK Usergroup

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS presentation at the UK Usergroup
The new RSS feed is here

I will be doing a presentation on SSIS at the UK SQL Server Usergroup tomorrow evening.

http://www.sqlserverfaq.com/

I will be doing a brief overview of SSIS and a fes of the components in SSIS. Trying to convey is power and flexibility.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS presentation at the UK Usergroup

posted Tuesday, August 23, 2005 5:12 PM by SimonSabin with 0 Comments