Script Task/Component and Template Information

The Script Task and Script component are often used by people developing SSIS packages because they are easy to use and now because SSIS could be perceived to be more developer friendly they are very powerful. That being said we should no be using them everywhere.

Sending Mail In SSIS Using Script Task- Simpler and Flexible Approach

Script Task in SSIS can provide simpler implementation of complex mail functionality in comparison to Send Mail task.

SSIS Script Tasks

RE: Problem with Dates

Why are you preparing the SQL string to be executed in your client code anyway? Why don't you use a stored procedure here?Piggy-backing on Habib, this should be interesting:http://www.karaszi.com/SQLServer/info_datetime.asp

Working with SQL stored images in ASP.net w/C#

I'm going to be writing an ASP.net app in C# that stores scanned invoice images in a database along with some other information about the invoices in the record.  If there were no images involved, I'd already be halfway done, but I just don't know how to work with them yet.  I've been working with […]

RE: 70+ columns in a single table.

indeed - you really need to look at the design. get someone who knows something about databases, lok at your data flow, create a design and implement it.

RE: How do view execute?

Worse than that, it's been my experience (in SQL Server 7) that a SELECT such as yours will create a separate instance of the view, in memory, for each named instance in the SELECT.  If the views have a lot of rows, that could quickly drive your server into a "swap file" run.  Perhaps they fixed […]

RE: PHP, MSSQL extensions connecting to SQL SERVER 2000

Cheers mate, it did help!!!!!!!! 

RE: Removing Identy using T-SQL

Are you sure?  What is the eaxct statement you used?  I see no support for this in the ALTER TABLE ALTER COLUMN syntax, and this certainly doesn't remove the property:use tempdbgocreate table test(id int identity)alter table test alter column id intsp_help test

RE: Importing Zip Codes

Insert into Zip Select ZIP, City, County, State From ZIP_CODE_IMPORT Where ID Not in ( Select ID From ZIP_CODE_IMPORT a, Zip b Where a.Zip = b.Zip And a.City = b.City And a.Country = b.Country And a.State = b.State )