This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

估计你没找对地方。

bdbs(不多不少)

The Excel source provides four different data access modes for extracting data:

* A table or view.
* A table or view specified in a variable.
* The results of an SQL statement. The query can be a parameterized query.
* The results of an SQL statement stored in a variable.

http://msdn.microsoft.com/en-us/library/ms141683.aspx

(#5710954@0)
Last Updated: 2009-11-27
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / 学科技术讨论 / 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. -registereduser(立牌坊); 2009-11-27 {233} (#5710895@0)
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.

you can use Visual Studio to create a Integration Services project under Business Intelligence Projects types. Search "SSIS hands on lab" or "SSIS tutorial". You will find some examples -coolmao(酷猫*Arrakis); 2009-11-28 {115} (#5712459@0)
Export SQL Server data to Excel: http://msdn.microsoft.com/en-ca/library/cc952922.aspx

Other SSIS how to videos:
http://msdn.microsoft.com/en-ca/library/dd299421.aspx

到一个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)
The Excel source provides four different data access modes for extracting data:

* A table or view.
* A table or view specified in a variable.
* The results of an SQL statement. The query can be a parameterized query.
* The results of an SQL statement stored in a variable.
http://msdn.microsoft.com/en-us/library/ms141683.aspx

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. -registereduser(立牌坊); 2009-12-2 {131} (#5721122@0)
However, I am unable to automatically compose the email. Can you help, please?

Next task for me is to schedule daily automation.

没试过Excel能不能选Email Template。看来你要求越来越多，建议你还是看看SSIS吧。非要用土炮发射导弹也不是不可以，不过难度可大多了。 -bdbs(不多不少); 2009-12-2 (#5721132@0)

不用SSIS(估计你没有SSIS环境) 也能编一个小EXE来完成你的这一小小要求, 然后你就天天喝茶RELAX..... -whereismyid(到处找ID); 2009-12-2 {536} (#5721330@0)
1. 不管你用老的VB, 还是新的.NET (C# , VB.NET), 你需要编个EXE . 不会有问题吧? (老的象VB6.0, 选EXE PROJECT, CODING... COMPILED; 新的VS.NET 什么的选CREATE PROJECT, C# , VB.NET你自便, BUILD后去BIN FOLDER你能找到EXE)
2. 在你的EXE 中用老的ADO 或新的ADO.NET 从DATABASE取回老的RECORDSET/新的DATASET 你应该会吧?
3. 把RECORDSET/DATASET 写在EXCEL文件中你会吧?
4. 用老的CDO/新的NET.MAIL NAME SPACE组建你的EMAIL, ATTACH EXCEL文件.
5. 在SCHEDULE TASK中ADD TASK, CONFIGURE LIKE 5:00pm DAILY...ETC, 把上面的EXE定在这个TASK中.
6. 天天休息喝茶了....

Thanks. -registereduser(立牌坊); 2009-12-2 {849} (#5721417@0)
1. 不管你用老的VB, 还是新的.NET (C# , VB.NET), 你需要编个EXE . 不会有问题吧? (老的象VB6.0, 选EXE PROJECT, CODING... COMPILED; 新的VS.NET 什么的选CREATE PROJECT, C# , VB.NET你自便, BUILD后去BIN FOLDER你能找到EXE)
No. I do have problem to write a exe file. Any particular language do I need to know?

2. 在你的EXE 中用老的ADO 或新的ADO.NET 从DATABASE取回老的RECORDSET/新的DATASET 你应该会吧?
No. I do not know.

3. 把RECORDSET/DATASET 写在EXCEL文件中你会吧?
Yes, I done not through code.

4. 用老的CDO/新的NET.MAIL NAME SPACE组建你的EMAIL, ATTACH EXCEL文件.
No. I do not know.

5. 在SCHEDULE TASK中ADD TASK, CONFIGURE LIKE 5:00pm DAILY...ETC, 把上面的EXE定在这个TASK中.
Do you mean the schedule task in Windows or in some other system?

6. 天天休息喝茶了....
...It seems this approach having too much work to do, especially learning...

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)

@Florida

估计你没找对地方。

Replies, comments and Discussions:

More Topics