how often will you be loading the file? I would use bulk copy and then do the header - detail processing.

Good article. The only question I have is on the performance testing. By making the heirarchyid column the primary key you gave that method a distinct advantage over...

Grant Fritchey (3/25/2008)

---

Nice catch Jack. I just hadn't been aware of that. It's good to know because it's the kind of thing that can lead to a lot of confusion....

According to the article noted in my previous post, if you are running the sp from SSMS, Query Analyzer, or using .NET with a commandtype of text you will get...

Lynn,

Thanks for the information thus far. It gave me some things to look at. Unfortunately none of them actually worked. I can live without the reply to,...

Okay here is another follow up. On my 32-bit laptop running 2005 SP2 developer edition I changed the service to run under my login so there would be a...

If the source data has a length of 6 shouldn't the destination have a length of 6? Is the actual data guaranteed to be only 5 characters? If...

In my understanding Unicode characters are extended characters. From BOL:

The Unicode specification defines a single encoding scheme for most characters widely used in businesses around the world. All computers...

Kimberly.Hahn (3/21/2008)

---

Its not just procedure names that should be capitalized properly and prefaced with the owner/schema to optimize cached plan re-use. The tables referenced within the proc also should...

Thanks Lynn.

So your Services account has email setup on the exchange server? I don't think at this point mine does because I really didn't foresee a need using Database...

What schema is it in and what is your default schema? Maybe SQL is checking in the default schema and then finding it in the qualified schema.

Could be a...

Have fun officiating. I used to that quite often as well. I thought DBA's were supposed to be geeks!

If you could post the setup I'd appreciate it. ...

According to SSIS help the correct function is GetDate() so this should work:

("DS_Trouble_Ticket"."RD-CD">=GetDate() AND "DS_Trouble_Ticket"."RD-CD"< DateAdd(DD, -1, GetDate() )

Good question. Are you getting the data in subscript notation? I would have to guess you would need to use unicode (nchar, nvarchar) as a start.

You can compare it to System.DbNull.Value and then convert it to String.Empty.

IIF(parameters.yourdate.value = System.DbNull.Value, String.Empty, paramterd.yourdate.value)