using a particuler format for variable in ssis

Question

question

ravi_sharma08 asked Dec 17, '10

using a particuler format for variable in ssis

hi, i have a variable which is used as an input. i want make sure that the values that come in from this varibale should be of particular format: eg: 20081012_01_00005. so i have to make sure that the input that comes in should have 0-9 at all place and _ at some places. some thing like *********_**_***** i am not able to find the appropriate expression to do so. this is in regards with SSIS 2005. please help. regards ravi

sql-server-2005 ssis

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-12-17T05:37:21Z

WilliamD answered Dec 17, '10

You would want to take a look at maybe using regex to help enforce the shape of the data. Try [Expresso][1] or any one of the many expression builders on the web. [1]: http://www.ultrapico.com/Expresso.htm

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ravi_sharma08 commented · Dec 17, 2010 at 06:15 AM

cant use third party tools here...:(

0 ·

WilliamD commented · Dec 17, 2010 at 06:23 AM

you wouldn't need to use a third party tool, you just need to build the regex expression. This is one of many that will build the expression for you, otherwise use a web-based one (try google).

0 ·

Answer 2 · 2010-12-19T15:40:06Z

Daniel Ross answered Dec 19, '10

i know you said you can't use a thid party tool, but what about a microsoft tool? http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c16f11ad-150a-4091-b3a2-83d21d3e0973&displaylang=en If you still can't install it (you have to install on dev and prod environments), then you could use a script task in the dataflow with a regex component in the script.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question