I got a problem. I've to write an sproc to get the data out of a table(csv file) to sql server. So I was thinking to have an ssis package and then generate an TSQL code from it. Is there any possiblity to do this. Thank You.

No. SSIS will not generate code for you. It will help you in data movement. If your requirement is to move the data from csv file to sql server table then you can design a package to do the movement. Use excel source and oledb destination.Nitesh Rai- Please mark the post as answered if it answers your question

in addition to what Nitesh said, you can use DTEXEC to run SSIS package with command like, http://msdn.microsoft.com/en-us/library/ms162810.aspxhttp://www.rad.pasfu.com