dbTalk Databases Forums  

saving to sql server failed no description found

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss saving to sql server failed no description found in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
savitha arul
 
Posts: n/a

Default saving to sql server failed no description found - 11-09-2006 , 10:01 PM






Iam getting the following error at the final stage of import/export
wizard of sql server 2005 while creating a package to transfer data from
excel to sql server.

"Save to sql server failed no description found"

I used sql server as the package location. Kindly help to resolve this
issue.

thank u



*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
  #2  
Old   
hb21l6
 
Posts: n/a

Default Re: saving to sql server failed no description found - 11-15-2006 , 05:15 AM






Hello savitha

In the DTS package
Have a look at the properties ( Package > properties > Logging) and enable
the logging.
specify where you want to log file to be generated and saved, then re-run
the DTS.

This will create a error / success log file and point out where the issue
lies.

hb





"savitha arul" <savitha.kumaraguruparavelu (AT) wipro (DOT) com> wrote

Quote:
Iam getting the following error at the final stage of import/export
wizard of sql server 2005 while creating a package to transfer data from
excel to sql server.

"Save to sql server failed no description found"

I used sql server as the package location. Kindly help to resolve this
issue.

thank u



*** Sent via Developersdex http://www.developersdex.com ***


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.