Newbie question for SQL Server System Integration Services Flat File Import

I am new to SSIS...

I have a very simple package that has a flat file source object and an ole db destination object in the data flow. All works fine.

If I change a row in the flat file to make it fail how do I make the program continue and go to the next row?

The ole db destination does not have a Error Output properties like the flat file source does.

Thanks

Check the Properties of the Data Flow Task (or other task you're using for dealing with the flat file) in the Control Flow tab, there is an attribute MaximumErrorCount, which is default to 1.

Newbie Help

Looking to create a flat file from a stored proc that is comma delim.. can
this be done? I know I can use DTS but the table is a temp table and that
wont work.
Thanks for your help in advance.
--
Austin Henderson <><
Network AdministratorYou can shell out to bcp via xp_cmdshell but will have to use a global temp
table (##) as bcp will create it's own connection and your local temp table
would not be visible to it.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Austin Henderson" <kahenderson@.firstfleetinc.NOSPAM.com> wrote in message
news:uQpnrkbcDHA.384@.TK2MSFTNGP12.phx.gbl...
Looking to create a flat file from a stored proc that is comma delim.. can
this be done? I know I can use DTS but the table is a temp table and that
wont work.
Thanks for your help in advance.
--
Austin Henderson <><
Network Administrator