Monthly Archives: June 2008

Execute SQL Task and Parameter mapping

The EXECUTE SQL Task in SQL Server SSIS allows you to run sql sever TSQL script inlcuding Stored procedures. You can use the variables defined in the package to map to the parameters in the TSQL script. However, the mapping … Continue reading

Posted in SQL Server SSIS | Leave a comment

Debug Scripting task

Scripting Task Scripting task in SQL Server 2005 take full advatage of VB.net and dramatically extended the capability of SSIS pacgkage. However if you use SQL Server 64bit edition, you may get the following error message in the Microsoft Visual … Continue reading

Posted in SQL Server SSIS | Leave a comment

LEN and DATALENGTH with varbinary

varbinary data types store strings of bits. Binary constants have a leading 0x (a zero and the lowercase letter x) followed by the hexadecimal representation of the bit pattern, e.g. 0x2B1D. Both LEN and DATALENGTH can be used with varbinary … Continue reading

Posted in SQL server | 1 Comment