Just to let you know guys do have a sense of humor also -

Why are blonde jokes always one liners?

So men can understand them too!!!

One that my oldest son presented a few years back while taking Latin.

Semper Ubi, Sub Ubi!!!!

I posted Phil's outside my cube and people stopped dropping in to ask questions!!!

You could always "cheat" and use SELECT ISNULL(somefield,'<NULL>') FROM

Good Luck,

Darrell

AJ,

Love it but I would add one more criteria

"AND Brain IS NOT NULL" 

Not a movie title but...

In the movie Hamburger Hill they talked a lot about Clusters...

Cursor of the Mummy (this also covers the SQLs - I mean sequels )

Yes I do mean more along the lines of the attributes of the text itself.

For example this is the name of a town in Cyprus "???a ?a???a ?e???ed????" (unfortunatly the...

Ajay,

This sounds like a permissions issue. Make sure your login has access to the msdb (at least to the DTS portions therein).

Good Luck,

Darrell

I can't recall having that exact problem but I have run into many strange things using text objects so I try using Bulk inserts or Openquery syntax as much as...

How about the old classic - Altered State

Unfortunately no,

I mean something like this:

Say I have a field called Greeting and it's value is Hello.

I need to be able to pass the text to some kind of function...

Bob,

Take a look at this site for some helpful ideas and examples.

http://www.sqldts.com/

Good Luck,

Darrell

You could DTS the text data into a temp table and then use an Execute SQL Task to perform the insert into the Employees table and a second Execute SQL...

Raj,

I had a similar situation a few years back and our solution was to set up SQL snapshot replication between the production and "reporting" servers. This allowed us to do...