sql server new users: need some help with reporting? -- sql server new users

need some help with reporting?

_adrian
4/18/2006 4:13:00 PM

sql server new users: So, my client says that they need to take existing SQL Server table data,
and export the contents to a tabbed-delimited text flat file. I've been
told that Reporting Svcs can do this for me, and even help email that flat
file to teh client (which would be great!)...

Can anyone confirm this for me, and tell me where I could find a tutorial to
this effect or what steps I would need to take? I know that Reporting Svcs
are installed... thanks-

Re: need some help with reporting?

Andrew Watt [MVP]
4/19/2006 4:34:24 PM

Adrian,

Reporting Services (in either SQL Server 2000 or 2005) should be able
to produce comma separated value files. As far as I'm aware RS doesn't
support tab-delimited files.

Integration Services in SQL Server 2005 can produce a wide range of
formats in the destination file, including tab-delimited.

Andrew Watt [MVP]

[quoted text, click to view]

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 in the sql server new users group.