dts

[Wendy Elizabeth]

I would like to know how to automate the following two processes with excel:

1. I would like to take data that is obtained from sql server 2000 queries
results and load the detail data onto excel spreadsheets.

2. I would also like to take data that is obtained from sql server 2000
query results and load the data in pivot tables in excel spreadheet 2003.

3. Can DTS be setup to export sql server 2000 data to a PDF format? If so,
how would you set that up?

Thanks!

[Allan Mitchell]

Hello Wendy,

1. Set up a DTS Package to do this which will include a Transform data task
to do the export. Schedule with SQL Server Agent (or your own scheduling
tool)

Getting Syntax Help for DTSRun
(http://www.sqldts.com/301.aspx)

http://support.microsoft.com/?kbid=269074

2. Load a hidden sheet and feed the pivot table from there

3. Not natively no. You would need to write something yourself to do that.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

Post by Wendy Elizabeth
1. I would like to take data that is obtained from sql server 2000
queries results and load the detail data onto excel spreadsheets.
2. I would also like to take data that is obtained from sql server
2000 query results and load the data in pivot tables in excel
spreadheet 2003.
3. Can DTS be setup to export sql server 2000 data to a PDF format? If
so, how would you set that up?
Thanks!

[Gary]

How is a PDF export done from SQL Server 2005 SSIS?

Post by Allan Mitchell
Hello Wendy,
1. Set up a DTS Package to do this which will include a Transform data task
to do the export. Schedule with SQL Server Agent (or your own scheduling
tool)
Getting Syntax Help for DTSRun
(http://www.sqldts.com/301.aspx)
http://support.microsoft.com/?kbid=269074
2. Load a hidden sheet and feed the pivot table from there
3. Not natively no. You would need to write something yourself to do that.
--
Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

Post by Wendy Elizabeth
1. I would like to take data that is obtained from sql server 2000
queries results and load the detail data onto excel spreadsheets.
2. I would also like to take data that is obtained from sql server
2000 query results and load the data in pivot tables in excel
spreadheet 2003.
3. Can DTS be setup to export sql server 2000 data to a PDF format? If
so, how would you set that up?
Thanks!