hi, I had similar problem a few years back... if im not mistaken, it all depended on the driver used to set up the linked server.

if used Microsoft driver (ODBC)...

Hi all.

Can`t get the mail to send the body of the msg.

Everything else works ok.

Any solutions?

HI I'm using this simple code and it works fine for me. Been using it for more than 2 years and never had a problem.

Good Luck.-

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE...

I've had the same problem.

Solved using a Job as you need to do.

1.- in the SSIS package do save copy of package as.....

2.- Package Location= SQL Server

3.- SSIS Package Folder...

Just wanted to wish you guys the best of lucks. You've helped me solved everydays problems in a quick and easy way.

once again thanks from a humble reader from Argentina.-

Regards...