DTS migration error

[drublic1019]

OK this one probably has a simple answer but I can't figure it out. I have visual studio installed on my desktop for creating and modifying SSIS packages. However when I try to import a sql 2000 DTS package I get the following error:

Could not load file or assembly '........

Now if I remote into the actual sql server and try to load the same files using visual studio they work. But I still receive an error if I try to open the imported package on my local machine. I would like to be able to do this from my machine to save memory on my sql server from being taken up by visual studio. Thanks.

 

[mrdenny]

Sounds like there is a customer DTS component on the server that isn't installed on the workstation. What does the DTS package do?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[drublic1019]

It runs a stored procedure to fill a table and then push the results to a flat file.

 

[mrdenny]

Sounds pretty basic. Do you have the SQL 2000 tools installed on your workstation?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Quick question, what version of Visual Studio do you have on your desktop?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[drublic1019]

I downloaded the Microsoft SQL Server 2000 DTS Designer Components from their website and I seem to be up and running again. Thanks for the help.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com