Hi all,
How to generate flat files using DTS packages (sql server2000)from Sybase database.How do we generate Reports using these flat files.
it's very urgent.

Thanks,
B.Ramesh

Hey,

The key is whether SQL Server supports a connection to Sybase. If that works, then you can get the data. Most people generate the reports directly from the database, which you can do using VB(.NET), ASP(.NET), just about most server-based languages, and Crystal Reports, and SQL Server Reporting Services.

Brian

how can use Crystal Reports with SQL server with ASP ?