SQLite does not use SqlCommand objects - it uses SQLiteCommand, SQLiteConnection, and such like constructs. If you want to access SQLite databases, you have to use those instead SQL server classes.
There are many ways to copy a table between SQL server databases:
copy a table between SQL server databases - Google Search[
^] - each with thier own advantages and disadvantages depending on your situation. Have a look, follow a few links, and see what you can find that fits what you are trying to achieve.