<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 Integration Services
»
How, where do you use the expression builder...
25 posts, Page 1 of 3
1
2
3
»
»»
How, where do you use the expression builder at the package builder to write to a Package (Global Variable)?
Rate Topic
Display Mode
Topic Options
Author
Message
Welsh Corgi
Welsh Corgi
Posted Thursday, November 05, 2009 1:48 PM
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 6:19 AM
Points: 3,833,
Visits: 4,052
Can you concatenate variables at the Package Level like in DTS with Global Variables?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #814547
CozyRoc
CozyRoc
Posted Saturday, November 07, 2009 4:46 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 10:02 AM
Points: 1,106,
Visits: 2,115
Kent Krug-210111 (11/5/2009)
Can you concatenate variables at the Package Level like in DTS with Global Variables?
I don't remember what it was in DTS, but in SSIS it possible to do it in two ways:
1. You can use expressions. Check this
post
for more information.
2. You can use script. The input variables have to be specified in the
ReadOnlyVariables
property. The output result variable has to be specified in the
ReadWriteVariables
property.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Post #815489
Welsh Corgi
Welsh Corgi
Posted Monday, November 09, 2009 9:42 AM
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 6:19 AM
Points: 3,833,
Visits: 4,052
Thanks for sharing this with me.
The problem that I'm still having is that I can change the value of a User Variable with Package Scope and view the change it break mode.
However after I stop debugging the original value persist.
In DTS the value of the Global Variable would be set to value that it was changed to when the Package was run.
Regards,
Kent
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #815906
CozyRoc
CozyRoc
Posted Monday, November 09, 2009 9:56 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 10:02 AM
Points: 1,106,
Visits: 2,115
Kent Krug-210111 (11/9/2009)
Thanks for sharing this with me.
The problem that I'm still having is that I can change the value of a User Variable with Package Scope and view the change it break mode.
However after I stop debugging the original value persist.
In DTS the value of the Global Variable would be set to value that it was changed to when the Package was run.
Regards,
Kent
This behavior is
by design
. The variable value you set is only there at runtime. After the package finishes executing, it restores back to what it was set in the package design or to what you have have specified in the configuration file.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Post #815922
Welsh Corgi
Welsh Corgi
Posted Monday, November 09, 2009 11:59 AM
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 6:19 AM
Points: 3,833,
Visits: 4,052
...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #816016
Welsh Corgi
Welsh Corgi
Posted Monday, November 09, 2009 12:03 PM
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 6:19 AM
Points: 3,833,
Visits: 4,052
Sorry, I missed this is behavior by design.\
But it is killing me. I can dynamically create a file but when I try to use an expression as an attachment in the FTP Task it bombs out on me.
Thanks,
Kent
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #816022
CozyRoc
CozyRoc
Posted Monday, November 09, 2009 12:09 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 10:02 AM
Points: 1,106,
Visits: 2,115
Kent Krug-210111 (11/9/2009)
Sorry, I missed this is behavior by design.\
But it is killing me. I can dynamically create a file but when I try to use an expression as an attachment in the FTP Task it bombs out on me.
Thanks,
Kent
What do you mean as attachment? Do you mean specifiyng the source? Can you post the complete error you are getting?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Post #816027
Welsh Corgi
Welsh Corgi
Posted Monday, November 09, 2009 1:08 PM
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 6:19 AM
Points: 3,833,
Visits: 4,052
.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #816081
CozyRoc
CozyRoc
Posted Monday, November 09, 2009 1:11 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 10:02 AM
Points: 1,106,
Visits: 2,115
What is the error you get?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Post #816086
Welsh Corgi
Welsh Corgi
Posted Monday, November 09, 2009 1:44 PM
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 6:19 AM
Points: 3,833,
Visits: 4,052
.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #816097
« Prev Topic
|
Next Topic »
25 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
