CODEWITHSUNDEEP
sqlvisual-studio-2012ssis-2012
swathi
swathi

Reputation: 91

How to load google spreadsheet data into SQL Server table using SSIS?

I have a Google spreadsheet with multiple tabs but i would like only one tab to get loaded into a SQL Server table using SSIS.

Is it possible to do, and if yes, how do I do?

If you can provide with example that would be really helpful.

Thanks in advance for your help

Thank you, Swathi L

Upvotes: 1

Views: 3572

Answers (2)

ccarpenter32
ccarpenter32

Reputation: 1077

The basic idea here being, yes you can. And it isn't particularly difficult if you're familiar with creating SSIS packages, you would just use an external data flow task for the Spread Sheet reference.

That being said, the Step by Step proceedure is quite lengthy to share here, but there are some pretty good resources for that out there, such as this link for a physical copy, or this link for a shared Google Sheet. Note, that for shared sheets security is (IMHO) a pretty big issue to worry about.

Additionally, you may need to debug the proceess, which you could use this Microsoft Resource.

Upvotes: 0

DarthTommy
DarthTommy

Reputation: 457

Yes it is possible. When you make your data flow tasks set your source as the excel sheet.

Upvotes: 1

Related Questions