Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by andre1802
-
SSIS Derived columns
Thanks gk53, so you would say a select into another table with the case statements would be faster than using a Data flow task with derived columns, what I am looking for is increased performance. I am not sure in derived columns will be a heavier workload than a straight select into. Note we...- andre1802
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS Derived columns
I need help getting the following case statement into the derived column format in SSIS CASE WHEN SUBSTRING(REPLICATE('0', 9 - LEN(Data)) + CAST(Data AS VARCHAR(9)), 4, 6) IS NULL THEN 0 ELSE RTRIM(SUBSTRING(REPLICATE('0', 9 - LEN(Data)) + CAST(Data AS VARCHAR(9)), 4, 6)) END Here are...- andre1802
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
