SSIS Expression to Get Current Year and month in the format YYYY-MM

If we want to append current Year and month to the string  for example to the File name if we want append the current year nad month this the Expression we need to Use



(DT_WSTR,4)YEAR(GETDATE()) + "-" + RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()), 2)

we are Padding month number with zero to make it 2 digits .

See the Below example





Comments

Post a Comment

Popular posts from this blog

SQL Server MDS : How to Know Actual MDS Table name for Model Entity and Column name for the Attribute

How to Know Actual MDS Table name for Model Entity and Column name for the Attribute . here is the Script  USE MDS ------------------------------------------------------------ -- TODO: Define Model name, Entity name, and Attribute Name        DECLARE @Model NVARCHAR ( 50 )        = '<<GiveModelName>>' ;        DECLARE @Entity_Name NVARCHAR ( 50 ) = '<<GiveEntityName>>' ;        DECLARE @Attribute_Name NVARCHAR ( 50 )= '<<GiveAttributeName>>' ; ------------------------------------------------------------ -- Set @Table name        DECLARE @Table NVARCHAR ( 128 );              SELECT @Table = EntityTable FROM mdm . viw_SYSTEM_SCHEMA_ENTITY WHERE Model_Name = @Model AND name = @Entity_Name ; --...
Read more

SSIS : Hresult: 0x80004005 Description: "Invalid character value for cast specification".

Image
1.       Error msg: [OLE DB Destination [138]] Error: SSIS Error Code DTS_E_OLEDBERROR.   An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.   Source: "Microsoft SQL Server Native Client 10.0"   Hresult: 0x80004005   Description: "Invalid character value for cast specification". [OLE DB Destination [138]] Error: There was an error with input column "finDate" (2050) on input "OLE DB Destination Input" (151). The column status returned was: "The value could not be converted because of a potential loss of data.". [OLE DB Destination [138]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.   The "input "OLE DB Destination Input" (151)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "OLE DB Destination Input" (151)" specifies failure on error. An error occurred on the specified object of the specified compone...
Read more

SSAS Error : XML parsing failed at line 1, column 0: A document must contain exactly one root element

when i am planning to redeploy the Cube . I took the latest cube from Production and want to deploy in Dev server . i am getting the fallowing error . Error 33 XML parsing failed at line 1, column 0: A document must contain exactly one root element. .  0 0 Error 34 Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\E:\MSSQL\Data\DbR4.194.db\MSC ID.112677.dim.xml'.  0 0 Solution : Go the path specified the in the Error on the deploying server not on you local server . and there you will find that file with 0 KB  . Delete that file and redeploy the project .
Read more