The service pack should include all the relevant component upgrades, including SSIS. If yours didn't upgrade properly, this tells me either your SSIS is on a different server or...

You could read the record sets to an ADO recordset in your dataflow, then use rowcount variables (there would have to be 7) in the same dataflow to count each...

The .dll might need to be registered in your server.

Open the command prompt. Type in regsvr32 (flag list) (.dllname)

The flag list is as follows:

/u Unregister Server

/s Silent; Display no...

The simplest way is to use 2 queries in an IF / ELSE statement.

IF X = 'TRUE'

Begin

Select * from TB1

End

ELSE

...

Dean,

You are missing table aliases in your code. Look for every instance of the table name in the FROM statement or the JOIN clauses to make sure that you...

I'm actually playing with the VNF right now with my DW solution. I've just started altering the schema and doing the coding. I'll keep everyone updated as to whether or...

Definitely put together this utilization stuff for an article, please. That would be FANTASTIC.

And if your tempDB is full, no query you write on that SQL Instance is going to work. All databases utilize TempDB to some extent (even if you don't...

Dean,

Unfortunately, a generic "I'm getting errors" doesn't give us anything to go on. We're not going to do all your work for you. If you want the correct...

It Depends... (a DBA's favorite answer).

There is no right or wrong way in this situation. There is only your situation.

My advice is to set up a job...

GilaMonster (7/24/2008)

My main system is more a datawarehouse than anything. It grows and...

20GB should be fine so long as you don't put any SQL Server databases (including system DBs) on your C: drive.

Usually I reserve C: drive for the OS and for...

Gail,

AHHH. We're not encountering latch errors, but I haven't split the TempDB for the same reason I haven't split out other DBs. It didn't make sense from an...

Sheer laziness or the inability to properly determine the growth rate of your DB. @=)

Actually, our unrestricted DBs tend to be in our DEV environments where we're unsure of...

SOX compliance....

Here's what you need to do. Be warned, it is TEDIOUS and work intensive.

First, list out every account you have in SQL Server with that account's permissions and db...