Thank you so much for your help. I am having an issue could you please give me a more detailed step in solving this problem. I have to sort this problem now. Please advice KB

Hi Guys, My data source is FoxPro for Unix using ODBC connection i would like to bring it to sql 2005 by SSIS 2005. Can any one explain how i could use Dynamic SQL using SSIS Datareader Like for instance "SELECT * FROM " @[User::TableName] expression??? Please explain the Steps to follow. Thank you

Dear All, I have one table with column called testId. This Id is referenced in six other table columns. Its not like a primary /foreign key type but can be used to compare values using inner join. There is a requirement to changed all of this testId(10 digits code originally) to new set of TestId(11 digits code now). I could have done ON UPDATE CASCADE to change all testid's in other six tables if there was primary /foreign key defined. Is there any one who can give me a hint on the script to update on the master table so that all the other tables will contain the relevant changes on the testId. For example : Old value New Value testId = s401 I00010 s402 I00020 s403 I00030 s403 I00040 This is going be applied to over 30k rows hence i just needed a script to do it. Thank you so much for your time.

modified on Wednesday, July 13, 2011 5:37 PM