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