I’ve been searching the web for a solution but couldn’t find any so here is what we came up with (there might be better ways but at least this is a start if someone else runs into this). Specify the dtype parameter in to_sql. We went from:df.to_sql(table_name, analytics_db) to df.to_sql(table_name, analytics_db, dtype={‘name_of_json_column_in_source_table’: sqlalchemy.types.JSON}) and it … Read more
I’m going to add a somewhat longer and more detailed explanation of the steps to take to solve this problem. I apologize if it’s too long. I’ll start out with the base you’ve given and use it to define a couple of terms that I’ll use for the rest of this post. This will be … Read more
I finally got it. It turns out there is an issue with the validation, but not only SSIS elements go through that validation, as stated in the fourth failed solution of the question. The CONNECTIONS also get validated and have their own Delay Validation property, which needs to be set to true. After that the … Read more
I am using visual studio 2017, To get the SSIS toolbox back, right-click on the SSIS design surface in the project and select SSIS Toolbox please see this link. This resolved it for me. Adding the content below again, in case the webpage is not available in future. I have installed the Data-Tier Application Framework … Read more
How does it compare with other reporting technologies and can it be easily integrated into a corporate environment? I don’t know how F# compares with other reporting technologies but I have deployed it in more than one corporate environment and it is basically the same as C#, i.e. easy and robust. How did you address … Read more
staging tables are just database tables containing your business data in some form or other. Staging is the process of preparing your business data, usually taken from some business application. For your average BI system you have to prepare the data before loading it. A staging table is essentially just a temporary table containing the … Read more
Package Executions: SQL Server Data Tools: User credentials under which SQL Server Data Tools (SSDT) is operating will be used to execute the packages that are executed within SSDT. Under Windows Start \ All Programs \ Microsoft SQL Server 2012, if you click SQL Server Data Tools it will run under your credentials. To run … Read more
In SQL: select dateadd(d,36464,’1899-12-30′) — or thanks to rcdmk select CAST(36464 – 2 as SmallDateTime) In SSIS, see here http://msdn.microsoft.com/en-us/library/ms141719.aspx
Update 5 Jun. 2023 – general Availability (GA) release Microsoft released Version 1.0 (General Availability (GA) release) of the SQL Server Integration Services extension for Visual Studio 2022. Update 24 Nov. 2022 – Public preview released Microsoft added a public preview of the SQL Server Integration Services Projects 2022 to the Visual Studio marketplace, which … Read more