dynamic sql Archives

Dynamic SQL in OLEDB source component in SSIS

1 Comment / SSIS / Gopal Krishna Ranjan / Sep 12, 2016 / dynamic sql, oledb source

The metadata could not be determined because statement contains dynamic SQL When we use a batch of T-SQL statements which contains dynamic SQL or uses temporary tables inside, in an OLEDB source component placed in a Data Flow Task of a SSIS package, we get an error during column names extraction because the source component gets failed to fetch the metadata (columns and their data types) […]

Dynamic SQL in OLEDB source component in SSIS Read More »

Dynamic PIVOT query in SQL Server

PIVOT clause is used to generate cross tab outputs in SQL Server. We put unique data values from a column in the PIVOT clause to render them as multiple columns in aggregation with other columns required in the output. With the help of PIVOT clause, we can transpose the distinct values of a column into multiple columns. However, syntax of PIVOT clause requires these distinct values to