Compare The length of two string variables inside an Expression task in SSIS Announcing the...
Coloring maths inside a tcolorbox
How can I make names more distinctive without making them longer?
How discoverable are IPv6 addresses and AAAA names by potential attackers?
Book where humans were engineered with genes from animal species to survive hostile planets
What is Arya's weapon design?
How to bypass password on Windows XP account?
What's the meaning of 間時肆拾貳 at a car parking sign
What causes the vertical darker bands in my photo?
Fundamental Solution of the Pell Equation
Align equal signs while including text over equalities
Why aren't air breathing engines used as small first stages
Dating a Former Employee
What is the meaning of the new sigil in Game of Thrones Season 8 intro?
What's the purpose of writing one's academic biography in the third person?
English words in a non-english sci-fi novel
Overriding an object in memory with placement new
How does the particle を relate to the verb 行く in the structure「A を + B に行く」?
Generate an RGB colour grid
How can I (re)show post-installation notes?
Do I really need recursive chmod to restrict access to a folder?
What is a non-alternating simple group with big order, but relatively few conjugacy classes?
How widely used is the term Treppenwitz? Is it something that most Germans know?
What does the word "veer" mean here?
Why didn't this character "real die" when they blew their stack out in Altered Carbon?
Compare The length of two string variables inside an Expression task in SSIS
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)SSIS Event Handler at Package LevelError while executing SSIS package which contains Script component through SQL Server Agent JobSSIS: Trying to configure branching logic in Foreach loopSSIS Script Task doesn't appear to run when scheduledPassing NULL to SSIS variablesSSIS - Iterative Data Flow Task with Schema DifferencesSSIS Script Task appears to run, but actually doesn'tConditional Connection in SSIS based on Availability Group statusHow to read data from multiple Excel files with SQL Server Integration Services(New Senario)SSIS Error :Cannot roll back .No transaction or savepoint of that name was found
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
Hope you're doing well.
I need to compare the Length of two string variables inside an expression task in SSIS so that if they have the same length the package will execute the next step and if not it will stop
I've implemented something like this so far but it won't work
The images show My expression task and the regular expression within the
task and the precedence constraint from the expression task to the next step
ssis regular-expression
edited 2 mins ago
lzam
1112
asked Dec 15 '18 at 7:44
ShilaShila
184
add a comment |
Hope you're doing well.
I need to compare the Length of two string variables inside an expression task in SSIS so that if they have the same length the package will execute the next step and if not it will stop
I've implemented something like this so far but it won't work
The images show My expression task and the regular expression within the
task and the precedence constraint from the expression task to the next step
ssis regular-expression
edited 2 mins ago
lzam
1112
asked Dec 15 '18 at 7:44
ShilaShila
184
add a comment |
Hope you're doing well.
I need to compare the Length of two string variables inside an expression task in SSIS so that if they have the same length the package will execute the next step and if not it will stop
I've implemented something like this so far but it won't work
The images show My expression task and the regular expression within the
task and the precedence constraint from the expression task to the next step
ssis regular-expression
edited 2 mins ago
lzam
1112
asked Dec 15 '18 at 7:44
ShilaShila
184
Hope you're doing well.
I need to compare the Length of two string variables inside an expression task in SSIS so that if they have the same length the package will execute the next step and if not it will stop
I've implemented something like this so far but it won't work
The images show My expression task and the regular expression within the
task and the precedence constraint from the expression task to the next step
ssis regular-expression
ssis regular-expression
edited 2 mins ago
lzam
1112
asked Dec 15 '18 at 7:44
ShilaShila
184
edited 2 mins ago
lzam
1112
asked Dec 15 '18 at 7:44
ShilaShila
184
edited 2 mins ago
lzam
1112
edited 2 mins ago
lzam
1112
edited 2 mins ago
lzam
1112
1112
asked Dec 15 '18 at 7:44
ShilaShila
184
asked Dec 15 '18 at 7:44
ShilaShila
184
asked Dec 15 '18 at 7:44
ShilaShila
184
184
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I found the answer
I Created a variable @[User::Process] with Boolean data type and
I changed the Expression to this
@[User::Process] = (DT_BOOL)((DT_I4) LEN( @[User::FileFormat] )==LEN( @[User::ExcelName] ) ? 1: 0)
And Changed the precedence constraint of the expression task to This
answered Dec 15 '18 at 9:59
ShilaShila
184
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f225057%2fcompare-the-length-of-two-string-variables-inside-an-expression-task-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
I found the answer
I Created a variable @[User::Process] with Boolean data type and
I changed the Expression to this
@[User::Process] = (DT_BOOL)((DT_I4) LEN( @[User::FileFormat] )==LEN( @[User::ExcelName] ) ? 1: 0)
And Changed the precedence constraint of the expression task to This
answered Dec 15 '18 at 9:59
ShilaShila
184
add a comment |
I found the answer
I Created a variable @[User::Process] with Boolean data type and
I changed the Expression to this
@[User::Process] = (DT_BOOL)((DT_I4) LEN( @[User::FileFormat] )==LEN( @[User::ExcelName] ) ? 1: 0)
And Changed the precedence constraint of the expression task to This
answered Dec 15 '18 at 9:59
ShilaShila
184
add a comment |
I found the answer
I Created a variable @[User::Process] with Boolean data type and
I changed the Expression to this
@[User::Process] = (DT_BOOL)((DT_I4) LEN( @[User::FileFormat] )==LEN( @[User::ExcelName] ) ? 1: 0)
And Changed the precedence constraint of the expression task to This
answered Dec 15 '18 at 9:59
ShilaShila
184
I found the answer
I Created a variable @[User::Process] with Boolean data type and
I changed the Expression to this
@[User::Process] = (DT_BOOL)((DT_I4) LEN( @[User::FileFormat] )==LEN( @[User::ExcelName] ) ? 1: 0)
And Changed the precedence constraint of the expression task to This
answered Dec 15 '18 at 9:59
ShilaShila
184
answered Dec 15 '18 at 9:59
ShilaShila
184
answered Dec 15 '18 at 9:59
ShilaShila
184
answered Dec 15 '18 at 9:59
ShilaShila
184
184
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f225057%2fcompare-the-length-of-two-string-variables-inside-an-expression-task-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
