Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old July 3rd, 2003, 04:37 PM
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problems with Export to MS Access

Hello,

I have tried to export a table that contains fields of datatype decimal, however, when I export the data to MS Access, the values to the right of the decimal point (scale) are never present in MS Access. The number is rounded to the nearest whole number.

I tried first creating the target table in MS Access, and even changed the field type in this table to decimal, but that didn't do the trick. I haven't tried select convert(varchar(10), column1) yet. I didn't think this would be necessary.

Also can anyone please tell me how to export data from a SQL Server table to a text file? I tried doing this but each time I tried to create the target table, using the DTS Designer, I received an MMC execption, which shut down the DTS designer. I'm running SQL Server 2000 on an old NT4 workstation.

Any help would be greatly appreciated.

Thanks,

Sam





  #2 (permalink)  
Old August 15th, 2003, 07:29 AM
Authorized User
 
Join Date: Aug 2003
Location: HCM, HCM, Vietnam.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi
You try to check it on other database.If it still to have an error, that things mean that your DTS have error.



L.V.L
  #3 (permalink)  
Old August 15th, 2003, 07:54 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , Denmark.
Posts: 184
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Jonax
Default

Maybe you could link the SQLServer table from Access?
And then copy/paste the rows...?

Just a thought...

HtH

Jonax

  #4 (permalink)  
Old August 15th, 2003, 08:54 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:Originally posted by sammiebarnes
Also can anyone please tell me how to export data from a SQL Server table to a text file? I tried doing this but each time I tried to create the target table, using the DTS Designer, I received an MMC execption, which shut down the DTS designer. I'm running SQL Server 2000 on an old NT4 workstation.
I had similar problems, solved them by going through the C:\Program Files\Microsoft SQL Server\80\Tools\Binn directory and manually registering all the dlls in there.

hth
Phil
 


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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database migration MS Access 2003 to MS SQL 2000 ayazhoda SQL Server 2000 3 April 23rd, 2007 11:38 AM
MS ACCESS 2003 FRONTEND AND MS SQL SERVER 2005 DB mohankumar0709 SQL Server 2005 3 March 23rd, 2007 12:48 AM
Problems opening MS Access database JayM ASP.NET 2.0 Basics 1 June 5th, 2006 01:59 PM
export dataset into existng ms access data drachx General .NET 0 October 13th, 2005 08:50 PM



All times are GMT -4. The time now is 11:51 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.