Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS 2005 not running after upgrading (32 bit, Windows XP to 64 bit Windows 7 Expand / Collapse
Author
Message
Posted Wednesday, August 6, 2014 1:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 8, 2014 1:36 PM
Points: 2, Visits: 6
I really need some help. Recently I went from using Visual Studio and SQL 2005 on a laptop (32bit system - Windows XP) to a desktop unit 64bit processor with Windows 7). SSIS on the laptop worked just fine and I could execute and open packages in SSIS; however, my new desktop unit will not even allow me to open a new package or run an existing package. As soon as I attempt to create a new SSIS project, I receive the following error: "An error prevented the view from loading. The specified module could not be found. (Exception from HResult:0x8007007E)(System Windows Forms).


SSIS won't allow me to view the control flow or data flow screens and if I attempt to run an existing package created with the SSIS wizard I receive the following error: SSIS package "Package1.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Error: 0xC0202009 at Package1, Connection manager "SourceConnectionExcel": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
Error: 0xC020801C at Data Flow Task, Source - Without_Sample$ [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionExcel" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "Source - Without_Sample$" (1) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "Package1.dtsx" finished: Failure.

I have tried changing the properties in the package to run in 32-bit mode; however, this does not work. I can run queries and import data in SQL Server Management Studios just fine, as well as run queries and reports in Visual Studios; however, I can't execute or create any package in Visual Studio with the new machine. Am I missing a needed system file in the new sysWOW64 folder? The IT person who installed the software isn't familiar with the program and doesn't know how to fix it either. I'm relatively new with using SSIS and really need some help on how to get this fixed. Any help you can offer would be greatly appreciated.

Thanks,

MelissaS
Post #1600361
Posted Thursday, August 7, 2014 10:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 8:26 AM
Points: 10,381, Visits: 13,436
Are you sure that BIDS/SSDT has been installed on the machine? If it has it sounds like a corrupted install and I'd first try to re-run the install doing a repair and if that doesn't work I'd uninstall VS and BIDS/SSDT and then reinstall.





Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1600758
Posted Thursday, August 7, 2014 12:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 8, 2014 1:36 PM
Points: 2, Visits: 6
Embarrassingly, BIDS was not installed on the machine. I'm new at this, so I'm just starting to get my sea legs with regard to writing queries in ssms and creating packages in VS. I'll have to talk with our agency's IT guy who set the machine up to have it installed. Bless you for getting back to me about this though and perhaps it'll bring a few laughs with regard to my lack of knowledge lol. We all have to start somewhere. Thank you again very much for helping me out. Hope you have a great rest of the week.
Post #1600822
Posted Thursday, August 7, 2014 1:29 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 8:26 AM
Points: 10,381, Visits: 13,436
simpson213 (8/7/2014)
Embarrassingly, BIDS was not installed on the machine. I'm new at this, so I'm just starting to get my sea legs with regard to writing queries in ssms and creating packages in VS. I'll have to talk with our agency's IT guy who set the machine up to have it installed. Bless you for getting back to me about this though and perhaps it'll bring a few laughs with regard to my lack of knowledge lol. We all have to start somewhere. Thank you again very much for helping me out. Hope you have a great rest of the week.


No laughing. We've all been there where we thought all the tools we needed were installed, but they weren't, or weren't installed correctly. I try to get the admins to allow me to install all my tools on my laptop instead of letting them do it.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1600855
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse