Appending rows is the default behaviour. Any other requirement (UPDATE or replace, for example) would require additional steps.

Unless you are prepared to take the time to provide a few more...

All you need to do is update the meta data for the source connection to include the extra columns - but you don't need to send them through the pipeline....

The reference to 'long' data made me wonder whether it is, for some reason, expecting a long integer rather than a string. But based on what you have written, this...

Inelegant as it may seem, your fastest solution is to create 18 'hard-coded' data flows.

I know, I wouldn't like it either :w00t:

An alternative is to build the whole thing in...

I suggest that you read and follow this thread - it's relevant to what you are trying to achieve:

http://www.sqlservercentral.com/Forums/Topic764541-148-1.aspx

Try using & instead of + ...

The TRUNCATE option will work, but do you really want to delete everything from the table every time before you perform the import? Or maybe you want to import 'new'...

If you check the meta data for the OLEDB source in your SSIS package, for both External data and Output data, what is the datatype of the column which is...

By 'fails', do you mean that zero records are retrieved?

There is probably a way of achieving this by using a conditional split based on record count (0 is one path,...

Great stuff & thanks for posting back - perfect use of these forums.

Not a stupid question at all 🙂

Try createinga solution and adding the package. Then work with the solution, rather than editing the package directly ...

When the error is reported, is it because the exe has failed (ie, the text files truly do not exist), or is it that the text file is in the...

Maybe this thread is relevant:

http://www.sqlservercentral.com/Forums/Topic746185-148-1.aspx

What do you mean by 'empty' exactly?

a) No file

b) File exists, but no data or meta data in it

c) File exists, column headings exist, but no data rows

d) Something else?

Are you asking for how to automatically deal with structure changes to source files (eg, change in number of fields, max length of fields or data types of fields)?

Or how...