SQL




Transact-SQL string functions

This post is about which string functions there are in Transact-SQL. They allow to modify data you have, make custom queries to select records from database tables. To know them is very important for any developer - using string functions is very good way to decrease load from application server without adding it to SQL because string functions on SQL server work very fast. (read more...)

SQL error "SSIS Error Code DTS_E_PRODUCTLEVELTOLOW" fix

On test environment I have executed an SQL Server Integration Services Package and I’va got the error:
SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The component "Lookup My Cities" (64) cannot run on installed (64-bit) of Integration Services. It requires Standard Edition (64-bit) or higher. End Error

As it turned out, service SQL Server Integration Services wasn’t installed on the machine and I had to add it to SQL server features (Drawing 1). (read more...)


MarkiMarta.com. Notes of web-specialist
Since 2009
18+