Pejman Sairi


hi there,

when i start SQL Server business intelligence developer and create new Integration Service project, i will see following error:

Error loading 'Package.dtsx' : Object reference not set to an instance of an object.. C:\Sairi\My Documents\Visual Studio 2005\Projects\Integration Services Project12\Integration Services Project12\Package.dtsx

this error occures just on my PC and i reinstalled VS2005 and SQL2005 again and unfotunately the problem existes.


please someone helps me (just don't tell me to format my PC!!!)

tnx





Re: can't load SSIS dtsx package

Rafael Salas


It looks like BIDS is trying to open a project/package that does not exists anymore. The weird thing is that when that happens BIDS prompts you to remove the invalid references and the error goes away. Don't you see that message

Can you do File->Close solution/project

BTW, that error should not prevent you from using BIDS.

as a good practice always use close solution/project before closing BIDS. This is because BIDS always tries to re-open all projects and packages that were opend at the time of exiting.







Re: can't load SSIS dtsx package

Pejman Sairi

Dear Rafael,

Many thanks for your response.
but my i want to Create/Edit DTS packages in BIDS and i cant.
my VS Net 2005 works properly.
my problem is creating or editing SSIS packages in BIDS.
even in new SSIS project when i add new SSIS packages or existing packages (dtsx) my BIDS doesn't show its designer and shows same error.

i think it cant find SSIS DTS base class or its references for showing SSIS designer.







Re: can't load SSIS dtsx package

Rafael Salas

It looks like an installation issue to me. Try re-installing the client tools to see if BIDS gets fixed.




Re: can't load SSIS dtsx package

Wenyang Hu

I second that, it's likely a setup issue. Pls try to confirm for example whether "dts.dll" is under your \Program Files\Microsoft SQL Server\90\DTS\Binn to see whether you did encounter a setup issue and if yes, reinstall Integration Service from SQL Server Work Station Components to see whether that helps.

Thanks






Re: can't load SSIS dtsx package

Michael Entin - MSFT

Pejman - do you any have third party Visual Studio add-ins installed

Also, try installing SQL Server 2005 SP2.






Re: can't load SSIS dtsx package

Pejman Sairi

dear , thanks for your responses.
i agree with you.its an installation problem but after re-installing the problem was exist.
i think my its because of Windows Registry!!







Re: can't load SSIS dtsx package

Pejman Sairi

Dear Friend,
"dts.dll" file exist in the SQL path as you said.
also i reinstaling SSIS and some workstation components.
but the same problem !!!
also it can't open SSIS samples.






Re: can't load SSIS dtsx package

Pejman Sairi

Dear Michael,
yes, i had some VS add-ins and i remove them.
and again reinstalling SQL server developer and the problem exist.
soon i will download SQL2005 SP2 and inform you.

TNX





Re: can't load SSIS dtsx package

Pejman Sairi

Hello Dear All,

finally i solved the problem.

i installed MSSQL 2000 Personal Edition on my computer then my SSIS problem is now solved.

thanks all of you.