Are you attempting to log Windows authentication? Or attempts to access SQL Server? I am confused by your scenario... can you provide more details?

Please see Microsoft article 281517 (http://support.microsoft.com/default.aspx?scid=kb;en-us;281517) for more information about this issue.

Other references:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=160515

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=107172

With Security Auditing enabled (http://support.microsoft.com/default.aspx?scid=kb;en-us;300958), you will be able to track logon attempts regardless of whether or not the user is logging in locally or remotely through the network.

Don

Not sure why you would need to report the package as successful if there is no file found. Sounds like it should be reported as a failure.

Personally, I would...

Well, ummm... it helps if I check which forum I am posting to.   Sorry, I didn't realize this was for SQL 2005. Not sure...

In EM, right-click the package and select Delete. If the option is not available, you do not have rights to delete the package.

Tom - As I understand your question, it looks like you have three text sources in your DTS package which are then attempting to populate a table using a Transform Data...

Jan - I misunderstood your original question. Kudos on the work-around and thank you for posting it on the forum.

 I did, however,find a Microsoft article (Article 299410) that specifically addresses...

This may be what you are looking for:

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

'  Visual Basic ActiveX Script

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

Function Main()

Dim oPackage

Dim oTask

Set oPackage = DTSGlobalVariables.Parent

Set oTask = oPackage.Tasks("DTSTask_DTSExecuteSQLTask_1")

oTask.Properties("SQLStatement").Value = "SELECT...

No problem   Now if you can only send that email...

Vinny is right. ADSI is limited to returning the first 1000 records without paging. Here's a Microsoft article for reference:

http://msdn.microsoft.com/library/en-us/adsi/adsi/paging_with_idirectorysearch.asp?frame=true

Quote from article:

"Searches of the Active Directory performed without...

You would think it would be stored in the "Stored Procedures" portion of EM. However, the procedure is actually listed in "Extended Stored Procedures".

The xp_sendmail SP is located in the master DB. For more information about this SP, enter "xp_sendmail" for the keyword in an index search within SQL Server Books Online.

Here are the...

Use the TSQL command "WAITFOR". For a 5 second delay, place this line in an Execute SQL Task:

WAITFOR DELAY '00:00:05'

SQL Server Books Online discusses this command in more...

I ran across the following newsgroup discussion regarding SQL's lack of LEAST and GREATEST functions. Perhaps this will better answer your question:

http://groups.google.com/group/mailing.database.pgsql-sql/browse_thread/thread/a6386aca9b0a55ce/81a9b83e8de82183?lnk=st&q=sql+least&rnum=1&hl=en#81a9b83e8de82183