In the error output of the OLEDB dest, are the error columns not populated? They normally give you the reasons.

If not, the easiest way would be to push all the...

Either SSIS is very confused about the data type mappings or the columns you are referencing are indeed, Nvarchar.

Does the package run if you run it as a file and not from msdb, on the server, under the same context as agent?

Why do you hijack this thread as well as posting the question in two other threads???

Ignore this: asked and answered in another thread.

You could have the package watching for the file. See FileWatcher task on http://www.SQLIS.com

Or you can execute a package through CMD DTEXEC /File "path to dtsxfile" /plenty other options

This is a common situation and easily solvable.

The simpliest way would be to loop over the sheets in the file. You DF would be inside a for each loop.

The best...

The best option, as suggested, get the source right. of course, this is not always easy.

An option would be to use a ragged right. Split on the first comma or...

Use the Execute Process task.

Ok, if I put DTC in the cluster group, it will not work. if I put it in the SQL group, it works.

While it is ok that it works, I...

I have been searching this site, MSDN and google for days now with this issue. There is nothing I can find that I have not yet tried.

Noel: I have already...

I may be wrong but I had a similair thing. What had happened in my case was row 10 had a space in one of the cells. SSIS would then...

I am curious though why you ask this question in a SSIS group. Are you loading the values from a source then into a table? If so, why do a...

There is an error in the package. Any errors occurring during the process do not get passed back to agent. You have to enable logging in the package and view...

it runs under the same context as the package which is either you if you running it or agent if scheduled.

The package will run fomr where you type the command. You cannot run a package on another server through DTEXEC. Run as in: The process will be on server b.

You...