I am creating a Project that will process tables of data and remove unwanted characters, Pad spaces onto the existing values and change the Date Format from YYYY-MM-DD to YYYYMMDD (and stay in Date Data Type.
I've attached a screensshot of the code and pasted some below.
All of these run without an issue in SSMS, not in the Derived Column Transformation in Visual Studio.
Any ideas about what is going wrong? Thanks Peter
REPLICATE(' ',7-LEN([DET_NUMBER])) + CAST([DET_NUMBER] AS VARCHAR(7)) as DET_NUMBER
,REPLACE([POS_START],'-','') AS POS_START
,CONVERT(VARCHAR(1000),[FILLER_01]) AS FILLER01