question

SQLArnold avatar image
SQLArnold asked

SSIS Error Message when opening package

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!
error-messageerror message
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
KenJ avatar image
KenJ answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SQLArnold avatar image SQLArnold commented ·
Hi Ken, You are correct, I am able to view what the problem in in the XML, view code. I have some really long SQL commands as variable values and they were causing the problem. Thanks for your time and assistance!! Tim
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.