• Not SQLCMD. SSIS is not built using T-SQL. There is a set of .Net objects for the SSIS object model. You can programatically create packages using these objects. Search google for some articles. Also, an SSIS package is an XML file, I suppose you could directly generate the XML if you knew the structure well enough.