No dont include the angle brackets I only put these in as a place holder. You only need single quotes around the data source nothing else.

This is the code I used. I've removed certain parts for security.

EXEC master.dbo.sp_addlinkedserver @server = N'AS400', @srvproduct=N'DB2OLEDB', @provider=N'DB2OLEDB', @datasrc=N'server to link', @provstr=N'Provider=DB2OLEDB;Initial Catalog=<'initial catalog'>;Network Transport Library=TCP;PC Code Page=1252;Network...

I haven't done this myself has I normally put a generic message in the e-mail. But just had a quick look give this a try and see how you get...

That is the less code intensive way.

Click on Event Handlers then on the link that says 'Click here to create an 'OnError' event handler

Drag a send mail task onto...

SSIS will consume resources, but so would a application written in C#. The beauty of SSIS has Jack has already stated that it comes with everything you need to get...

How about creating an OnError event and placing the mail task here. This what I do to notify me when a package has failed.

You need the Enterprise edition of SQL2K5 in order to use the DB2 OLEDB provider.

In order to move through the tree view of tables (which is what I assume you...

Yeah I did get it working in the end although I'm still not sure of its performance.

What version of SQL Server you using? If its 2K5 Enterprise then download the...

That works, thanks Phil!!

Are the servers all the same spec and config i.e W2K3? One thing that springs to mind is do you have AV software on all servers? It could be this...

[/quote]

Which doesn't really help me decide. Why is it "better" to truncate when it's "cleaner" to drop and recreate? What I'm really looking for is thoughts on best...

You may be able to use the Data Conversion transformation to write an expression that gets you the datepart of the date. Or failing that, how strong is your .NET?...

Can you provide some more info like have you moved from a dev server to a production server. And what is the SSIS package doing exactly. It could be there's...

Just to clarify the SQL we use against the linked server is

select * from AS400.S65930BF.MMPLPLIB.afilename

The descriptor I used for the filename part of the query was omitted when I...

I've had another go at creating a linked server this morning. Now on our old SQL Server 2K box the linked server is configured using IBM's own ODBC client access...