Sounds like a password issue. If it is, here are two options.

1. Set the password for the FTP Connection in a Script Task before the FTP Task.

2. Use a...

Could be wrong, but that Test button in the Agent properties looks to be for SQLMail only. I checked on a SQL 2005 SP2 and SQL 2008 CTP instance;...

Don't know about the log, but if that's the DELETE statement it's removing all your current records and leaving the ones older than 6 months.

To update all the records you could place your selection...

For .mdf, .ndf and .ldf files there's the sys.master_files catalog view; the size column is in 8KB pages.

For .bak there's the msdb..backupfile backup history table. That would show where...

Check how many files make up your database and the original locations.

RESTORE FILELISTONLY FROM DISK = 'C:\myBackup.bak'

Then check to see if any of those files are in use by another...

If you're trying to update a part of the bspid column and maintain other parts of it then you could update like this.

UPDATE TableA

SET bspid= REPLACE(bspid, 'CI11','CIRC')

WHERE bspid LIKE '%CI11%'

In SSMS, connect to Integration Services from the Object Explorer. Under Stored Packages expand MSDB, right-click on the package and export.

acrouch (4/16/2008)

---

...if I close the connection manager properties dialog box and open it back up again, it the "password" box is now blanked out and it fails to connect...

How about creating a new junction table that has the rows you would normally join on?

SELECT ...

FROM

(SELECT t1.custid, t1.skillid

FROM

(SELECT t2.id AS CUSTID, t3.id AS skillid

FROM customer t2

CROSS...

To load a single XML file drag a Data Flow Task onto the Control Flow canvas. On the Data Flow canvas add an XML Source and a destination.

If...

How about checking the active TCP endpoints external of SQL to get the port? Use something like TaskList to get the pid for the SQL service and Netstat to...

Why not ask you administrator for the password?

Since this sounds more like a problem with ePO than SQL, check the knowledgebase at McAfee support: https://knowledge.mcafee.com/SupportSite/supportcentral/supportcentral.do?id=m1

After awhile you might find SSIS is actually fun to use. There's two overall steps here, creating the package and deploying the package. Scheduling would the another step...

A good way to get an indication of whether the server is running and accepting connections is to just run a query against the master database from within your script....