Try to define a new layout and create a new ascii using SQL Query Analyzer (RPAD) -- sql server new users

SQL
9/30/2005 6:40:03 AM

I don't know if I understand your question completely
The client wants to add or remove from a ascii file right?

If so take a look at DTS (Data Transformation Services)

http://sqlservercode.blogspot.com/

[quoted text, click to view]

Andrew J. Kelly
9/30/2005 9:39:56 AM

Take a look at DTS in BooksOnLine.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Nick Dakoronias
9/30/2005 4:26:49 PM

Hello Forum readers,
Any advise on the following, will be much appreciated :

I have a customer who tries to extract some columns (fields) from an
existing SQL table or add more columns (fields)
in order to define a different layout (from the current one) and create a
new ascii file.
I have tried SQL Query Analyzer using RPAD but without success.
Any idea?

Regards, Nick

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : Try to define a new layout and create a new ascii using SQL Query Analyzer (RPAD)