Thank so much for this video. Very useful. Just one question. Once I manage to establish the connection and the fields are updated from Sheets to SQL, will the data always be automatically synchronized or would I have to do something additional?
Thank you for reaching out. You can schedule SSIS package to sync data every 10 min for example. If you need any assistance please contact our support team. Thank you.
Does this require purchasing Cozyroc SSIS+? Or can I do it with the free download? All I need to is to be able to use Google Sheets as a data source in SQL server. Thanks, Rob
Thank you for reaching out. Download, developing and testing with the COZYROC SSIS+ Suite is completely free and you don't need a license key until you want to schedule and execute your packages under the SQL Job Agent. Here is the download link www.cozyroc.com/download
@@Cozyroc Sorry, I still don't quite understand - after downloading and setting up the connection from Google Sheets to SQL Server (as shown in this video), will I need a license key to pull data from Google Sheets into SQL server? In other words, will I need to pay to actually make use of that integration in my SQL queries?
You don't need a license key to pull data from Google Sheets into SQL server if you execute your packages in Visual Studio. You will need a license only if you schedule and execute your packages under the SQL Job Agent. For example to pull data from Google Sheets into SQL server every hour.
you have business intelligence, analysis services, integration services available already by default. Is that an option enabled, or a template downloaded? I can't see how you got that available, which in turn made the rest of it easier.
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server. You can find full list of COZYROC tasks and components here: cozyroc.com/products. COZYROC SSIS+ Components Suite is free for testing in your development environment
Hi, thanks for your development work and the video tutorials. I have a problem when I try to check the column preview in the configuration option required to obtain data from REST source window. The software answer me with an error like this. What I can do? =================================== Error: Error: Error: { "error": { "code": 404, "message": "Requested entity was not found.", "status": "NOT_FOUND" } } LineNumber:0 Template:{{=Sheets.getSourceFields(parameters)}} (Microsoft Visual Studio) ------------------------------ Program Location: in Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HandleUserException(Exception e) in Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostReinitializeMetaData(IDTSManagedComponentWrapper100 wrapper) in Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ReinitializeMetaData() in CozyRoc.SqlServer.SSIS.BaseDataFlowComponentPage.SetupMetadata() in CozyRoc.SqlServer.SSIS.RestSourceGeneralPage.#=z8XGPCoF1hyn3PWevZg==(Object #=zLUuLVBs=, EventArgs #=z6V8LUC0=) =================================== Error: { "error": { "code": 404, "message": "Requested entity was not found.", "status": "NOT_FOUND" } } (CozyRoc.SSISPlus.2019) ------------------------------ Program Location: in CozyRoc.Rest.Connection.JsConnection.Execute(ObjectInstance #=zyfebVa0=) in binder_for_CozyRoc.Rest.Connection+JsConnection.Execute(ScriptEngine , Object , Object[] ) in Jurassic.Compiler.Binder.Call(ScriptEngine engine, Object thisObject, Object[] arguments) in Jurassic.Library.ClrFunction.CallLateBound(Object thisObject, Object[] arguments) in Jurassic.Library.FunctionInstance.CallWithStackTrace(String path, String function, Int32 line, Object thisObject, Object[] argumentValues) in anonymous(ScriptEngine , Scope , Object , FunctionInstance , Object[] ) in Jurassic.Library.UserDefinedFunction.CallLateBound(Object thisObject, Object[] argumentValues) in Jurassic.Library.FunctionInstance.CallWithStackTrace(String path, String function, Int32 line, Object thisObject, Object[] argumentValues) in anonymous(ScriptEngine , Scope , Object , FunctionInstance , Object[] ) in Jurassic.Library.UserDefinedFunction.CallLateBound(Object thisObject, Object[] argumentValues) in CozyRoc.Rest.Connection.#=zpyjI4iaQ$s60(String #=z7_hf7mc=, String #=zlSZ6XRm6f9BF, Object[] #=zJeqvReg=) =================================== { "error": { "code": 404, "message": "Requested entity was not found.", "status": "NOT_FOUND" } } (CozyRoc.SSISPlus.2019) ------------------------------ Program Location: in CozyRoc.Rest.Connection.ExecuteRequest[T](IRestRequest #=zyfebVa0=, Boolean #=znt0DwlQ=) in CozyRoc.Rest.Connection.JsConnection.Execute(ObjectInstance #=zyfebVa0=)
Moez, which version of SSIS+ you have installed ? Can you please contact our support team at desk.cozyroc.com and provide more details about your environment ? Thank you.
Thank you for reaching out. Yes, you can run it by Visual Studio 2010. For more details please check SQL and Visual Studio Compatibility chart - desk.cozyroc.com/portal/en/kb/articles/installation-and-getting-started#Compatibility_Charts . If you have any questions, please contact our support team. desk.cozyroc.com
Steve, can you please check which version of COZYROC SSIS+ you have installed ? You can find compatibility chart here desk.cozyroc.com/portal/en/kb/articles/installation-and-getting-started#Compatibility_Charts . If you have any questions, contact our support team at desk.cozyroc.com and provide more details about your environment. Thank you.
To ensure we can provide you with the best assistance, may I kindly request that you please open a support ticket at desk.cozyroc.com? This will allow us to track your support ticket and assign it to the appropriate team member for a prompt resolution. Thank you.
This is what I have been looking for. Thank you. You help me a lot!
Thank so much for this video. Very useful. Just one question. Once I manage to establish the connection and the fields are updated from Sheets to SQL, will the data always be automatically synchronized or would I have to do something additional?
Thank you for reaching out. You can schedule SSIS package to sync data every 10 min for example. If you need any assistance please contact our support team. Thank you.
What I've been searching for. Thank you so much for this.
Glad it was helpful!
Does this require purchasing Cozyroc SSIS+? Or can I do it with the free download? All I need to is to be able to use Google Sheets as a data source in SQL server. Thanks, Rob
Thank you for reaching out. Download, developing and testing with the COZYROC SSIS+ Suite is completely free and you don't need a license key until you want to schedule and execute your packages under the SQL Job Agent. Here is the download link www.cozyroc.com/download
@@Cozyroc Sorry, I still don't quite understand - after downloading and setting up the connection from Google Sheets to SQL Server (as shown in this video), will I need a license key to pull data from Google Sheets into SQL server? In other words, will I need to pay to actually make use of that integration in my SQL queries?
You don't need a license key to pull data from Google Sheets into SQL server if you execute your packages in Visual Studio. You will need a license only if you schedule and execute your packages under the SQL Job Agent. For example to pull data from Google Sheets into SQL server every hour.
Does this need to be an Excel Sheet in your drive? How do you extract data from a Sheet that has been shared with you?
Minura, thank you for reaching out . Please open a ticket at desk.cozyroc.com . Our ETL engineers will be happy to help. Thank you !
you have business intelligence, analysis services, integration services available already by default. Is that an option enabled, or a template downloaded? I can't see how you got that available, which in turn made the rest of it easier.
sql server integration services isn't an extension available in visual studio marketplace
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server. You can find full list of COZYROC tasks and components here: cozyroc.com/products. COZYROC SSIS+ Components Suite is free for testing in your development environment
Аfter "сhoose an account" and click "allow" i'm see empty blanc "can't connect to local host". what I should do? version 1.7.103
Thank you for reaching out. Please contact our support team at desk.cozyroc.com and open a ticket. Thank you
Hi, thanks for your development work and the video tutorials.
I have a problem when I try to check the column preview in the configuration option required to obtain data from REST source window. The software answer me with an error like this. What I can do?
===================================
Error: Error: Error: {
"error": {
"code": 404,
"message": "Requested entity was not found.",
"status": "NOT_FOUND"
}
}
LineNumber:0
Template:{{=Sheets.getSourceFields(parameters)}} (Microsoft Visual Studio)
------------------------------
Program Location:
in Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HandleUserException(Exception e)
in Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostReinitializeMetaData(IDTSManagedComponentWrapper100 wrapper)
in Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ReinitializeMetaData()
in CozyRoc.SqlServer.SSIS.BaseDataFlowComponentPage.SetupMetadata()
in CozyRoc.SqlServer.SSIS.RestSourceGeneralPage.#=z8XGPCoF1hyn3PWevZg==(Object #=zLUuLVBs=, EventArgs #=z6V8LUC0=)
===================================
Error: {
"error": {
"code": 404,
"message": "Requested entity was not found.",
"status": "NOT_FOUND"
}
}
(CozyRoc.SSISPlus.2019)
------------------------------
Program Location:
in CozyRoc.Rest.Connection.JsConnection.Execute(ObjectInstance #=zyfebVa0=)
in binder_for_CozyRoc.Rest.Connection+JsConnection.Execute(ScriptEngine , Object , Object[] )
in Jurassic.Compiler.Binder.Call(ScriptEngine engine, Object thisObject, Object[] arguments)
in Jurassic.Library.ClrFunction.CallLateBound(Object thisObject, Object[] arguments)
in Jurassic.Library.FunctionInstance.CallWithStackTrace(String path, String function, Int32 line, Object thisObject, Object[] argumentValues)
in anonymous(ScriptEngine , Scope , Object , FunctionInstance , Object[] )
in Jurassic.Library.UserDefinedFunction.CallLateBound(Object thisObject, Object[] argumentValues)
in Jurassic.Library.FunctionInstance.CallWithStackTrace(String path, String function, Int32 line, Object thisObject, Object[] argumentValues)
in anonymous(ScriptEngine , Scope , Object , FunctionInstance , Object[] )
in Jurassic.Library.UserDefinedFunction.CallLateBound(Object thisObject, Object[] argumentValues)
in CozyRoc.Rest.Connection.#=zpyjI4iaQ$s60(String #=z7_hf7mc=, String #=zlSZ6XRm6f9BF, Object[] #=zJeqvReg=)
===================================
{
"error": {
"code": 404,
"message": "Requested entity was not found.",
"status": "NOT_FOUND"
}
}
(CozyRoc.SSISPlus.2019)
------------------------------
Program Location:
in CozyRoc.Rest.Connection.ExecuteRequest[T](IRestRequest #=zyfebVa0=, Boolean #=znt0DwlQ=)
in CozyRoc.Rest.Connection.JsConnection.Execute(ObjectInstance #=zyfebVa0=)
Mattia, thank you for reaching out. Please contact our support team at desk.cozyroc.com and provide more details. Our ETL engineers will assist you.
Will sql server data be deleted when deleting data in google sheet?
In this video the data is pulled from Google Sheets and inserted into SQL Server table.
hello, i can not find the rest connection in connection manager , what should i do ?
Moez, which version of SSIS+ you have installed ? Can you please contact our support team at desk.cozyroc.com and provide more details about your environment ? Thank you.
can i run it by visual studio 2010?
Thank you for reaching out. Yes, you can run it by Visual Studio 2010. For more details please check SQL and Visual Studio Compatibility chart -
desk.cozyroc.com/portal/en/kb/articles/installation-and-getting-started#Compatibility_Charts . If you have any questions, please contact our support team. desk.cozyroc.com
I do not see a REST connection in the Add SSIS Connection Manager
Steve, can you please check which version of COZYROC SSIS+ you have installed ? You can find compatibility chart here desk.cozyroc.com/portal/en/kb/articles/installation-and-getting-started#Compatibility_Charts . If you have any questions, contact our support team at desk.cozyroc.com and provide more details about your environment. Thank you.
hola tengo un problema con la conexion, tiene soporte en idioma español?
Dear Miguel, please contact our support team desk.cozyroc.com and open a ticket. Our ETL engineers will assist you. Thank you !
I have a problem with the range, I put BotA1:L6 but the program reject me
Thanks for reaching out. Can you please contact our Help Desk desk.cozyroc.com and provide more details ? Thank you.
@@Cozyroc I have the same problem, Can you provide the response here please
To ensure we can provide you with the best assistance, may I kindly request that you please open a support ticket at desk.cozyroc.com? This will allow us to track your support ticket and assign it to the appropriate team member for a prompt resolution. Thank you.
Excuse me , Is it automatically?
Yes, it automatically. If you have any questions, please do not hesitate to contact us : desk.cozyroc.com Thank you.
Tks but I mean it can update continous from gg sheet to sql server when I import on gg sheet in real time
It's not a real time update. You can schedule SSIS package execution every 1 min for example.
@@Cozyroc sorry, it loads all google sheet data again or only change?
Thank you for reaching out. In this demonstration all Google Sheet data is loaded.