August 20, 2014 at 5:20 pm
Hello All,
This is the error I an trying to resolve.
Document contains one or more extremely long line 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 have a package that basically splits all tables in one of our databases out to five other servers based on a key column. I am not sure how much information I should provide but I need to know what are the possible causes for this error message when opening the package and would it affect Zeke scheduling?
The package is table driven and has one SEQC, with five DFT that provide data for five FELC, each containing a script task (that is setting a where clause base on another table value.), an Execute SQL task to create table, CozyRoc DFTP (transferring the data from source to target), an Execute SQL Task (creating indexes) and finally another Execute SQL task to update the table driving the package that the table was loaded. I am sorry this is so long and I appreciate any advice. I have searched most of issues on the web and haven't found anything that works. I am working in BIDS with SSMS version Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X32) (Build 7601: Service Pack 1)
Thanks!
The pain of Discipline is far better than the pain of Regret!
August 20, 2014 at 5:32 pm
This isn't so much a error, but an informational warning that it may take a bit to open the package and the editor may be slow.
I have had that occur with some of the packages I have created and sometimes it is unavoidable.
August 20, 2014 at 5:40 pm
Lynn,
I appreciate the information. The packages that you have with this informational message, are they not affected but scheduling the package for automation, like Zeke or SQL Server Agent? I just want to double check before it gets deployed and is unable to run.
Cheers!
Tim
The pain of Discipline is far better than the pain of Regret!
August 20, 2014 at 6:03 pm
Never had a problem with them running at my previous employer. Just a bit of a pain when they needed to be modified.
August 20, 2014 at 6:05 pm
Lynn,
Thank you again for your time, I greatly appreciate it.
Tim
The pain of Discipline is far better than the pain of Regret!
August 21, 2014 at 12:32 am
Lynn Pettis (8/20/2014)
This isn't so much a error, but an informational warning that it may take a bit to open the package and the editor may be slow.I have had that occur with some of the packages I have created and sometimes it is unavoidable.
I never had that warning before.
What did you do (or not do ;-)) to get it?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 21, 2014 at 7:01 am
Koen Verbeeck (8/21/2014)
Lynn Pettis (8/20/2014)
This isn't so much a error, but an informational warning that it may take a bit to open the package and the editor may be slow.I have had that occur with some of the packages I have created and sometimes it is unavoidable.
I never had that warning before.
What did you do (or not do ;-)) to get it?
Now you are asking me to remember back over 4 years. I really can't remember specifics. I just know I had that issue with a couple of monster packages. Since the worked, and worked well, I never went back to see if I could eliminate the message.
August 21, 2014 at 9:29 am
Hello Keon,
I open the view code from the solution explorer and reviewed the XML code. I have 5 different variables that I am using to store long T-SQL code with a max length of 1958. I wouldn't think that would be the issue but it was the longest section of code in the solution. I hope this helps.
The pain of Discipline is far better than the pain of Regret!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply