What I would do is break this up into two triggers; one for update and one for insert.  The insert trigger would contain the insert logic; the update trigger would...

Most likely your administrator is smart and locked it down (imagine someone running "del c:\* /F /Q").  You've got very precise instructions on how to set the job up and...

A DTT has two parts...a source and a destination.  The source and destination of your DTT can be Text, Excel, or any ODBC data source (and probably some others I'm...

You can definitely use a SQL task to create a table as the 1st step of the import, then another SQL task to drop the table at the end.  The...

No, don't use a temp table...use a real life "Staging" table.  Use the "DTT" in DTS to import the file into a staging table that exactly matches it (this makes...

SQL2K does not allow local variables of text type.

declare @test-2 text

Seems like you had some non ASCI characters in the file.  OEM characters are...well...here, read this:

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarsqlsg/html/msdn_interntl.asp

It doesn't seem to be a SQL issue, sounds like a sqloledb issue since it worked in ODBC.  I don't see any obvious problems with your code, but I'm no...

Pretty good article.  A great solution you came up with; probably saved a lot of database overhead by using an array.  I know this is against standard practices, but I...

Wow, out of respect for the dead I was going to post something nice about Reagan,(History will remember him kindly...blah blah), but that doesn't reflect my true feelings about the...

Here's the most elegant way to do this, but it requires a identity column:

Select *

from #Table t

where ID in

 (Select top 2 ID

  From #Table t1

  Where t.Name...

You could use something like this:

--Use to lookup all columns in Table

select  sc.name, st.Name as DataType, sc.length,

 Case isnullable

  When 1 then 'YES'

  Else 'NO'

 END as isnullable

from  sysobjects so (nolock)

JOIN syscolumns sc...

Wireless guy,

What method did you use to define \\server\share ?  I've been having major problems with this, even when mapping a drive to it.

Working with Text data is a whole 'nother ball game.  Updating and parsing text data types uses a bunch of special functions, so check BOL for more data.

Personally, I use...

Here's an example of how to loop through a table and put all the values in a row into a string.  definitely do not use a cursor:

create function Column_CSV (@TableName...