Do you have SQL / SSIS installed on machine? in VS: Menu > Help > About. See intergration services there?

Nothing to do.

A package is just a set of instructions for the service.

If you have any custom components, you will have to move them.

Only problems is with JET (EXCEL)...

For the date column, use a data convert component. Redirect failures into a union all.

Put a conditional split after the conversion and do a check for invalid values in the...

You _could_ do it with a code like VB or c#. Personally though, I would not.

Not SSIS.

You could do it with BCP but your table columns / file columns will have to be aligned.

i.e.

File:

FirstName|LastName

would not do into a table with

LastName|FirstName

Asking to import any file...

Use a variable to hold the first part, use expressions on the filepath and email to build up the correct value.

What is the maxErrorCount set to?

If you run the package through cmd, what is the result?

"Have you rebooted your machine?"

Do let us know what they say (After the above)

Not a job for ssis. You could do it but it would be a convoluted way. Look at using VB / c#. You could do that from within ssis even.

Not...

grasping at straws here - can youo change the destination to a SQL table (a empty copy of the first) and see if that runs. Then we can either confirm...

You _could_ do this in ssis but it seems more a job for an application though.

There needs to be more info provided though as to what you want to do....

Yup. That's what I was trying to say earlier. It seems pointless though that a packages HAS to be in a solution to work. But, it does.... Ho hum.

Glad you...

I disagree with Phill onn that one. I have many cases where it is working just fine with the full path to the bat file.

In anycase - I can...

NP

What surprises me was the lack of timeout or did you cancel it to quickly. I believe it is 30 second. (I guess I would have canceled it too)

just a thought - how about another batfile which does a MD or something else simple. Rulle out any prompting from your file.