question

ravi_sharma08 avatar image
ravi_sharma08 asked

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-2005ssis
10 |1200

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

WilliamD avatar image
WilliamD answered
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 comments
10 |1200

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

cant use third party tools here...:(
0 Likes 0 ·
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 Likes 0 ·
Daniel Ross avatar image
Daniel Ross answered
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

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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