I have a package the basically splits all tables in our database 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. 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? The package is table driven and has one SEQC, with five DFT that provide data for five FELC containing a script task, that is setting a where clause base on another value. Next is an Execute SQL task to create table, CozyRoc DFTP, Execute SQL Task creating indexes and finally another Execute SQL task to update the table driving the package. I am sorry this is so long but I appreciate any advice as I have search everything on the web I could find and nothing has worked so far. I am working with SSMS version Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) (Build 7601: Service Pack 1) Thanks!
I see the same thing all the time with encrypted SQL 2012 packages. The encrypted string goes all on a single 50,000 character line. If you have FTP going on I would imagine you are in the same situation. I just click yes and continue working. After you open the package, right-click it in solution explorer and select view code to see what your xml looks like.