First and foremost you would need to use foreah loop to iterate thruogh each record in the table. In side the loop have a script task and based on what ever logic you have you would have to populate the variables arrodingly using conditions. I guess you would be needing something like if col1=1 populate v1,v2 if col2 =2 populate v1,v3 and so on. To do this you would have to put each variable to wish to assign value in the ReadWrite variables list.

Hello all, I'm using BIDS 2005/SQL server 2005. I have a table with x rows CREATE TABLE [SYSADM].[extrecover]( [ID] [int] IDENTITY(1,1) NOT NULL, [Date] [datetime] NULL, [ShortDT] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DayNr] [int] NULL, [WeekNr] [int] NULL ) ON [PRIMARY] I also have an existing dtsx procedure which is using get getdate() (sql) function. This procedure is created to run once a day, but the last weeks it hasn't run and i would know like to recover my data, by looping my existing procedure x times (the number records in my extrecover table) and i would like that each run, a few variables in my package are updated with values from the current record from my recover table. Could somebody please advice me on how to best do this. thanks already for your responses. Vinnie.