RE: Repost - Sql Server 2005 - SSIS - nbr of input cols < nbr stored proc parameters (MSDN Universal Subscriber)

Hello Barry,

To understand the issue better, I'd like to know more details about this
issue:

1. What do you suppose SP to do in the insert task?

2. What is the exact steps to reproduce the issue? Will you provide a
sample file and schema of the destination data?

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Reply-To: "frostbb" <barry.b.frost@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
| From: "frostbb" <frostbb@xxxxxxxxxxxxxxxxx>
| Subject: Repost - Sql Server 2005 - SSIS - nbr of input cols < nbr stored
proc parameters (MSDN Universal Subscriber)
| Date: Mon, 7 Nov 2005 08:24:51 -0800
| Lines: 55
| Organization: Oregon Water Resources Dept
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OXqPZe74FHA.1420@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.dts
| NNTP-Posting-Host: 159.121.113.234
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:15970
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| Greetings,
|
| I'm trying to set up a SSIS package that will use columns from a flat
| file and insert them into an existing table using an 'insert stored proc'
| for the target table. I keep getting an error that says I have to provide
| inputs for all the stored proc parameters but the flat file only contains
| the actual data columns ... confused and frustrated.
|
| Any help would be GREATLY appreciated.
|
| Thanks in advance,
|
| Barry
| in Oregon.
|
| THE SPECIFICS ...
|
| 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.
|
| 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 ???
|
|
|

.

Relevant Pages