September 16, 2010 at 7:36 am
Hi,
I made a simpel script for some collegue to get some info out of the sql database.
now i want it to fill a excel sheet with it automaticly since he need to be easely exported towards excel.
many thanks.
btw database runs on a old sql2000 server.
September 16, 2010 at 7:44 am
DTS may fulfill your requirememnt and then that DTS can be scheduled in job
----------
Ashish
September 16, 2010 at 8:22 am
ashish.kuriyal (9/16/2010)
DTS may fulfill your requirememnt and then that DTS can be scheduled in job
Why would you use DTS when you have SSIS available?
Reporting Services may actually be the best option, because it has a LOT more flexibility in terms of formatting the data and can also export charts and graphs easily. SSRS can be scheduled as well.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
September 16, 2010 at 8:43 am
Why would you use DTS when you have SSIS available?
because ssis is not available in sql server 2000. Please refer original post.
----------
Ashish
September 16, 2010 at 8:45 am
all good guys. you all mean well.
But can i do this with t-sql?
i think i forgot to say it has to be done on demand. not so on surten times.
thanks though
September 16, 2010 at 8:50 am
r.rozeboom (9/16/2010)
all good guys. you all mean well.But can i do this with t-sql?
i think i forgot to say it has to be done on demand. not so on surten times.
thanks though
You could run the DTS package on demand...setting it up in DTS is much, much easier than trying to write it in t-sql.
September 16, 2010 at 9:17 am
ashish.kuriyal (9/16/2010)
Why would you use DTS when you have SSIS available?
because ssis is not available in sql server 2000. Please refer original post.
He only said that the database was running in SQL 2000. You can access a SQL 2000 database in SSIS.
Since he is posting in a SQL 2005 forum, he is going to get SQL 2005 answers. If he specifically wants SQL 2000 answers, he should post in the correct forum.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
September 16, 2010 at 9:26 am
Derrick Smith (9/16/2010)
r.rozeboom (9/16/2010)
all good guys. you all mean well.But can i do this with t-sql?
i think i forgot to say it has to be done on demand. not so on surten times.
thanks though
You could run the DTS package on demand...setting it up in DTS is much, much easier than trying to write it in t-sql.
Do you really want to open up the rights to run packages to random users? SSRS would be an even better option in this situation. It can be run on demand and you can even encode the export options in the URL so that it automatically exports to Excel.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
September 16, 2010 at 9:35 am
drew.allen (9/16/2010)
Derrick Smith (9/16/2010)
r.rozeboom (9/16/2010)
all good guys. you all mean well.But can i do this with t-sql?
i think i forgot to say it has to be done on demand. not so on surten times.
thanks though
You could run the DTS package on demand...setting it up in DTS is much, much easier than trying to write it in t-sql.
Do you really want to open up the rights to run packages to random users? SSRS would be an even better option in this situation. It can be run on demand and you can even encode the export options in the URL so that it automatically exports to Excel.
Drew
Actually I meant he could run the package when his colleague requested it..I doubt he'd want to let this person run it on their own any time they wanted.
September 17, 2010 at 2:11 pm
Go to excel --> data
data -->other sources
-->sql server
-->new connection
write t sql script there
execute, the excel would be filled with the result
of the t sql specified..
no use of dts or ssis
or ssrs
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
September 17, 2010 at 2:25 pm
SKYBVI (9/17/2010)
Go to excel --> datadata -->other sources
-->sql server
-->new connection
write t sql script there
execute, the excel would be filled with the result
of the t sql specified..
no use of dts or ssis
or ssrs
Regards,
Sushant
I agree. Importing data from SQL Server using Excel's Data Connection Wizard is very easy for both the DBA and the end user. You need to grant them a login with select permission on the required tables or procedures. To re-run the query, all the user has to do is click the Refresh button. However, one potenial pitfall is when they frequently refresh a long running query.
http://office.microsoft.com/en-us/excel-help/connect-to-import-external-data-HP010089898.aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 17, 2010 at 2:58 pm
@ eric
Ya, true , you have to give them a login and permission too.
About the refresh page, there is a option in connection properties,
refresh after __ minutes and also
refresh data while opening the file.
I guess they should make easier the work of the user.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
September 17, 2010 at 2:58 pm
@ eric
Ya, true , you have to give them a login and permission too.
About the refresh page, there is a option in connection properties,
refresh after __ minutes and also
refresh data while opening the file.
I guess they should make easier the work of the user.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
September 17, 2010 at 2:59 pm
oops
sorry for posting twice
i couldnt find the delete post option
is it there?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
September 17, 2010 at 3:08 pm
SKYBVI (9/17/2010)
oopssorry for posting twice
i couldnt find the delete post option
is it there?
Regards,
Sushant
Go back to the post in question.
Click on the "Edit" button
It will open in a window similar to the window you used to make the original posting.
Simply delete all the test - might even then type in some sort of explanation, such as "Deleted posted twice"
You can click the preview button if so desired
Then in the lower left hand corner of the the window you are typing in click the "Edit" button ....
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply