Showing posts with label line. Show all posts
Showing posts with label line. Show all posts

Monday, March 26, 2012

Long line of text error

Hey,
After working on a package for a while, I started to get the following error
when re-opening the package:
"Document contains one or more extremely long lines of text.
These lines will cause the editor to respond slowly when you open the file.
Do you still want to open the file?"
What is the problem and if there is fix or workaround?
Thanks.There is no fix or workaround however don't worry because there isn't a problem either. Its just a VS thing rather than a SSIS thing that's all.

I think (but may be wrong) it appears when you have a pre-compiled script task/component in your package. Perhaps you could confirm?

-Jamie|||Yes, I have precompiled script tasks in package. Otherwise they don't work :)|||Don't they?

This is a complete digression from the main point of this thread but...why not? What error do you get?

-Jamie

P.S. As I say, forget about the "long lines of text" thing!|||it's on this tread
http://forums.microsoft.com/msdn/showpost.aspx?postid=68546&siteid=1
actually I had the same problem. with precompilation I get no error.

ps. thanks for answering on "long line text..." stuff.

Wednesday, March 21, 2012

logs - configuration option changed

Using SS2000. I often see a line in the logs that says "configuration opton 'allow updates' changed from 0 to 1. Run the RECONFIGURE s Error 15457, serverity 0, State 1"
Another entry will change the option from 1 to 0. What's going on? Is a dts package doing this as part of a normal run?
Thanks,
Dan D.
That is usually associated with someone using EM to view certain options.
It is nothing to be concerned with.
Andrew J. Kelly SQL MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:FAD761D0-4D1B-4EB4-BF9E-18155CC0ED9C@.microsoft.com...
> Using SS2000. I often see a line in the logs that says "configuration
opton 'allow updates' changed from 0 to 1. Run the RECONFIGURE s Error
15457, serverity 0, State 1"
> Another entry will change the option from 1 to 0. What's going on? Is a
dts package doing this as part of a normal run?
> Thanks,
> --
> Dan D.
|||No one claims to have been on the system at that time (1 AM local time). Could some system process make the changes?
Thanks,
Dan D.
"Andrew J. Kelly" wrote:

> That is usually associated with someone using EM to view certain options.
> It is nothing to be concerned with.
> --
> Andrew J. Kelly SQL MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:FAD761D0-4D1B-4EB4-BF9E-18155CC0ED9C@.microsoft.com...
> opton 'allow updates' changed from 0 to 1. Run the RECONFIGURE s Error
> 15457, serverity 0, State 1"
> dts package doing this as part of a normal run?
>
>
|||Do you have a maintenance plan set up and if so does it have the option to
fix minor errors? This may cause an entry like this but I am not 100 %
sure. Are there any scheduled jobs that collect information from the server
with say sp_dboption?
Andrew J. Kelly SQL MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:95E34CD1-BDFA-423B-B05B-C319F7E8E3E3@.microsoft.com...
> No one claims to have been on the system at that time (1 AM local time).
Could some system process make the changes?[vbcol=seagreen]
> Thanks,
> --
> Dan D.
>
> "Andrew J. Kelly" wrote:
options.[vbcol=seagreen]
a[vbcol=seagreen]
|||There are no maintenance plans. There was one dts package that was running at the time of the message. I'll look through it and see what I can find.
Thanks,
Dan D.
"Andrew J. Kelly" wrote:

> Do you have a maintenance plan set up and if so does it have the option to
> fix minor errors? This may cause an entry like this but I am not 100 %
> sure. Are there any scheduled jobs that collect information from the server
> with say sp_dboption?
> --
> Andrew J. Kelly SQL MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:95E34CD1-BDFA-423B-B05B-C319F7E8E3E3@.microsoft.com...
> Could some system process make the changes?
> options.
> a
>
>

logs - configuration option changed

Using SS2000. I often see a line in the logs that says "configuration opton
'allow updates' changed from 0 to 1. Run the RECONFIGURE s Error 15457, serv
erity 0, State 1"
Another entry will change the option from 1 to 0. What's going on? Is a dts
package doing this as part of a normal run?
Thanks,
--
Dan D.That is usually associated with someone using EM to view certain options.
It is nothing to be concerned with.
Andrew J. Kelly SQL MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:FAD761D0-4D1B-4EB4-BF9E-18155CC0ED9C@.microsoft.com...
> Using SS2000. I often see a line in the logs that says "configuration
opton 'allow updates' changed from 0 to 1. Run the RECONFIGURE s Error
15457, serverity 0, State 1"
> Another entry will change the option from 1 to 0. What's going on? Is a
dts package doing this as part of a normal run?
> Thanks,
> --
> Dan D.|||No one claims to have been on the system at that time (1 AM local time). Cou
ld some system process make the changes?
Thanks,
--
Dan D.
"Andrew J. Kelly" wrote:

> That is usually associated with someone using EM to view certain options.
> It is nothing to be concerned with.
> --
> Andrew J. Kelly SQL MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:FAD761D0-4D1B-4EB4-BF9E-18155CC0ED9C@.microsoft.com...
> opton 'allow updates' changed from 0 to 1. Run the RECONFIGURE s Error
> 15457, serverity 0, State 1"
> dts package doing this as part of a normal run?
>
>|||Do you have a maintenance plan set up and if so does it have the option to
fix minor errors? This may cause an entry like this but I am not 100 %
sure. Are there any scheduled jobs that collect information from the server
with say sp_dboption?
Andrew J. Kelly SQL MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:95E34CD1-BDFA-423B-B05B-C319F7E8E3E3@.microsoft.com...
> No one claims to have been on the system at that time (1 AM local time).
Could some system process make the changes?[vbcol=seagreen]
> Thanks,
> --
> Dan D.
>
> "Andrew J. Kelly" wrote:
>
options.[vbcol=seagreen]
a[vbcol=seagreen]|||There are no maintenance plans. There was one dts package that was running a
t the time of the message. I'll look through it and see what I can find.
Thanks,
--
Dan D.
"Andrew J. Kelly" wrote:

> Do you have a maintenance plan set up and if so does it have the option to
> fix minor errors? This may cause an entry like this but I am not 100 %
> sure. Are there any scheduled jobs that collect information from the serv
er
> with say sp_dboption?
> --
> Andrew J. Kelly SQL MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:95E34CD1-BDFA-423B-B05B-C319F7E8E3E3@.microsoft.com...
> Could some system process make the changes?
> options.
> a
>
>