Gail,

Thanks. I don't know what the heck I was thinking there. My bad. :blush:

Rich

Two things come to mind. First, you don't mention if you are doing the log backup with truncation. If not, then all transactions will remain, as the default is without...

That is correct. Each Unicode character takes 2 bytes of storage (2 8-bit words) and each non-Unicode character takes 1 byte (1 8-bit word) of storage.

rtelgenhoff (10/1/2010)

---

It's interesting that even though the first INSERT statement is not part of an explicit transaction, the ROLLBACK inside the trigger negates the INSERT. If there was no...

I found the question a little misleading due to the fact that you are assigning the trancount to a variable prior to the insert. If you inserted @@trancount DIRECTLY into...

Hugo Kornelis (9/24/2010)

---

tommyh (9/23/2010)

---

Have to agree with UMG Developer. The "Multiple identifier columns" shouldnt be part of the answer for 2 reasons.

1. Its not part of MS recommendations (atleast not...

Create a temp table and do a bulk insert from the txt file. Then do as the above suggested, joining the tables together.

Create table #emailaddys (address varchar(100))

bulk insert #emailaddys from...

Thanks for posting the resolution. Very few OP's do that, and it's also a learning experience for other folks when you know how it got fixed.

@OP - Are you connected to multiple services in Object Explorer? Maybe SQL Server, Analysis Services, and Integration Services? If so, then it COULD be that you have SSAS highlighted...

Agreed. But, I have spent a fair amount of time with it, just sometimes forget that there are some "quirks" that can get in the way of doing something which...

:ermm: Phil, my apologies.

Should have tried it a little more before I ASSUMED that SSIS would be logical. Guess it's not as straight forward as I thought.

Rich

Sure you can. Configure the DataSource for where the data is coming from, and then configure the destination, setting the DataAccessMode to be TableNameOrViewNameVariable. Create the variable at the package...

Ummm... No.

Use an ExecuteSQL task to create the table, then a DataFlowTask with a...

Yes, you can use an Execute SQL task, and that is probably the best way to accomplish it.

Paul White NZ (7/20/2010)Seeing as I am now in picky mode (you started it) I'm going to say that a filtered clustered index is possible (in a sense) just create...