Forum Replies Created
Viewing 15 posts - 31 through 45 (of 107 total)
-
RE: Creating derived columns from column of variable length components
Thanks for all of your input, @Phil Parkin and everyone! I was able to finally get this to work by using the following for the derived columns:
PackageCode: ...
-
RE: Creating derived columns from column of variable length components
Okay, so this is my latest attempt to try coding the SSIS expression for the original scenario of the PCMRetrievalCode column, particularly the ContainerID portion:
i.e. P0607CON1324
April 24, 2018 at 8:41 am
-
RE: Creating derived columns from column of variable length components
Thanks, Phil. I'm thinking I should use 5 for as the 2nd argument of (DT_WSTR), as the container ID could potentially be this length, however, SSIS doesn't seem to be...
-
RE: Creating derived columns from column of variable length components
If I don't use (or attempt to use) the (DT_WSTR,3), then it gives me a 'The function "FINDSTRING" does not support the data type "DT_NTEXT" for parameter number 1. The type of...
-
RE: Creating derived columns from column of variable length components
Hi Phil,
So, it turns out that the version of BIDS I'm using doesn't have the LEFT function either, but I was able to rewrite the SchemaID expression as:
-
RE: Creating derived columns from column of variable length components
Phil,
I actually use BIDS:
-
RE: Creating derived columns from column of variable length components
Phil Parkin - Friday, April 20, 2018 12:52 PM