November 5, 2009 at 1:48 pm
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/
November 7, 2009 at 4:46 pm
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.
November 9, 2009 at 9:42 am
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/
November 9, 2009 at 9:56 am
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.
November 9, 2009 at 11:59 am
...
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/
November 9, 2009 at 12:03 pm
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/
November 9, 2009 at 12:09 pm
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?
November 9, 2009 at 1:08 pm
.
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/
November 9, 2009 at 1:11 pm
November 9, 2009 at 1:44 pm
.
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/
November 9, 2009 at 1:48 pm
November 9, 2009 at 1:49 pm
BTW, tks again.
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/
November 9, 2009 at 2:00 pm
.
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/
November 9, 2009 at 2:12 pm
.
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/
November 9, 2009 at 3:12 pm
.
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/
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply