If your looking for specific examples, go to http://www.sqlis.com. All of the tasks, transformations (above) are available here with detailed instructions.

As suggested earlier, you can pull these files down via a script task or use xp_cmdshell to build a command file for FTP and executed in a batch file (execute...

Corey Bunch wrote a good article -

http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/

"The main difference between SQL Mail in SQL 2000 and Database Mail in 2005 is this: SQL Mail is a headache and...

This post might help -

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=389519&SiteID=1&mode=1

Are there any errors in the log -

SELECT * FROM msdb.dbo.sysmail_event_log

Use telnet to verify your SMTP relay, ensure that TCP 25 isn't being blocked by an FW, anti-virus, etc.

SELECT...

"FIX: Error message when you try to use Database Mail to send an e-mail message in SQL Server 2005: "profile name is not valid (Microsoft SQL Server, Error 14607)" is...

Use nvarchar for the parameter datatype. I was able to reproduce this without error using the settings above. The table I used to test it out on -

create table...

What build are you running? Cumulative update package 4 (build 09.00.3200) for SP2 is now available. Cumulative update package 3 (09.00.3186) for SP2 has been out for while now.

http://support.microsoft.com/kb/937137

http://www.codeproject.com/sqlrs/RSPrintLandscape.asp

You can use the execute SQL task to populate an Int32 variable with the count of rows. This article has some good examples - http://www.sqlis.com/58.aspx

Your first example was correct, should be something like:

delete from TableName where (strval=?) and (year=?)

Perhaps your parameters are mapped incorrectly? For example -

Variable Name ...

Hi David, database mail in MSSQL 2005 does not require any MS Office components, just connectivity to your SMTP relay.

A couple of links to help get you started 🙂

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

http://www.sqlservercentral.com/articles/whatsnewwithssis/2234/

http://www.developerdotstar.com/community/node/364

http://www.sqlis.com

SSIS doesn't come with express, you'll need developer,standard or enterprise.

Refer to the section, "Integration and Interoperability":

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

These types of errors suggest that the disk subsystem is unable to keep up with the level of I/O MSSQL is asking. MSSQL waits and retries these requests. These errors...