SSIS is an ETL (Extraction, Transforming, Loading) service, which manipulates data to move it from one format to another. SQL Server is a relational database, which holds data in tables and allows access to it through SQL queries. It is possible to create a script with SQL to extract data from a database or insert data into one, in this instance, you would be writing your own ETL.