This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / I am using SQL Server Management Studio to generate dataset. Then I copy it to Excel. Then I attach the Excel file to an email. I need to do this boring stuff everyday. Is there anyway I can combine these into a single button?
-registereduser(立牌坊);
2009-11-26
(#5708096@0)
-
SSIS
-coolmao(酷猫*Arrakis);
2009-11-26
(#5708111@0)
-
Hello coolmao. Do you mind explain more. I do not have privilege to install anything.Currently I have SQL Server Management Studio, Visual Studio 2008 and SQL Server BI Development Studio. I would need to know some keywords about the how to do this. I would need these keywords to search for the details. Thanks a lot.
-registereduser(立牌坊);
2009-11-27
{233}
(#5710895@0)
-
到一个BTN的时候, 就不用你来按这个BTN了.
-whereismyid(到处找ID);
2009-11-26
(#5708272@0)
-
Haha. That is right. I want to make it fully automation.
-registereduser(立牌坊);
2009-11-27
(#5710876@0)
-
LS的意思是说，你这个职位就不需要了。你可以准备走人了。
-bdbs(不多不少);
2009-11-27
(#5710894@0)
-
My manager does not know techniques at all. I would tell him it is complete automation.
-registereduser(立牌坊);
2009-11-27
(#5710938@0)
-
Business Objects
-ssy214(寸草);
2009-11-26
(#5708876@0)
-
What is that? Never heard that before.
-registereduser(立牌坊);
2009-11-27
(#5710873@0)
-
LS说的SSIS是最自动化的方法。如果你不懂那个，或者没有条件用SSIS，也可以选择半自动方式。在你的Excel里可以设置Data Connection。每天你只要打开你的Excel，点一下Refresh button，然后在Send As Attachment。
-bdbs(不多不少);
2009-11-26
(#5708915@0)
-
Thank you very much. I would like to do this first before I have learnt SSIS.
-registereduser(立牌坊);
2009-11-27
(#5710870@0)
-
Having a problem: it appears I can only connect to table. Actually, on server side I have a query which needs to run everyday. Do you know how to link to query?
-registereduser(立牌坊);
2009-11-27
(#5710926@0)
-
估计你没找对地方。
-bdbs(不多不少);
2009-11-27
{294}
(#5710954@0)
-
You are right. Now I found where to link to the view in SQL Server, as well as create a VBA button to open email sending page.However, I am unable to automatically compose the email. Can you help, please?
Next task for me is to schedule daily automation.
-registereduser(立牌坊);
2009-12-2
{131}
(#5721122@0)
-
没试过Excel能不能选Email Template。看来你要求越来越多，建议你还是看看SSIS吧。非要用土炮发射导弹也不是不可以，不过难度可大多了。
-bdbs(不多不少);
2009-12-2
(#5721132@0)
-
不用SSIS(估计你没有SSIS环境) 也能编一个小EXE来完成你的这一小小要求, 然后你就天天喝茶RELAX.....
-whereismyid(到处找ID);
2009-12-2
{536}
(#5721330@0)
-
Thanks.
-registereduser(立牌坊);
2009-12-2
{849}
(#5721417@0)
-
The easiest way is that you pay and ID does it for you. Then you can just drink tea and relax each day. Small money gives you big benefit, Right?!
-deep_blue(BLUE);
2009-12-4
(#5725793@0)
-
Done with one click to send email, with some kind of warning.
-registereduser(立牌坊);
2009-12-2
(#5721396@0)
-
用SSRS吧，简单，5分钟搞定
-iambics(ken);
2009-11-28
(#5711960@0)
-
I think that is the best approach to go. Let me learn something first...
-registereduser(立牌坊);
2009-12-2
(#5721424@0)
-
你button不用点， email也不用自己发， 用sql server job 运行xp_sendmail, 这个procedure是支持query的结果作为attachment的。
-walkthrough(放下);
2009-11-28
(#5712683@0)
-
I do not think I have access to SQL Server Job. At least not in my desktop.
-registereduser(立牌坊);
2009-12-2
(#5721427@0)
-
It should be a SSIS package + a SQL schduled job ( to run the SSIS package on daily basis).
-deep_blue(BLUE);
2009-11-28
(#5712779@0)
-
上面的方法大部分可行，但估计LZ都没权限
-ssy214(寸草);
2009-11-28
(#5712807@0)