SQL Server supports complete set of utilities for managing file import/export, scheduling this processing, making reports and so on. They are called Data Transformation Services (DTS). Virtually any data processing can be automated if you know T-SQL, VBScript or JavaScript You can find out more about DTS please read your SQL server documentation or browse the internet.
For more info please see http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=sql+server+dts By the way, this message forum is dedicated to support SoftTree Technologies' database tools. : I am a Network administrator for a computer sales company and a novice in SQL
: 2000 database. I have been able to singlehandedly installed SQL server
: 2000 on a Windows 2000 Advanced server. My office uses a Sage line 50
: accounting software and Maximiser 7 to track and close more sales (on the
: Advanced Server). I need to integrate it ino this SQL server by
: importing/exporting files to/from the database of the Sage server/SQL
: server. I am thinking of writing a script to automate this process, to
: provide me with links to back-end corporate database (in this case my SQL
: server) to allow users to run their own reports and upload data for use by
: other departments and applications and share corporate data please if this
: is possible can you help me out with this? I would be grateful if you can
: be of help or any useful site I can get the information I want.
: Thanks regards
: Pious
|
