Thank you both. You have saved me a mammoth task. I will have to tell my manager that I won't need need the budgeted amount of time to complete the...

I presume you are sending the mail from xp_sendmail rather than through vb...

If so, maske sure the account that sql server agent runs under is associated with the mail account...

You can write a vb macro to do this for you. Or as I said before, import the entire set of data into a staging table, delete the first row...

In that case I cannot see why it is failing. Hope someone can help you out on the forum. I can only suggest looking for a hidden parameter in the...

Are you able to dts the whole lot in after deleting the first row using the same function (ie - including the skip row statement)?

I am guessing that you are importing identically structured files one after the other. If that is the case, rather than have 20 connections etc, see this link. Easy to...

I can tell you for a fact that there is no limit of 254. I ran the same job for a flat text file that recorded web activity for a...

Many ways to skin that cat:

1. Put the data into a staging table and then use that table to import into your live table using <> 'the string that is...

Where does the vb module reside and what application is it attached to?

If it is word or excel, you just need to open the application from a batch file called from your...

Creating a trigger is simple and if you check sql books on line you will see plenty of examples.

To send the mail I would use xp_sendmail. Again check bol for...

If you have not had any real exposure to using vb with packages then the first port of call should be the site http://www.sqldts.com

If you search the site, you will...

If you want to debug the stored procedure, perform the following:

Go into query analyzer. Hit F8 to make sure you have the object browser open.

Then find the stored procedure inn...

If the definitions reamin the same, take a look at the data inside. Possible this is causing you an error.

Try copying one column at a time until you find where...

This is the number one spot for dts tutorials. There are gazillions of articles that are explained very well step by step.

http://www.sqldts.com/

You will need to create the excel object in an activex script. Then refer to the excel model to find out how to output text to headers and footers.

To get...