Hi All, I am a new for Sql Server 2008. We are evluating SSIS, i have a question that does Business Intelligence Development studio support code(SQL) generation when i do the ETL process?what i mean is when data flow has been finished, can i get the SQL code generated automactilly by SSIS? I searched the document but not found any information related to it. Thanks for your attention. Regards

What type of 'code' would you like it to generate? T-SQL code? That does what? SSIS is not a 'code generation' tool. Tools like Erwin or even Visio have modules that will generate the CREATE TABLE statements based on visual desings. SSIS has, to my knowledge only one component that might do that, but you can only execute that 'code generation' part at DESIGN TIME. What exactly are you looking for? Can you give us an example?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Hi Todd C, Thanks for you attention. I am trying to evaluation ETL tools from microsoft, oracle, and pentaho. What I mean "code generator" is for example, when i use "Merge join" to join two tables, I can get the SQL script of what "Merge join" has done "Select ***, *** from a, b where a.*** = b.***"

if you want to evaluate ETL tools, you can do it with real cases. do an ETL process on huge data and check the performance and response times for each of ETL tools you want to evaluate. as Todd said there is no t-sql generation code, because your sources and destination may differ. for example the t-sql code for pivoting a flat file doesn't make sense. http://www.rad.pasfu.com

*********** as Todd said there is no t-sql generation code ********** Thanks for your reply, Reza. Sure, we got some other criteria items for performance test as well. Because both our source and target are RDB, so for us, It make sense that whether the ETL tools can generate native SQL code or not. By the way, a lot of ETL tools could do it well, for example , Oracle, Wherescape etc.