ssisssis-2008
How to convert CYYMMDD to YYYY-MM-DD in SSIS?
I have data in a CYYMMDD date format which I need to convert into YYYY-MM-DD in SSIS Package. How to achieve this? Any help will be appreciable.
Solution
Suppose your CYYMMDD column is called cdate and let's call the transformed date ydate then you may need a Derived Column transformation with this expression:
LEFT(cdate,1) == "0"
? "19" + SUBSTRING(cdate,2,2) + "-" + SUBSTRING(cdate,4,2) + "-" + RIGHT(cdate,2)
: "20" + SUBSTRING(cdate,2,2) + "-" + SUBSTRING(cdate,4,2) + "-" + RIGHT(cdate,2)
result:
- Backup database command in T SQL - backup size is increasing
- Is there any way to change the SSIS connection managers while deploying the packages to different environments?
- Find SQL Server Job Related to Existing SSIS Package in Visual Studio
- Getting an error when using the Flexible File Destination Task in Visual Studio 2022 SSIS
- visual studio 2019 open solution file incompatible
- Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.12.0 for linked server (null)
- xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors
- Getting log messages from an SSIS package executed with an SQL query
- How to preserve data comma ',' while exporting data from SQL Server to flat file (CSV) where column delimiter is ','
- Optimizing OLE DB Destination for Fast load from Oracle to SQL Server for SSIS
- SSIS Package Stuck in "Pending Execution" status
- SSISDB package errs out, says variable does not exist
- SSIS Conditional Split - multiple conditions per output
- Is there any releavance for "ROW PER BATCH" AND "MAX INSERT COMMIT SIZE" IN SSIS PACKAGES?
- data conversion issue while executing a ssis package
- How to generate an Excel file from SQL table using SSIS?
- Empty path name is not legal - DTEXEC with Powershell
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- Error: The type of the value (DBNull) being assigned to variable "User:: differs from the current variable type (String)
- Project consistency check failed. has a different ProtectionLevel than the project
- Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications.Core, Version=10.0.0.0
- SQL Server Deployed SSIS package won't open files despite SA account having access to folder
- convert Excel Date Serial Number to Regular Date
- SSIS: How to parameterise foreach folder loop location from project.params value?
- Multiple outputs from SSIS Script
- Metadata for multisource in SSIS
- SSIS The expression for variable 'Variable' failed evaluation. There was an error in the expression
- SSIS OLE DB Destination Editor - Create New Table not an option?
- SSIS - Can you use a parameterised query to populate a Lookup Transformation?
- Flattening a Recursive Hierarchy Into a Dimension with SSIS