I am using a DO WHILE loop in tsql to populate two months worth of data with over 150 columns of information. My query works in TSQL to where it displays all the information but I noticed that it is basically executing the query separately for each day in the two month timeframe. I am guessing that is why when I try and run this stored procedure in SSIS to populate a new table it just writes the first record then finishes successfully. I am guessing I should be using another statement besides DO WHILE or doing something different in SSIS? Any feedback you can provide would be greatly appreciated. Please advise.