Learn, Practice & Share
Labels
Azure
(1)
C#
(9)
Dot Net
(1)
Global
(2)
LINQ
(2)
Powershell
(1)
SharePoint
(2)
SQL
(2)
SQL 2012
(28)
SQL Server
(134)
SSAS
(6)
SSIS
(9)
SSRS
(9)
Windows Service
(1)
Thursday, June 25, 2015
How to handle Null assignment to a column in the Output buffer in SSIS script component when used as Source or Transformation
ErrorOutputBuffer.AddRow();
ErrorOutputBuffer.FNAME= fName;
if (string.IsNullOrEmpty(SSN))
{
ErrorOutputBuffer.SSN_IsNull = true;
}
else
{
ErrorOutputBuffer.SSN = SSN;
}
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment