When using custom components like this, how can you deploy the SSIS packages to a SQL Server? Does the custom compenent also need to be installed on the server?

My team...

As part of a development team we have shared DBA resources, and cannot access most of the "good" stuff about the server ourselves. That being said, we do have a...

BIDS 2005 requires you to run the entire package to be able to debug using breakpoints on a script task. If you try to just execute the script task by...

Something I've done in the past is nested for each loops. We frequently need these types of reports, or we need to search SPROC definitions for certain key words (or...

To help prevent column additions from messing you up on the source side, you can specify the columns to pull in your select statement rather than running a SELECT *...

We have had to do this in the past, and what we do is:

1) Build a .xlsx template and store it in a "Templates" Folder on our destination server. We...

CTE might be the way to go here. You can use your same queries and just wrap them:

;WITH T1 as (

SELECT b.name as BU,

lsbd.bus_date,

lw.name as 'Workgroup',

SUM(lsbd.lab_sc_hs_qy) as 'Schd Hrs'

FROM t_wh..f_gn_lbr_sch_bu_dy...

You could use CROSS APPLY with HASHBYTES to do a comparison of the rows. As long as you have some sort of unique id that would help you identify where...

I guess it is easy to see how wide the definition of "easy listening" is in the grand scheme of things... that being said my top 5 are:

Metallica - ...And...

I checked the logs yesterday and it shows that each backup job is completing successfully. I just cannot figure out why the job will not move to complete in the SQL...

Yes, this job was created from a maintenance plan to back up the transaction log every 3 hours. Could that be part of the problem?

Upon further investigation, it appears that the job is completing properly and saving my backup file. However, the job will not finish and be marked as complete to allow it...

I found a few blocked spids on the database when the jobs where getting hung. It appears that some indexing may have been causing this problem.

The database that I am...

be sure to link the other SQL server to the server that will be executing the query. 

So for your example, if SQL1 is the other server and you want to...

The above command will only work if you have already created the table. After you link the server using sp_addlinkedserver or add the linked server in Enterprise Manager run this...