Using regular expression parsing address in SSISHow to validate an email address in JavaScript?Is there a regular expression to detect a valid regular expression?How to validate an email address using a regular expression?Regular Expression for alphanumeric and underscoresRegular expression to match a line that doesn't contain a word?How do you access the matched groups in a JavaScript regular expression?Regular Expressions: Is there an AND operator?How do you use a variable in a regular expression?Convert a char to upper case using regular expressions (EditPad Pro)Is there a RegExp.escape function in Javascript?
15% tax on $7.5k earnings. Is that right?
What does chmod -u do?
Terse Method to Swap Lowest for Highest?
Why would a new[] expression ever invoke a destructor?
Moving brute-force search to FPGA
Pre-mixing cryogenic fuels and using only one fuel tank
When were female captains banned from Starfleet?
How should I respond when I lied about my education and the company finds out through background check?
What is Cash Advance APR?
How does a computer interpret real numbers?
Non-trope happy ending?
Extract more than nine arguments that occur periodically in a sentence to use in macros in order to typset
Temporarily disable WLAN internet access for children, but allow it for adults
A social experiment. What is the worst that can happen?
Biological Blimps: Propulsion
Why should universal income be universal?
Is aluminum electrical wire used on aircraft?
It grows, but water kills it
Why did the EU agree to delay the Brexit deadline?
How can "mimic phobia" be cured or prevented?
Are Captain Marvel's powers affected by Thanos' actions in Infinity War
What should you do when eye contact makes your subordinate uncomfortable?
Can I still be respawned if I die by falling off the map?
Strong empirical falsification of quantum mechanics based on vacuum energy density
Using regular expression parsing address in SSIS
How to validate an email address in JavaScript?Is there a regular expression to detect a valid regular expression?How to validate an email address using a regular expression?Regular Expression for alphanumeric and underscoresRegular expression to match a line that doesn't contain a word?How do you access the matched groups in a JavaScript regular expression?Regular Expressions: Is there an AND operator?How do you use a variable in a regular expression?Convert a char to upper case using regular expressions (EditPad Pro)Is there a RegExp.escape function in Javascript?
We know that there is no out of feature for Regular expression in SSIS. We came to know that we need to write .Net script in custom Script transformation. However, we would like to write Java method for this, could any help us whether SSIS can support this if support how can I can call this method in SSIS.
sql-server regex ssis etl script-component edited yesterday
Hadi
22.2k72974
asked yesterday
Prasad KadaPrasad Kada
161
add a comment |
We know that there is no out of feature for Regular expression in SSIS. We came to know that we need to write .Net script in custom Script transformation. However, we would like to write Java method for this, could any help us whether SSIS can support this if support how can I can call this method in SSIS.
sql-server regex ssis etl script-component edited yesterday
Hadi
22.2k72974
asked yesterday
Prasad KadaPrasad Kada
161
1
If you can write a Java library or .dll , you should be able to import it into the c# script with the using statement like most other external librarys you can import into c# scripts.
– Brad
yesterday
1
@Prasad based on purplefrogsystems.com/blog/2011/07/… this is not a limitation. A one liner to import RegExusing System.Text.RegularExpressions;But using Java methods is a long and complicated unnecessary road to go in my view.
– Arthur
yesterday
add a comment |
We know that there is no out of feature for Regular expression in SSIS. We came to know that we need to write .Net script in custom Script transformation. However, we would like to write Java method for this, could any help us whether SSIS can support this if support how can I can call this method in SSIS.
sql-server regex ssis etl script-component edited yesterday
Hadi
22.2k72974
asked yesterday
Prasad KadaPrasad Kada
161
We know that there is no out of feature for Regular expression in SSIS. We came to know that we need to write .Net script in custom Script transformation. However, we would like to write Java method for this, could any help us whether SSIS can support this if support how can I can call this method in SSIS.
sql-server regex ssis etl script-component sql-server regex ssis etl script-component edited yesterday
Hadi
22.2k72974
asked yesterday
Prasad KadaPrasad Kada
161
edited yesterday
Hadi
22.2k72974
asked yesterday
Prasad KadaPrasad Kada
161
edited yesterday
Hadi
22.2k72974
edited yesterday
Hadi
22.2k72974
edited yesterday
Hadi
22.2k72974
22.2k72974
asked yesterday
Prasad KadaPrasad Kada
161
asked yesterday
Prasad KadaPrasad Kada
161
asked yesterday
Prasad KadaPrasad Kada
161
161
1
If you can write a Java library or .dll , you should be able to import it into the c# script with the using statement like most other external librarys you can import into c# scripts.
– Brad
yesterday
1
@Prasad based on purplefrogsystems.com/blog/2011/07/… this is not a limitation. A one liner to import RegExusing System.Text.RegularExpressions;But using Java methods is a long and complicated unnecessary road to go in my view.
– Arthur
yesterday
add a comment |
1
If you can write a Java library or .dll , you should be able to import it into the c# script with the using statement like most other external librarys you can import into c# scripts.
– Brad
yesterday
1
@Prasad based on purplefrogsystems.com/blog/2011/07/… this is not a limitation. A one liner to import RegExusing System.Text.RegularExpressions;But using Java methods is a long and complicated unnecessary road to go in my view.
– Arthur
yesterday
1
1
If you can write a Java library or .dll , you should be able to import it into the c# script with the using statement like most other external librarys you can import into c# scripts.
– Brad
yesterday
If you can write a Java library or .dll , you should be able to import it into the c# script with the using statement like most other external librarys you can import into c# scripts.
– Brad
yesterday
1
1
@Prasad based on purplefrogsystems.com/blog/2011/07/… this is not a limitation. A one liner to import RegEx
using System.Text.RegularExpressions; But using Java methods is a long and complicated unnecessary road to go in my view.– Arthur
yesterday
@Prasad based on purplefrogsystems.com/blog/2011/07/… this is not a limitation. A one liner to import RegEx
using System.Text.RegularExpressions; But using Java methods is a long and complicated unnecessary road to go in my view.– Arthur
yesterday
add a comment |
1 Answer
1
active
oldest
votes
Why using Java while there are easier solutions to implement??
(1) Flat File Regex source
If you are looking to use Regular Expression on a Flat File Source, then you can benefit from the Flat File Regular Expression Source created by Microsoft community:
- GitHub - SQL Server community samples
(2) Regex within Scripts
Also if you are looking to implement regular expression inside Script Task or Script Component you can benefit from the System.Text.RegularExpression library which is apart from the .Net Framework. THere are plenty of tutorials found online:
- Regex Class
- C# RegEx match examples
- Using Regular Expressions in C#
- C# - Regular Expressions
(3) Regular expression transformation
Also there are some third part Regex transformation components:
- Regular Expression Transformation
- RegexClean Transformation
Helpful articles
- DATA CLEANSING WITH REGULAR EXPRESSIONS IN SSIS
- SSIS: Transform data using Regex
- Pattern matching in SSIS using Regular Expressions and the Script component
answered yesterday
HadiHadi
22.2k72974
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55280873%2fusing-regular-expression-parsing-address-in-ssis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Why using Java while there are easier solutions to implement??
(1) Flat File Regex source
If you are looking to use Regular Expression on a Flat File Source, then you can benefit from the Flat File Regular Expression Source created by Microsoft community:
- GitHub - SQL Server community samples
(2) Regex within Scripts
Also if you are looking to implement regular expression inside Script Task or Script Component you can benefit from the System.Text.RegularExpression library which is apart from the .Net Framework. THere are plenty of tutorials found online:
- Regex Class
- C# RegEx match examples
- Using Regular Expressions in C#
- C# - Regular Expressions
(3) Regular expression transformation
Also there are some third part Regex transformation components:
- Regular Expression Transformation
- RegexClean Transformation
Helpful articles
- DATA CLEANSING WITH REGULAR EXPRESSIONS IN SSIS
- SSIS: Transform data using Regex
- Pattern matching in SSIS using Regular Expressions and the Script component
answered yesterday
HadiHadi
22.2k72974
add a comment |
Why using Java while there are easier solutions to implement??
(1) Flat File Regex source
If you are looking to use Regular Expression on a Flat File Source, then you can benefit from the Flat File Regular Expression Source created by Microsoft community:
- GitHub - SQL Server community samples
(2) Regex within Scripts
Also if you are looking to implement regular expression inside Script Task or Script Component you can benefit from the System.Text.RegularExpression library which is apart from the .Net Framework. THere are plenty of tutorials found online:
- Regex Class
- C# RegEx match examples
- Using Regular Expressions in C#
- C# - Regular Expressions
(3) Regular expression transformation
Also there are some third part Regex transformation components:
- Regular Expression Transformation
- RegexClean Transformation
Helpful articles
- DATA CLEANSING WITH REGULAR EXPRESSIONS IN SSIS
- SSIS: Transform data using Regex
- Pattern matching in SSIS using Regular Expressions and the Script component
answered yesterday
HadiHadi
22.2k72974
add a comment |
Why using Java while there are easier solutions to implement??
(1) Flat File Regex source
If you are looking to use Regular Expression on a Flat File Source, then you can benefit from the Flat File Regular Expression Source created by Microsoft community:
- GitHub - SQL Server community samples
(2) Regex within Scripts
Also if you are looking to implement regular expression inside Script Task or Script Component you can benefit from the System.Text.RegularExpression library which is apart from the .Net Framework. THere are plenty of tutorials found online:
- Regex Class
- C# RegEx match examples
- Using Regular Expressions in C#
- C# - Regular Expressions
(3) Regular expression transformation
Also there are some third part Regex transformation components:
- Regular Expression Transformation
- RegexClean Transformation
Helpful articles
- DATA CLEANSING WITH REGULAR EXPRESSIONS IN SSIS
- SSIS: Transform data using Regex
- Pattern matching in SSIS using Regular Expressions and the Script component
answered yesterday
HadiHadi
22.2k72974
Why using Java while there are easier solutions to implement??
(1) Flat File Regex source
If you are looking to use Regular Expression on a Flat File Source, then you can benefit from the Flat File Regular Expression Source created by Microsoft community:
- GitHub - SQL Server community samples
(2) Regex within Scripts
Also if you are looking to implement regular expression inside Script Task or Script Component you can benefit from the System.Text.RegularExpression library which is apart from the .Net Framework. THere are plenty of tutorials found online:
- Regex Class
- C# RegEx match examples
- Using Regular Expressions in C#
- C# - Regular Expressions
(3) Regular expression transformation
Also there are some third part Regex transformation components:
- Regular Expression Transformation
- RegexClean Transformation
Helpful articles
- DATA CLEANSING WITH REGULAR EXPRESSIONS IN SSIS
- SSIS: Transform data using Regex
- Pattern matching in SSIS using Regular Expressions and the Script component
answered yesterday
HadiHadi
22.2k72974
edited 9 hours ago
answered yesterday
HadiHadi
22.2k72974
answered yesterday
HadiHadi
22.2k72974
answered yesterday
HadiHadi
22.2k72974
22.2k72974
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55280873%2fusing-regular-expression-parsing-address-in-ssis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
If you can write a Java library or .dll , you should be able to import it into the c# script with the using statement like most other external librarys you can import into c# scripts.
– Brad
yesterday
1
@Prasad based on purplefrogsystems.com/blog/2011/07/… this is not a limitation. A one liner to import RegEx
using System.Text.RegularExpressions;But using Java methods is a long and complicated unnecessary road to go in my view.– Arthur
yesterday