Looks like SQL 2000 used to have an xp_readmail command but depreciated in SQL 2005.  I've found a few .NET scripts and SSIS. However, the simplest solution looks like Pragmatic...

This may be due to Verbose logging being turned on for SSISDB. Right click SSISDB under Integration Services Catalog and select properties. Change Verbose to Basic.

One big caveat is the size of the datasets being used by CTEs. Be very cautions for two reasons: recursive CTE can blow up your temp db when large datasets...

The most important concept here is that a responsible DBA should be monitoring the health and activity of the data servers proactively. Over the past 10 years I have seen...

SELECTTOP 100 (select count(*) from X) AS Total_Counts,

*

FROMX

At the last three jobs I have had as a DBA I have set up “Dashboards”. The first was an ASP page that connected to each data server and executed...

I received and tested a hotfix for this problem today. Per Microsoft: “this fix is available… it will be documented in our knowledge base using article number 935843 and...

I have an open case with MS and am waiting for a resolution. I will post additional information as is becomes available.

A poorly worded question which implies *mdb is a supported file format.

That's where I am having the issue. I have tried to copy the ActiveX script into the script component but it looks like the language/format is different.

How is the Sys Admin changing the name? I have had similar issues and found that if I opened the current package and saved it under a new name the...

Have you tried creating a Linked Server to AD?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp

EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource'

GO

EXEC sp_addlinkedsrvlogin 'ADSI', false, 'DOMAIN\Administrator', 'CN=Administrator,DC=DISTINGUISHED_NAME,DC=com', 'PASSWORD'

GO

You can also use an Active X Script task in DTS to delete the file:

'**********************************************************************

'  Visual Basic ActiveX Script

'************************************************************************

Function Main()

 Dim fso, filespec

 Set fso = CreateObject("Scripting.FileSystemObject")

 filespec = \\Server\path\file.xls

 If (fso.FileExists(filespec)) Then

      ...

Have you tried SQLPing?  http://www.sqlsecurity.com/faq.asp

or isql -L or osql -L ?

Why don't you make the BatchID column and INT IDENTITY(1,1), that way any insert would autmatically increment the BatchID by 1?