×

Loading...
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

@Calgary

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)
Export SQL Server data to Excel: http://msdn.microsoft.com/en-ca/library/cc952922.aspx

Other SSIS how to videos:
(#5712459@0)
Last Updated: 2009-11-28
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:
    • 到一个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.
          • 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)

More Topics

  • GitHub Spark
  • 脑洞大开，突发奇想，用力来传播信息
  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
    • 枫下论坛主坛 /  工作学习 /  学科技术讨论