hi, i have sql execute sql task i need to run following query INSERT INTO mydata.dbo.MonthEndCDSSpreadCalc(Date, CompanyName) SELECT Date,CompanyName FROM mydata.dbo.UpdateNAV WHERE (Date=?) AND (Portfolioid = ?) AND (SecurityType IN (?)) parameters i'm taking dynamically so i did parameter mapping like following.. but package failed with error: [Execute SQL Task] Error: Executing the query "INSERT INTO mydata.dbo.MonthEndCDSSpreadCalc(Date..." failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Ashish Fugat (9960978134) Software Engineer

There is likely to be a second error line with more an informative error message. You need to set the Parameter Name column. The User::Date maps to 0 (as you have it), User::PortfolioId should be 1 and User::SecurityType should be 2. Do you expect to have more than one SecurityType? Is SecurityType an int datatype element? Your code won't work, unless there is one entry in your list of SecurityTypes.Russel Loski, MCITP Business Intelligence Developer and Database Developer 2008

There is likely to be a second error line with more an informative error message. You need to set the Parameter Name column. The User::Date maps to 0 (as you have it), User::PortfolioId should be 1 and User::SecurityType should be 2. Do you expect to have more than one SecurityType? Is SecurityType an int datatype element? Your code won't work, unless there is one entry in your list of SecurityTypes. Russel Loski, MCITP Business Intelligence Developer and Database Developer 2008 thanks i forgot to do numbering 0,1,2... can you help me in this scenario : http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/16646938-1350-4b59-ba49-d0afdaaf6dc8 give me hints for each step please help i'm newbie Ashish Fugat (9960978134) Software Engineer

hi if i have more than one security type like i want to check where securittype in ('bond','loan') then how can i do this?? i'm having one variable only as security type i have put value = bond right now...Ashish Fugat (9960978134) Software Engineer