Category Archives: SQL Server SSIS

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