SSIS - SSMS 32bit standard edition

  • I have been creating a variety of fixed length (jagged right) interface files.

    I obtain the data from various data sources and then use the export data function on SSMS.

    This allows me to successfully produce a file and save the package on the MSDB. However, when I go to run this it tells me the product level is too low. I am also unable to schedule them to run also.

    Any ideas / solutions will be gratefully received.

  • Which version of SSMS do you use? (2000, 2005 or 2008 (R2))

    Which version of SQL Server do you use?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi

    I run sql server 2005 and ssms 2005.

    Hope you can help!

    Thanks

  • are they both standard edition or is one of them express?

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • both standard edition

  • very interesting... this sounds broken to me!

    have your tried reinstalling ssms?

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • post your @@version

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Furthermore, can you past the actual error messages?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply