How to INSERT INTO SQLite with SELECT FROM SQL Server

I want to SELECT a table in a SQL Server database and then INSERT it into a local SQLite database.

IS it possible to do this entirely with a query in the vein of:

INSERT INTO table1 ( column1 )
SELECT  col1
FROM    table2  

but passing connection information?