Can't create an Integration Service Project
Hi! I have this problem, I created a project in Business Inteligence Development in SQL Server 2008 R2 a simple backup of 1 table, I run de SSIS and it didnt finish, I closed the Business Inteligence and show a dialogue box are you sure to stop the running process and I click on yes it closed. Now, everytime that I want to create a new Integration Service Project show the next error: Object Reference No Set To an Instance of an object. And If I try to open the project that I created before (the one that didnt finish running): cannot be opened becasuse its project type .dtproj is not supported by this version of the application. To open it, please use a version that supports this type of project. And Im working in the version that I created it ¬¬.....
July 19th, 2011 7:16pm

seems there are bunch of problems, what did you do in the package? what task(s)?http://www.rad.pasfu.com My Submitted sessions at sqlbits.com
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2011 1:28am

Thanks! I only use the wizard to create an export from 1 table to another
July 20th, 2011 9:58am

Thanks! I only use the wizard to create an export from 1 table to another Do you mean the Import/Export Wizard? if yes, so what you trying to do in BIDS? you can use wizard in SSMS? and what happen if you use the wizard in SSMS? what error do you receive there?http://www.rad.pasfu.com My Submitted sessions at sqlbits.com
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2011 10:44am

Yes that one the Import/Export Wizard when I created a new project in Integration Services Project... then I delete de Package.dtsx, and I click left button and add the import/export wizard package. I chose my server source and destiny also de tables that I want to export and I started running there was only 30,000 rows to export to another table, but it took to long time running more than 30 minutes and I close the Business Intelligence Development and It show a dialoge box that said "you are running a package are you sure you want to stop it?" or something like this and I click on yes. And now when I want to open the same project it shows an error that the version of the project cant open in the BID, and when I try to create a new Project: One or more templates do not match any installed project packages. So I cant work with it =S
July 20th, 2011 10:59am

Do Import/Export wizard in this way this time: in the Run; type : dtswizard and then the wizard comes up, follow it and look does data transfer correctly here?http://www.rad.pasfu.com My Submitted sessions at sqlbits.com
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2011 11:02am

When I ran the ISProject and I closed it imported me the data, but my problem is that I can't create any project in the Business Intelligence Developer It show this message: OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT I need to create more projects how can I fix this??
July 20th, 2011 12:21pm

OK, let's start with BIDS this time: could you create new Integration Services Project in BIDS? could you create package in BIDS? could you run the package in BIDS?http://www.rad.pasfu.com My Submitted sessions at sqlbits.com
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2011 3:00pm

HI Reza! I can't create a new integration services project and the project that I have its impossible to open. When I try to open the project a dialogue box said: "path of the project" Temp.dtproj cannot be opened because its project tupe (.dtproj) is not supported by this version of the application. I don't care about this project, I want to create a new one. When chose File->New->Project->Integration Services Project it shows a dialogue box: Object Reference not set to an instance of an object. and it happend with all type of projects =( thanks for your help
July 20th, 2011 5:07pm

Did you ever tried to re-install the BIDS?http://www.rad.pasfu.com My Submitted sessions at sqlbits.com
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2011 5:09pm

We have to submit a maintance window, and I have to show differnt kind of answer in case that re-install didnt work. I tried to repair with SQL SERVER INSTALLATION CENTER but it didnt work neither.
July 20th, 2011 5:17pm

Hi Reza! Thanks for your help! I found that running this command: devenv /ResetSkipPkgs It will work excellent and now I can create proyects again =) thanks for your attention. Best regards and have a nice day
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2011 11:07am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics