From BOL ( index=datetime data type, overview)

datetime

Date and time data from January 1, 1753 through December 31, 9999, to an accuracy of one three-hundredth of...

"DBProcess dead or not enabled" is usually caused by network problems. It is a client-side error that occurs when the connection to SQL Server is terminated unexpectedly (from the client's...

You can try running this code. The table name here is TXT. The column name is TXTCOL. Change those values as necessary. There are limitations, but at least you can...

Another thing to check is that, since the date is returned as character data of the form dd.mm.yyyy (using style 103), it won't sort correctly unless converted back to a date...

If you absolutely must implement your design, you could try using a trigger to enforce uniqueness for non-null values. See the basic example below. Note that in this example, if a...

Sorry, I typed the assignment operator ( = ) instead of the equals operator ( == ).  Corrected code is shown below:

function Main()

{

  var c9 = DTSSource("Col009")

  var c10 =...

Hmm..that is strange. Is DTS returning the string "null"? Maybe you could try something like this:

function Main()

{

  var c9 = DTSSource("Col009")

  var c10 = DTSSource("Col010")

  if (c9 == null || c9...

Actually,I'd use both checks to be safe:

function Main()

{

  if (DTSSource("Col009") == null || DTSSource("Col009") == "")

  {

    DTSDestination("CLO") = DTSSource("Col010");

  }

  else

  {

    DTSDestination("CLO") = DTSSource("Col009");

  }

  return(DTSTransformStat_OK);

}

Mike

Is your server security (in EM, right click on Server, select server properties, then the security tab) configured for mixed mode? Maybe it's setup for "Windows Only" and 'jules' is...

How about something like this:

function Main()

{

  if (DTSSource("Col009") == null)

  {

    DTSDestination("CLO") = DTSSource("Col010");

  }

  else

  {

    DTSDestination("CLO") = DTSSource("Col009");

  }

  return(DTSTransformStat_OK);

}

Mike

The first thing I would do is go to Control Panel | Date/Time and make sure the date, time, and year are correct. Also, make sure you've got the correct time...

IsNumeric() checks to see if the string can be converted to one of the numeric data types, which includes int, float, money, and decimal.

BOL says:

"ISNUMERIC returns 1 when the input...

What's happening is that if the string contains one D or E, then SQL Server treats the string as scientific notation. If you cast as real, you'll see the range...

A couple of thoughts on this:

When using Power() with bigint, ALL parameters must be bigint, so as coded you will probably get arithmetic overflow errors when @nPosition is > 30.

Cast...

Seems like all you are asking for is a single file search-and-replace utility.

You could use munge.exe if you've got the Windows NT Resource Kit.

I wrote a utility called frep.exe a long...