save package to SQL server failed, no description found

Hi I have an instance of sql2005 on my machine and connected to a sql2000
server. I tried using the export wizard to create a package with the source
being tables from a database on the 2000 server and the destination being an
excel file on my machine. I also selected save package on the 2005 server.
When executing it makes it to the save portion but I then get the error, Save
to SQL Server failed, no description found!
Thanks.
--
Paul G
Software engineer.Hi Paul,
Please ensure that the user account in SQL who runs the job has adequate
privileges.
"Paul" wrote:
> Hi I have an instance of sql2005 on my machine and connected to a sql2000
> server. I tried using the export wizard to create a package with the source
> being tables from a database on the 2000 server and the destination being an
> excel file on my machine. I also selected save package on the 2005 server.
> When executing it makes it to the save portion but I then get the error, Save
> to SQL Server failed, no description found!
> Thanks.
> --
> Paul G
> Software engineer.|||ok I think that may have been the problem. Also I changed the authentication
from windows to mixed mode so will give it a try.
--
Paul G
Software engineer.
"Amol Lembhe" wrote:
> Hi Paul,
> Please ensure that the user account in SQL who runs the job has adequate
> privileges.
> "Paul" wrote:
> > Hi I have an instance of sql2005 on my machine and connected to a sql2000
> > server. I tried using the export wizard to create a package with the source
> > being tables from a database on the 2000 server and the destination being an
> > excel file on my machine. I also selected save package on the 2005 server.
> > When executing it makes it to the save portion but I then get the error, Save
> > to SQL Server failed, no description found!
> > Thanks.
> > --
> > Paul G
> > Software engineer.