locked
ssis problems RRS feed

  • Question

  • hi

         i create a package in SSIS..when ever i try to open that package in that package designer page all transformations all shows blankly or its not showing correct transformation design and also its not showing column maps..after few minutes visual studio automatically closed..so times when i try to save my package its shows u cant able to save this package

    how to solve this problem in SSIS 2008 R2..

    Monday, April 16, 2012 9:46 AM

Answers

  • Either try a repair or just re-install BIDS. It doesn't take that long, so it's worth a shot.

    MCTS, MCITP - Please mark posts as answered where appropriate.

    • Marked as answer by Eileen Zhao Friday, April 27, 2012 6:13 AM
    Friday, April 20, 2012 8:43 AM

All replies

  • What's your exact version?

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Monday, April 16, 2012 10:33 AM
  • Microsoft visual studio 2008
    Monday, April 16, 2012 11:58 AM
  • Microsoft visual studio 2008

    not really exact... it is more interesting to see the exact version to see whether you're missing important updates.

    See the about in visual studio in the Help menu and try these queries in SQL Server Management Studio:

    Select @@version
    
    
    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
    Is it for all packages or just this one? Did it work before? If so, any changes?

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Monday, April 16, 2012 12:13 PM
  • Select @@version

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)   Apr  2 2010 15:53:02   Copyright (c) Microsoft Corporation  Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    10.50.1600.1    RTM    Enterprise Edition

    ya thats happen for all SSIS projects

    Tuesday, April 17, 2012 5:21 AM
  • Select @@version

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)   Apr  2 2010 15:53:02   Copyright (c) Microsoft Corporation  Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    10.50.1600.1    RTM    Enterprise Edition

    ya thats happen for all SSIS projects

    You're still on RTM for SQL Server. Maybe it's time to upgrade.
    If that doesn't help: put in the install disk of SQL Server and do a repair.
    If that doesn't help: uninstall BIDS and re-install.


    MCTS, MCITP - Please mark posts as answered where appropriate.

    Tuesday, April 17, 2012 5:29 AM
  • if i used RTM means its any problem with that..i dont knw abt this shall u explain me briefly
    Tuesday, April 17, 2012 6:02 AM
  • if i used RTM means its any problem with that..i dont knw abt this shall u explain me briefly

    RTM means Release to Manufacturing. It means that you have not run any service pack yet on your machine.
    In other words, your system is not up to date.

    MCTS, MCITP - Please mark posts as answered where appropriate.

    Tuesday, April 17, 2012 6:17 AM
  • RTM means you're not having the latest updates installed at the moment: http://en.wikipedia.org/wiki/Software_release_life_cycle#RTM

    I think the current versions will be around 10.50.2500.0

    Here is the Service Pack download: http://www.microsoft.com/download/en/details.aspx?id=26727

    http://social.technet.microsoft.com/wiki/contents/articles/2973.microsoft-sql-server-2008-r2-sp1-release-notes.aspx


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter


    • Edited by SSISJoostMVP Tuesday, April 17, 2012 6:24 AM
    • Proposed as answer by Eileen Zhao Tuesday, April 17, 2012 8:58 AM
    Tuesday, April 17, 2012 6:22 AM
  • ya i did that update but still i am getting that same problem

    Select @@version

    Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Intel X86)   Jun 17 2011 00:57:23   Copyright (c) Microsoft Corporation  Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    10.50.2500.0    SP1    Enterprise Edition


    Friday, April 20, 2012 8:40 AM
  • Either try a repair or just re-install BIDS. It doesn't take that long, so it's worth a shot.

    MCTS, MCITP - Please mark posts as answered where appropriate.

    • Marked as answer by Eileen Zhao Friday, April 27, 2012 6:13 AM
    Friday, April 20, 2012 8:43 AM