I Forgot to mention that I have a hotmail account & I'm using my Account in the From & To...

I sending myself an e-mail in this case.

Thanks.

Thank you for the information.

I got the information on the outgoing & incoming sites from the following link:

http://www.emailaddressmanager.com/tips/mail-settings.html

However I had to use Port 110 for the incoming.

You are supposed...

I have been able to do this from a corporate environment using their SMTP Server.

However in this case I'm trying to do this from home running XP Pro with the...

Grant,

Unfortunately I do not have your 2008 book but I have an older one written by Sajal Dam. 😎

Regards..

Thanks everyone!

I believe that you would want to store the UNC Path in a Package variable.

You could the select @@servername statement and store it in a Package variable.

Then create an additional...

Re: Move data to DB2 on AS400 with SSIS

Try this thread from BJ Custard.

The configuration steps are as follows...

1.Create a Data Source for the AS/400, using provider NATIVE OLE...

Does your code reside in Foreach Loop Container?

Create Package Level Variables that capture the Newest File for each directory. THen compare the two variables and store the Folder & File...

Why not use OLEDB for UniData connection?

I believe the merge join will provide you with the parallell capability that you are looking for.

The Database has to be sorted in the same Order on the Fields that...

Why don't you use the OLEDB Provider for the connection to the Database on your AS400?

I have used the OLEDB for DB2, not on an AS400 platform...

As far as...

I have written SSIS Packages using named instances and it worked.

In the connection Manager Server Dropdown are you specifying the Server Name and the Instance?

YourServerName\TheInstanceName?

Is this for an SSIS Package?

Why not use VB.Net in the Script task?

There are numerous examples on the File System Object that can be found on Goggle.

I think I know...

There is an article at the following URL that list the deployment options.

It also describes the process for each method:

http://msdn.microsoft.com/en-us/library/cc966389.aspx

You can deploy SSIS packages in one of four ways:

•Use the...

Please check out Jonathan Kehayias While Loop Solution at the following URL:

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d5cb4004-02fb-4b41-a321-5197f8105941%5B/URL%5D