Hello: Any help would be greatly appreciated. To keep it simple, here's what we are trying to do. We have 2 excel files with STOREID as a column in each file. The values in file 1 are 9999 and the values in file 2 are 7100. We have a table in Sql Server called Weekly_Store_Emails_VK_Test. There are 2 columns (ID and email address). So there are 2 rows in this table (1 for ID 7100 and 1 for id 9999). New to SSIS, but I have a for each loop container to process thru the 2 files on my c drive, grab StoreID from each excel file, and then mapping that storeid to the ID in the table to grab the corresponding email address. However, something is not workign as I get both files sent to me! Error says = an error occurred while assigning a value to variable emailaddress. Single Row result set is specified, but no rows were returned'. I have no clue how to resolve this!!
I have 3 variables in this solution:
1) EmailAddress which has a data type STRING 2) StoreFile which has a data type STRING 3) StoreID which has a data type OBJECT
did you put a breakpoint at execute sql task to see if parameter value is getting passed correctly? Also check resultset variable and see if return value obtained ie emailaddress is correct
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Help needed with For Each Loop and Send Mail
Posted - 12/21/2012 : 12:28:23
