Use a script task in SSIS to delete the file (assumes string variables varFileDir, varFileName)

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.IO

Public Class ScriptMain

Public Sub Main()

...

See examples above -

BTW - as Todd suggested earlier, create a proxy account for this package so that the fingerprint can be stored under the proxy account's credentials (i.e. you...

Use an execute SQL task to build an SFTP command file with xp_cmdshell. Here is an example:

DECLARE @MailID varchar(8)

DECLARE @FileName varchar(100)

DECLARE @Cmd1 varchar(1000)

DECLARE @Cmd2 varchar(1000)

DECLARE @Cmd3 varchar(1000)

SELECT @Cmd1 = 'echo...

Why a distributed transaction? MSSQL will promote the local transaction to a distributed one automatically. Also,

issue this statement before you run your query:

SET XACT_ABORT ON

The XACT_ABORT option must be...

Be sure to check out DTS xChange.

http://www.dtsxchange.com/%5B/url%5D

http://www.microsoft.com/sql/solutions/upgrade/DTSxChange.mspx

Welcome 🙂

NP 🙂 Have a good one -

Use dynamic SQL - i.e.

declare @LinkedServer sysname, @SQL nvarchar(max)

set @LinkedServer = 'MYTESTSERVER'

set @SQL = 'select top 100 * from ' + @LinkedServer + '.master.dbo.sysdatabases'

exec sp_executesql @SQL

NP 😀

If you already have a mail profile created you need to execute the sysmail_add_principalprofile procedure to grant it access to the msdb database and to make it the default (global)...

🙂 that will do it every time. Put them back in the default location and apply the hotfix.

NP 🙂

The same principals apply - i.e. first ensure that your SMTP relay is listening by select start->run->cmd->type: telnet MYSMTPSERVERNAME 25

If it returns a blank command window this confirms SMTP...

Are your system databases in the default location prior to installation? Will it start in single user mode (http://msdn2.microsoft.com/en-us/library/ms180965.aspx)?

I'm running 3186 and ran into this on one of our instances. I just applied the hotfix on the database engine during the second pass without error.. Does it give...

Read up on database mail and sp_send_dbmail in BOL. There are several examples in BOL that should help get you started.

http://msdn2.microsoft.com/en-us/library/ms175887.aspx

http://msdn2.microsoft.com/en-us/library/ms190307.aspx