Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

How, where do you use the expression builder at the package builder to write to a Package (Global Variable)? Expand / Collapse
Author
Message
Posted Thursday, November 5, 2009 1:48 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
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
Posted Saturday, November 7, 2009 4:46 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
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
Posted Monday, November 9, 2009 9:42 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
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
Posted Monday, November 9, 2009 9:56 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
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
Posted Monday, November 9, 2009 11:59 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
...

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
Posted Monday, November 9, 2009 12:03 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
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
Posted Monday, November 9, 2009 12:09 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
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
Posted Monday, November 9, 2009 1:08 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
.

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
Posted Monday, November 9, 2009 1:11 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
What is the error you get?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #816086
Posted Monday, November 9, 2009 1:44 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
.

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 »

Add to briefcase 123»»»

Permissions Expand / Collapse