InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 20:41:22 GMT20http://www.sqlservercentral.com/Forums/Topic1049873-148-1.aspxPretty cryptic response....I tried it in my call to a stored proc from a Foreach loop and the "No value given for one or more required parameters." is still issued./johnTue, 07 May 2013 10:50:13 GMTjk_in_San_Diegohttp://www.sqlservercentral.com/Forums/Topic1049873-148-1.aspxTry something like below...SET NOCOUNT ONexec sp_name @UserDate = ?and pass parameter in Parameters Tab (@UserDate = <Variable Name>)Fri, 21 Jan 2011 05:18:46 GMTsqlusershttp://www.sqlservercentral.com/Forums/Topic1049873-148-1.aspxI am still not able to make any progress.The steps i am doing:1st step:Execute Sql task--To get the max(date) mdate from table and assign the madate to user defined variable in resultset otopn of task.2nd Step: Another Execute Sql task to delete the data from table based on passed parameter3rd Step:Drag n drop a data flow task--it contains one oledb sourceand one oledb destination.Inside oledb source, i have defined oledb connection manager.Data access mode is sql command and passing SP name e.g.exec sp_name @UserDate = ?@UserDate is actual input parameter passed to SP.After this i am maaping parameter with User variable.Once i click on preview i get the error messgae..no value given for one or more required parameter.If i change the sql command like exec sp_name ? then also same error.Can anyone help me to resolve this?Fri, 21 Jan 2011 00:53:18 GMTKaran_Whttp://www.sqlservercentral.com/Forums/Topic1049873-148-1.aspxHi Karan,Use the execute SQL task to run your stored procedures in the sequence required.Regards,Barkha.Wed, 19 Jan 2011 06:43:33 GMTJaved-330570http://www.sqlservercentral.com/Forums/Topic1049873-148-1.aspxHi ,Thanks for reply. Yes it can be done by SP also but requirement is to get it done by SSIS only so any help would be really appreciable.Wed, 19 Jan 2011 06:24:58 GMTKaran_Whttp://www.sqlservercentral.com/Forums/Topic1049873-148-1.aspxOK, maybe that was a bit harsh on an SSIS newbie.After looking at this, I must admit that I found myself thinking that it would be easier to get the stored procedure to do everything, rather than faffing around with the various SSIS tasks that you would need.Everything you have asked for (barring the initial parameterised call to the sp) can easily be accommodated in T-SQL - so why have you decided on using SSIS?Wed, 19 Jan 2011 03:51:14 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1049873-148-1.aspx[quote][b]Karan_W (1/19/2011)[/b][hr]I want to create a SSIS package which will call the stored procedure and dump the output of the procedure into table.This stored procedure accept an input parameter e.g. Date which i can retrieve from another table like select max(Date) from userid and pass to procedure.SSIS packae will return the output and i need this resultset ouput to dump into another table.But before inserting i want to delete the rows from that tables if any rows exist for that date and then finally insert the resultset.[/quote]..and your question is?Wed, 19 Jan 2011 03:23:19 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1049873-148-1.aspxI want to create a SSIS package which will call the stored procedure and dump the output of the procedure into table.This stored procedure accept an input parameter e.g. Date which i can retrieve from another table like select max(Date) from userid and pass to procedure.SSIS packae will return the output and i need this resultset ouput to dump into another table.But before inserting i want to delete the rows from that tables if any rows exist for that date and then finally insert the resultset.Wed, 19 Jan 2011 03:07:50 GMTKaran_W