Save to sql server failed no description found

I want transfer data from excel file to sql server.

I created a package in sql server managament studio using export import wizard and i gave the option "sql server" as the package location.

At the final stage of the wizard "Save to sql server failed no description found" error is coming. pls give me a solution.

thank u

I could not reproduce this issue. Can you try saving this to the file system and let us know if you have any issues?|||

try to run

Regsvr32 msxml3.dll
Regsvr32 msxml6.dll

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=748066&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=74140&SiteID=1

SAve SQLMaint jobs to a central server

When setting up a maintenance plan through the wizard, there is the option to
select a remote server to receive the job history. However, this option does
not seem available when using SqlMaint to setup jobs. I have a setup where 8
remote servers are setup with one central MSX server. Unfortunately, I can't
figure out how to save the job history to the central MSX server and not to
the local servers. Anyone know how the maintenance plan wizard sets things
up to save job histories remotely?
Thanks,
Alex Gadea
I don't think that it is the job history which is written to the remote server, it is only the maint
plan history table(s). I might be wrong, of course...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:46236FC9-AB41-43D6-AE75-4715B66F6267@.microsoft.com...
> When setting up a maintenance plan through the wizard, there is the option to
> select a remote server to receive the job history. However, this option does
> not seem available when using SqlMaint to setup jobs. I have a setup where 8
> remote servers are setup with one central MSX server. Unfortunately, I can't
> figure out how to save the job history to the central MSX server and not to
> the local servers. Anyone know how the maintenance plan wizard sets things
> up to save job histories remotely?
> Thanks,
> Alex Gadea

SAve SQLMaint jobs to a central server

When setting up a maintenance plan through the wizard, there is the option t
o
select a remote server to receive the job history. However, this option doe
s
not seem available when using SqlMaint to setup jobs. I have a setup where
8
remote servers are setup with one central MSX server. Unfortunately, I can'
t
figure out how to save the job history to the central MSX server and not to
the local servers. Anyone know how the maintenance plan wizard sets things
up to save job histories remotely?
Thanks,
Alex GadeaI don't think that it is the job history which is written to the remote serv
er, it is only the maint
plan history table(s). I might be wrong, of course...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:46236FC9-AB41-43D6-AE75-4715B66F6267@.microsoft.com...
> When setting up a maintenance plan through the wizard, there is the option
to
> select a remote server to receive the job history. However, this option d
oes
> not seem available when using SqlMaint to setup jobs. I have a setup wher
e 8
> remote servers are setup with one central MSX server. Unfortunately, I ca
n't
> figure out how to save the job history to the central MSX server and not t
o
> the local servers. Anyone know how the maintenance plan wizard sets thing
s
> up to save job histories remotely?
> Thanks,
> Alex Gadea

SAve SQLMaint jobs to a central server

When setting up a maintenance plan through the wizard, there is the option to
select a remote server to receive the job history. However, this option does
not seem available when using SqlMaint to setup jobs. I have a setup where 8
remote servers are setup with one central MSX server. Unfortunately, I can't
figure out how to save the job history to the central MSX server and not to
the local servers. Anyone know how the maintenance plan wizard sets things
up to save job histories remotely?
Thanks,
Alex GadeaI don't think that it is the job history which is written to the remote server, it is only the maint
plan history table(s). I might be wrong, of course...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:46236FC9-AB41-43D6-AE75-4715B66F6267@.microsoft.com...
> When setting up a maintenance plan through the wizard, there is the option to
> select a remote server to receive the job history. However, this option does
> not seem available when using SqlMaint to setup jobs. I have a setup where 8
> remote servers are setup with one central MSX server. Unfortunately, I can't
> figure out how to save the job history to the central MSX server and not to
> the local servers. Anyone know how the maintenance plan wizard sets things
> up to save job histories remotely?
> Thanks,
> Alex Gadea

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.

Sample database not found?

I install the SQL 2005 Evaluation. I selected to install samples and documentation during the installation wizard. It finished successfully but I could not find the sample databases on the SQL Management Studio. Why?

Thanks.

Joe.

I have never used the trial version but look in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to see if the sample database files exist. If they do you can simply attach them via Mgmt Studio.

D

|||

Derek gives good advice so I'd try his option first. If the files are not there though, then I'd go to the Control Panel, to Add/Remove Programs, and Modify your SQL Server 2005 instance.

/****************************************************

Check out our Sql Server 2005 and 2000 tutorials

****************************************************/

|||

I cannot any sample databases on the path you mentioned. Can I download them individually?

Thanks.

Joe.

|||

Hi,

you can download them at:

http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Thanks Jens.