Hi, I am new to SSIS, I am exporting FF data from txt file to the Storeproc as a parameter. So I connect my FlatFileSource to OLEDB Destination. I setup the OLE DB Destination with the below settings: Select my OLE DB connection manager to the oen of the connection Managers DataAccess mode: SQL Command Command: exec [uspInvoiceInsertsBiz] @field1=?, @field2 =? , @field3 =? , @field4 =? , @field5 =? , @field6 =? , @field7 =? , @field8 =? ,@field9 =? ,@field10 =? ,@field11 =? ,@field12 =? , @field13 =? ,@field14 =? , But when I click on Preview it gives me an error "Invalid Parameter number". In many of the documentation, there would be a "Parameter" button available in this OLE DB Destination screen to map it but I don't see in this. And as I cannot pass this, I stuck here. Please suggest as to what else do I need to do to get this going, am I missing any steps ? , @field15 =? , , , ,

You have one file but so many parameters why? Also why do you need to import a Flat File (I assume) using a stored procedure? I think you need to load it into a table in which case you need the FF Source mapped to say an OLEDB destination in which you simply map the columns.Arthur My Blog

1) Yes, I concur with ArthurZ. 2) However , if the parameters are required to be there, you use an OLEDB command transformation where the stored proc can be placed like EXEC sp ?. 3) The mappings for OLEDB transformation will map the columns in file connection to the variables in the stored procedure. Anything deviating?Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.

Thanks, I did create OLEDB Command transformation and it did help, but I have to map to that storeproc an user defined varaiabe too, how can I acheive this?

1) There is column mappings tab in the OLEDB transformation besides Component properties where the varaible name appears automatically whichever used in the stored procedure. 2) Map the variable to the columns from text file. 3) Hope the stored procedure is placed in the Component properties of the OLEDBd transformation. For eg : EXEC sp ? That's it.Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.