The table below shows a simplified mapping between SQL Server, SSIS and Biml data types. The table does not include all possible mappings or all data types, but is meant as a quick reference while ...

In SQL Server 2014, memory-optimized tables do not support cross-database transactions. This means you cannot access another database from the same transaction or the same query that also accesses a ...

I knew it was possible because some data sources like SQL Server give you typed columns when you expand a table column; I also saw that TripPin custom data connector tutorial aims to cover this topic… ...

This post adds one more useful detail: how to preserve the original data types of the columns in your query when using this technique with SQL Server-related sources. Consider the DimDate table in the ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...

How to Describe Table in SQL Server One of the essential tasks when working with SQL Server tables is the ability to describe them. You can use the sp_help command to get information about a table’s ...

The table below shows a simplified mapping between SQL Server, SSIS and Biml data types. The table does not include all possible mappings or all data types, but is meant as a quick reference while ...