Lanre Famuyide

Simple Steps to Creating SSIS Package Configuration File

This new article from Lanre Famuyide shows how to make your SSIS package deployment hassle free by using package configuration files.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.33 (30)

You rated this post out of 5. Change rating

2009-05-14

73,342 reads

This is my last week of the year working (I guess I come back...

I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...

This is my last week of the year working (I guess I come back...

I have an ADF pipeline that copies Files from source to destination. Both Source...

I''m running a stripped backup (2 files) to a Network share. It's a 32gig...

Comments posted to this topic are about the item Function Defaults

I have created this function in SQL Server 2022:

CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
    RETURN @one + @two
END

How can I call this and invoke the default value for @two?