Home > SSIS Best Practices > Another Error on SSIS

Another Error on SSIS

Not sure what this means.


Categories: SSIS Best Practices
  1. July 23, 2010 at 5:16 pm


    Is this error generated in BIDS or the SSMS Export Wizard? Also, what version of SQL Server are you running?


    • Sherry Li 李雨
      July 23, 2010 at 7:34 pm


      The error is generated in SSMS, when trying to connecting to the Integration Services with Windows Authentication. We are running SQL Server 2005.


    • Sherry Li 李雨
      July 23, 2010 at 7:40 pm

      Like your blog at http://sqlsavvy.wordpress.com/


      • sqlsavvy
        July 27, 2010 at 3:13 pm


        Your blog is good, too. You have quality posts.


  2. sqlsavvy
    July 27, 2010 at 3:09 pm


    It sounds like either an unregistered dll (Dts.dll) or a permissions issue for the account executing a package.

    Check out this kb article for ways to fix a dll problem: http://support.microsoft.com/kb/919224

    Check out this forum post for troubleshooting a permissions issue: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/23c264d2-39eb-4d9a-8dba-83b0a555249d/


    • Sherry Li 李雨
      July 27, 2010 at 4:35 pm


      I totally forgot about the version issue. The error came up from SSMS 2008 when I tried to connect to a 2005 Integration Services. It works fine now from SSMS 2005.

      After using 2008 for so long, I keep forgetting about the version incompatibility issue.



  3. sqlsavvy
    July 28, 2010 at 2:36 pm


    Hotfixes, service packs, and versions. There are a million ways for things to go wrong. I am grateful that SQL Server has an active user community for support. Glad to hear your issue is resolved.


  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: