The Wrox book "Professional SQL Server 2005 Integration Services" by Brian Knight, et. al. has 2 chapters devoted to creating custom components for SSIS.  However, it requires Visual Studio, and...

This happens occasionally on one of our older SQL servers.  I will find one or more SPIDs associated with the Backup / Maint Plan that are still active.  Usually if...

I was very comfortable with SQL 2000 DTS.  I had to write an SSIS package for the first time a couple months ago and managed to struggle through using Books...

Here is a link to IBM's site for DB2.  We use DB2 v8 on AIX.  Not exactly what you're asking for - but maybe a place to start.

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp

I also...

One difference that I'm aware of, and I believe it's still the case, is that the feature pak add-on for SQL 2000 DTS packages in the SQL 2005 environment is not...

If you decide to go with a commercial product rather than something home grown, you might check out the SQLdm (Diagnostic Manager) product from Idera.

http://http://www.idera.com

I am currently using it...

I have an MCSD cert and I am 1 exam away from an MCDBA cert.  For those I have relied upon Transcender test prep materials with good results.  Of course...

A quick Google search seems to point toward a corrupt MDAC - but perhaps you've already gone down that road.

If not, here is a relevant link I found:

http://www.dbforums.com/archive/index.php/t-322712.html

I also have to address some SOX issues.  I plan to look into the Idera "SQL Compliance Manager" software.  I haven't evaluated it yet, so really can't offer any opinion....

I have a similar situation.

I plan to look into the "SQL Compliance Manager" product by Idera. I haven't evaluated it yet, other than reading their datasheet, so I can't offer an...

The vendor of our core mainframe system has provided daily snapshots of data in MSSQL.  We want to use these snapshots to recreate some of the custom reporting currently done...

Easily.... No. 

You can enable the "Audit-Level" server property to record logins in the SQL Server log and Windows Application Event Log.  Then you would have to parse and analyze...

Some other possibilities:

Have the permissions of the SQL Server / SQL Agent services login been changed? Maybe can't access the network share any longer?

Is there a hung process from the...

This issue is a pet peeve of mine with several of our vendor supplied applications.  I'm talking about transactional systems and DSS systems where 95% of what they do daily uses...

If you want to create the verbiage in SQL using similar If..Then logic then you probably want to use the CASE function in your query. You can find further info...