Viewing 15 posts - 4,501 through 4,515 (of 13,877 total)
This statement is false:
So currently there is a need to upgrade the excel sheets from .xls format to .xlsx format since our target server is 64 bit.
April 30, 2018 at 2:06 pm
Take a look at the picture...
April 30, 2018 at 12:32 pm
In case you have not solved this yet, please try the following:
RIGHT( (DT_WSTR, 15) [PCMRetrievalCode] , LEN ( (DT_WSTR, 15) [PCMRetrievalCode] )- FINDSTRING( (DT_WSTR, 15)[PCMRetrievalCode]...
April 25, 2018 at 12:04 pm
I've built a basic ETL ssis package that drops an Excel file from on network...
April 23, 2018 at 12:52 pm
April 23, 2018 at 11:59 am
So, it turns out that the version of BIDS I'm using doesn't have the...
April 23, 2018 at 10:56 am
OK, without TOKEN, this gets complicated, fast. Try this:
For SchemaId:
LEFT( replace(REPLACE( [PCMRetrievalCode] , "PO","" ),"PA","") , FINDSTRING( replace(REPLACE( [PCMRetrievalCode] , "PO","" ),"PA",""), "CON",1)-1 )
And for ContainerId
April 20, 2018 at 1:49 pm
April 20, 2018 at 12:52 pm
Hi Phil,
Thanks for your suggestion. I think I seem to understand it, but a...
April 20, 2018 at 9:16 am
April 20, 2018 at 7:39 am
April 20, 2018 at 7:23 am
Yes, there'll always be 'PO' or 'PA' and a 'CON' in the...
April 20, 2018 at 6:36 am
I'm hoping to get your guidance on this. I have a column, consisting of variable...
April 20, 2018 at 5:29 am
Viewing 15 posts - 4,501 through 4,515 (of 13,877 total)