Edit a step from a job

I can't edit a step (or create a new one) form an Agent job.
I get General acces denied error.
On details I see at program location
Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_LogProviderInfos()
Microsoft.SqlServer.Dts.Runtime.Application.get_LogProviderInfos()
I use a client station to acces the server
On server works fine
Any ideas ?Does the logon details you're using from the client have rights to change
the job details?
--
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Sorin Popescu" <spopescu@.nospam.com> wrote in message
news:OZyCCE4kGHA.4224@.TK2MSFTNGP05.phx.gbl...
> I can't edit a step (or create a new one) form an Agent job.
> I get General acces denied error.
> On details I see at program location
>
Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_LogProviderInfo
s()
> Microsoft.SqlServer.Dts.Runtime.Application.get_LogProviderInfos()
> I use a client station to acces the server
> On server works fine
> Any ideas ?
>|||How can I verify that please ?
"Jack Vamvas" <DEL_TO_REPLYtechsupport@.ciquery.com> wrote in message
news:2-ednVMta7jY5AvZRVnyvQ@.bt.com...
> Does the logon details you're using from the client have rights to change
> the job details?
> --
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> ___________________________________
>
> "Sorin Popescu" <spopescu@.nospam.com> wrote in message
> news:OZyCCE4kGHA.4224@.TK2MSFTNGP05.phx.gbl...
>> I can't edit a step (or create a new one) form an Agent job.
>> I get General acces denied error.
>> On details I see at program location
> Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_LogProviderInfo
> s()
>> Microsoft.SqlServer.Dts.Runtime.Application.get_LogProviderInfos()
>> I use a client station to acces the server
>> On server works fine
>> Any ideas ?
>>
>|||It's the owner of job
"Jack Vamvas" <DEL_TO_REPLYtechsupport@.ciquery.com> wrote in message
news:2-ednVMta7jY5AvZRVnyvQ@.bt.com...
> Does the logon details you're using from the client have rights to change
> the job details?
> --
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> ___________________________________
>
> "Sorin Popescu" <spopescu@.nospam.com> wrote in message
> news:OZyCCE4kGHA.4224@.TK2MSFTNGP05.phx.gbl...
>> I can't edit a step (or create a new one) form an Agent job.
>> I get General acces denied error.
>> On details I see at program location
> Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_LogProviderInfo
> s()
>> Microsoft.SqlServer.Dts.Runtime.Application.get_LogProviderInfos()
>> I use a client station to acces the server
>> On server works fine
>> Any ideas ?
>>
>sql

Dynamically change the Image Location

I've hunted all over for the answer to this without success...
I'm trying to display a company logo at the top of the report, but read from
the database whether the logo is left justified, right justified, or
centered. I figured I would just adjust the Left property of the image to
get it left/right/centered, but I can't find any way to modify the Location
of the image other than to set it at design time.
I found one suggestion to stretch the image control and use padding to
"center" the image, the problem however is that I also need to dynamically
locate the company address depending on the location of the logo. <sigh>
As usual when I can't find a solution, I'm getting that ominous
"it's-right-in-your-face" feeling...
Thanks,
JLSTom, I am running into the same issues. I want to dynamically change the
<Top> position of an image depending on a value passed to a Function. I am
not having any luck either. Just wondering if you found a work around?
Thanks, Phill
"Tom Rocco" wrote:
> I've hunted all over for the answer to this without success...
> I'm trying to display a company logo at the top of the report, but read from
> the database whether the logo is left justified, right justified, or
> centered. I figured I would just adjust the Left property of the image to
> get it left/right/centered, but I can't find any way to modify the Location
> of the image other than to set it at design time.
> I found one suggestion to stretch the image control and use padding to
> "center" the image, the problem however is that I also need to dynamically
> locate the company address depending on the location of the logo. <sigh>
> As usual when I can't find a solution, I'm getting that ominous
> "it's-right-in-your-face" feeling...
> Thanks,
> JLS
>
>

Dynamic XSD Schema Location For XML Source

I want to be able to programmatically set the schema location for an XML source. I first thought it would be a simple task using expressions and variables but it doesn't appear to allow anything in the way of setting it at runtime. Is this possible?

It does allow it, but you don't set the expression directly on the component. You have to set it on the data-flow that contains the component.

Switch back to control-flow and look at expressions of the data-flow. Its self-explanatory from there.

-Jamie

|||Beautiful! Thank you.|||Thanks Jamie... just wanted to chime in and say this was really helpful - I would have never thought of looking on the properties of the data flow.