I know this doesn't answer your question but you should use the System.Net namespace for FTP Operations. http://msdn2.microsoft.com/en-us/library/system.net.ftpwebrequest.aspx[^]

Using item still places SpcInstr in the text of the label. I am trying to get the value from the column named "SpcInstr". Any other suggestions?

Your "write access" tip led me in the right direction. Turns out "users" did not have write permission to one of the folders in the path to the database. Thanks a bunch!

Exactly what I needed. Thanks :-D

Worked perfectly. Thanks! :)

Thank you...again.

Thanks for your help. Now that I understand the choices I can decide how to set up the service. :-D

Do you have the answer?

The application sends an email using SMTP. The recipient is using Outlook.

Try here. How do you want to start your DTS Package today? By Darren Green http://www.databasejournal.com/features/mssql/article.php/1462561

Generaly when the option stict on is set you can convert value's on two way's 1- use the ctype like Dim MyDate as Date MyDate = cType(me.textBox1.text, Date) 2- Using the Cast method. I must check some things how that is working I never needed yet. I respond on this later.

Yes, each record in the text file contains a vaild date. I am testing with a small file that only contains 8 records.

well you can handle this in queryunload event. It gives you an idea from where the unload event has been called. I think rest is upto your logic. You can call the menu's click function. Or the better way is to create a common function and call it from different events. Hope that is what you are looking for. Ritesh.

It happens to the best of us ;)

Sorry for the ambiguity. Your solution is exactly what I needed. Thank You!