Greetings,

I have a flat file that contains the following columns

county_name
fips_code
count_code

and a stored procedure that inserts records into our lkp_county table

CREATE PROCEDURE wrd_lkp_county_insert
(
@new_serial_id int = '-1' OUTPUT,
@return_msg char(250) = NULL OUTPUT,
@current_userid char(8) = NULL,
@county_name varchar(20) = NULL,
@fips_code int = NULL,
@county_code char(4) = NULL
)


When I try to set up an [OLE DB Source] ===> [OLE DB Command]
SSIS data flow everything goes fine until the validation phase when the
I get the error ...

"Validation Error. Data Flow Task: OLE DB Command [42]: Parameters
are not bound. All parameters in the Sql command must be bound to input
columns."

Ok, so how does one go about passing 3 columns from an input file to
a 6 parameter stored procedure ???

I know this is a simple case but we're migrating from a Unix DB from and
I'll be doing a lot of this type of thing with much more complicated tables.

Thanks in advance,

Barry
in Oregon.

P.S. Am I simply expecting too much of SSIS ... is it just basically a
simple
minded graphical environment that meant to handle simple tasks a table
copies
and home office mailing list extractions ???