Showing posts with label consider. Show all posts
Showing posts with label consider. Show all posts

Friday, March 9, 2012

Reference for SSIS "C-like" script needed

Consider the Conditional Split task. I can use a C-like language to create statements such as

Ltrim ([Col1] =”A”) ||Ltrim([Col1] =”B”)

This sure ain’t VB-like and the list of functions in the upper right-hand pane of the task(“expression editor”) does not help me construct such statements.

Where is the reference manual describing this language?

TIA,

Barkingdog

P.S. I have found fragments in BOL but the info does not seem complete and the BOL topic fragmentation impedes learning.

P.P.S.Why MS uses this language instead of VB.NET, which they use in their Script tasks, is beyond me.

A few hours of looking around gave me this pointer:

http://msdn2.microsoft.com/en-us/library/ms141827.aspx

|||

>P.P.S. Why MS uses this language instead of VB.NET, which they use in their Script tasks, is beyond me.

One of the key reasons is that languages such as VB.Net, or SQL for that matter, include flow of control and procedural constructs which would be unsuitable for use in an expression language. So does C, of course, but it is easier to create a subset of the C grammar without those constructs.

I used to worry that the expression syntax would be a real problem for folks, but I have to admit that (a) most people appear to be using very simple expressions and get the hang of it pretty quickly and (b) those that do need complex expressions are on the whole able to get to grips with the syntax, with the help of the reference you found.

I'd be interested to hear other opinions, of course ...

Donald

Saturday, February 25, 2012

Reducing Spam Associated with Posting to Newsgroups

Due to a recent increase in spam sent to posters in newsgroups, Microsoft advises that newsgroup participants should consider avoiding posting to newsgroups using their real email address. Microsoft is also committed to continuing to address the issue of spam from a technological perspective.
To help avoid receiving unwanted messages (spam) in your regular e-mail account, you may not want to include your regular e-mail address when you post a question or reply to a post in a discussion group. Instead you may want to do one of the following:
* Use a modified e-mail address: Use a different version of your e-mail address that others will understand, but that spam tools can't automatically pick up. For example, if your actual e-mail address is "emailname@.account.com", consider using a modified e-mail address such as: "emailnameaccount.com.invalid", emailname@.REMOVE_CAPS_AND_INVALIDaccount.com.invalid, or emailname@.account.com.NO_SPAM. In this case, the spam tools will send mail to an invalid e-mail address, and others will know to exclude the "(removethis)" when they send you e-mail. When you post a question or reply to a discussion group, just enter your modified e-mail address in the appropriate box.
* Use a secondary e-mail account: Set up or use an e-mail account, such as a Hotmail account, that is separate from your primary account for posting to discussion groups. When you post a question or reply to a discussion group, use your Hotmail account as your e-mail address.
If you have feedback or questions about this, please post a reply in the newsgroup, or contact us at http://register.microsoft.com/contactus30/contactus.asp?domain=communities
Thanks!
Microsoft Communities Teammy mailbox has been flooded with spam now.
Rather than changing email address i think
the right solution should be developing spam filters
which will stop it.
I think yahoo has much beter filter than MS.
>--Original Message--
>Due to a recent increase in spam sent to posters in
newsgroups, Microsoft advises that newsgroup participants
should consider avoiding posting to newsgroups using their
real email address. Microsoft is also committed to
continuing to address the issue of spam from a
technological perspective.
>To help avoid receiving unwanted messages (spam) in your
regular e-mail account, you may not want to include your
regular e-mail address when you post a question or reply
to a post in a discussion group. Instead you may want to
do one of the following:
>* Use a modified e-mail address: Use a different version
of your e-mail address that others will understand, but
that spam tools can't automatically pick up. For example,
if your actual e-mail address is "emailname@.account.com",
consider using a modified e-mail address such
as: "emailnameaccount.com.invalid",
emailname@.REMOVE_CAPS_AND_INVALIDaccount.com.invalid, or
emailname@.account.com.NO_SPAM. In this case, the spam
tools will send mail to an invalid e-mail address, and
others will know to exclude the "(removethis)" when they
send you e-mail. When you post a question or reply to a
discussion group, just enter your modified e-mail address
in the appropriate box.
>* Use a secondary e-mail account: Set up or use an e-mail
account, such as a Hotmail account, that is separate from
your primary account for posting to discussion groups.
When you post a question or reply to a discussion group,
use your Hotmail account as your e-mail address.
>If you have feedback or questions about this, please post
a reply in the newsgroup, or contact us at
http://register.microsoft.com/contactus30/contactus.asp?
domain=communities
>Thanks!
>Microsoft Communities Team
>.
>|||But where should those spam filters exist? If your inbox is being spammed,
then it's because your email address was harvested. If you post your email
address in a publicly accessible forum, such as an NNTP Server like
msnews.microsoft.com, it's going to get harvested and the spam filter needs
to live on your inbox. If the problem is actually that you're seeing too
much spam in these newsgroups, well, we're working on that.
Mind you, I understand your frustration and I'm getting a ton of it too,
but this isn't specific to msnews.microsoft.com or the Microsoft-hosted
newsgroups and the obvious workaround is simply to not give the spammers
any ammunition. :-)
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
| From: "Samir" <samir@.yahoo.com>
|
| my mailbox has been flooded with spam now.
|
| Rather than changing email address i think
| the right solution should be developing spam filters
| which will stop it.
|
|
| I think yahoo has much beter filter than MS.
|
|
|
|
|
| >--Original Message--
| >Due to a recent increase in spam sent to posters in
| newsgroups, Microsoft advises that newsgroup participants
| should consider avoiding posting to newsgroups using their
| real email address. Microsoft is also committed to
| continuing to address the issue of spam from a
| technological perspective.
| >
| >To help avoid receiving unwanted messages (spam) in your
| regular e-mail account, you may not want to include your
| regular e-mail address when you post a question or reply
| to a post in a discussion group. Instead you may want to
| do one of the following:
| >
| >* Use a modified e-mail address: Use a different version
| of your e-mail address that others will understand, but
| that spam tools can't automatically pick up. For example,
| if your actual e-mail address is "emailname@.account.com",
| consider using a modified e-mail address such
| as: "emailnameaccount.com.invalid",
| emailname@.REMOVE_CAPS_AND_INVALIDaccount.com.invalid, or
| emailname@.account.com.NO_SPAM. In this case, the spam
| tools will send mail to an invalid e-mail address, and
| others will know to exclude the "(removethis)" when they
| send you e-mail. When you post a question or reply to a
| discussion group, just enter your modified e-mail address
| in the appropriate box.
| >
| >* Use a secondary e-mail account: Set up or use an e-mail
| account, such as a Hotmail account, that is separate from
| your primary account for posting to discussion groups.
| When you post a question or reply to a discussion group,
| use your Hotmail account as your e-mail address.
| >
| >If you have feedback or questions about this, please post
| a reply in the newsgroup, or contact us at
| http://register.microsoft.com/contactus30/contactus.asp?
| domain=communities
| >
| >Thanks!
| >Microsoft Communities Team
| >
| >.
| >
|