dbTalk Databases Forums  

SQL Conversion

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


Discuss SQL Conversion in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tony S.
 
Posts: n/a

Default SQL Conversion - 11-08-2006 , 08:32 AM






I'm not even a novice on SQL, so this may be out of my league, but I need to
find out how to convert SQL Tables to Flat files. I imagine I will need a
converter of some sort, right? The scenario is... a subcontractor sent files
to us in SQL Tables unlike the last year when they were sent in a Flat file
format. How can we get this into a flat file format without having to incur
more cost with contractor?

Reply With Quote
  #2  
Old   
Arnie Rowland
 
Posts: n/a

Default Re: SQL Conversion - 11-08-2006 , 10:24 AM






First, let the contractor know that the form of the data is unacceptable and
that he/she needs to 're-send' it in an acceptable format. Most 'reputable'
contractors will correct that without charge.

Second.
How do you know that the data is in SQL Tables?
Do you have a file that must be loaded into a SQL Server?
Do you have a SQL Server?

How can you look at the tables and know that they are SQL tables?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Tony S." <TonyS (AT) discussions (DOT) microsoft.com> wrote

Quote:
I'm not even a novice on SQL, so this may be out of my league, but I need
to
find out how to convert SQL Tables to Flat files. I imagine I will need a
converter of some sort, right? The scenario is... a subcontractor sent
files
to us in SQL Tables unlike the last year when they were sent in a Flat
file
format. How can we get this into a flat file format without having to
incur
more cost with contractor?



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 - 2013, Jelsoft Enterprises Ltd.