dbTalk Databases Forums  

Document contains one or more extemely long lines of text.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Document contains one or more extemely long lines of text. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jimdandy@shaw.ca
 
Posts: n/a

Default Document contains one or more extemely long lines of text. - 03-08-2006 , 02:57 PM






Hi All,

I'm getting (what I feel is a silly) message when I open a SSIS
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?"

I tried setting the precompilebinary property to false in the 4 script
tasks in the package, but BIDS still prompts me when I load it.

How can I prevent this error message? It's annoying when I load my
solution that has 20+ packages and this message pops up for every
package.

Any help would be appreciated!

Thanks,


Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default RE: Document contains one or more extemely long lines of text. - 03-09-2006 , 05:29 AM






I believe this is a feature of Visual studio, and since SSIS is now hosted
inside Visual Studio that is what you get. It seems that VS is a great host
for such components, provided they work rather like the existing Visual
Studio language components, and unfortunately this is not always the case.

Might I suggest you log it on the MSDN feedback center under SSIS-
http://lab.msdn.microsoft.com/ProductFeedback/

Post the reference number back here and others who agree can vote on it as
well. I know I will, it is mildly annoying.

One thing to try is close all packages in the solution, then save and exit.
This way when you reopen the solution it should be first of all faster as it
will not have to open and validate all those "open" packages, but you will
also not get prompted for all long lines on packages when they are
automatically opened.


"jimdandy (AT) shaw (DOT) ca" wrote:

Quote:
Hi All,

I'm getting (what I feel is a silly) message when I open a SSIS
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?"

I tried setting the precompilebinary property to false in the 4 script
tasks in the package, but BIDS still prompts me when I load it.

How can I prevent this error message? It's annoying when I load my
solution that has 20+ packages and this message pops up for every
package.

Any help would be appreciated!

Thanks,



Reply With Quote
  #3  
Old   
Jamie Thomson
 
Posts: n/a

Default RE: Document contains one or more extemely long lines of text. - 03-09-2006 , 04:01 PM



Jim,
I've observed that this seems to happen if you have precompiled script
tasks/components in your package. That's my rule of thumb - I'm not 100%
confident that it is the case.
Unfortunately, as Darren says, there is little you can do it. Is a minor
irritation that you will have o put up with I'm afraid.

-Jamie


"Darren Green" wrote:

Quote:
I believe this is a feature of Visual studio, and since SSIS is now hosted
inside Visual Studio that is what you get. It seems that VS is a great host
for such components, provided they work rather like the existing Visual
Studio language components, and unfortunately this is not always the case.

Might I suggest you log it on the MSDN feedback center under SSIS-
http://lab.msdn.microsoft.com/ProductFeedback/

Post the reference number back here and others who agree can vote on it as
well. I know I will, it is mildly annoying.

One thing to try is close all packages in the solution, then save and exit.
This way when you reopen the solution it should be first of all faster as it
will not have to open and validate all those "open" packages, but you will
also not get prompted for all long lines on packages when they are
automatically opened.


"jimdandy (AT) shaw (DOT) ca" wrote:

Hi All,

I'm getting (what I feel is a silly) message when I open a SSIS
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?"

I tried setting the precompilebinary property to false in the 4 script
tasks in the package, but BIDS still prompts me when I load it.

How can I prevent this error message? It's annoying when I load my
solution that has 20+ packages and this message pops up for every
package.

Any help would be appreciated!

Thanks,



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.