You have to do this in BIDS. I do not believe the import wizard gives you much flexiblity.

You need to use a derived column and then use split string...

Using a data flow and a EXCEL source, import the two tables. Use a merge join to join the two flows into one.

Sorry, is slightly different for components.

You should do it nin the preexecute of the component.

Public Overrides Sub PreExecute()

Dim...

Config files set the variables / properties at runtime. When you open the package with the config file valid, it will alters update the properties. It does not harden the...

The property is on the connection manager, not dataflow.

If you suspect date columns, they are obviously dates which ssis does not mind but SQL does. I have had this in the past with dates of 1 Jan 1020...

If you set your dest to be table (not fast load) and redirect any errors, does that give a hint? Other wise the slow method of column by column 🙁

As...

For the benefit of others, what was the problem?

You have to have a physical XSD I'm afraid.

You can set this via a config file or a variable / expression.

You can also provide an URL for the XML filename...

For crying out load - use BCP. It is not "not format friendly" what it is, is beyond your currently skill level. This can be changed by doing some reading....

I do not believe cmd or ssis swallow any errors. There is something else wrong.

Changing your print to a select?

Also, how are you trying to run SSIS without having ssis...

It does not look like a SQL dest component that he is using. Judging by the errors and icon.

But there should be something else in the way off errors. Something...

Look at dts.connections(n)

You select your connection and change it's values.

What defines a friendly format? Delimited by fluffy bunnies and pink flowers?

If you did a bit of reading on BCP, you would find you can format it with whatever you...

GGAAAARRRRRRRRRR Why the double post