SQL




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...)


SELECT from table WHERE items IN (@variable)

You need to make query like "SELECT * from tbl WHERE items IN ('item1', 'item2', 'item3', 'item4')" and you want to send items to IN clause as variable. It’s nice when, for example, you want to execute Stored procedure or, as in example below, use INSERT ... SELECT construction. Then you need to make a fint with quotes. (read more...)



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