在sql server 2005中新建一个Integration Services 项目，怎样让他像SQL server job一样运行！

xx_adam 2006-07-03 06:00:59

建一个Integration Services 项目后，生成完成之后我想设置每天让他运行，我建立一个sql server job，但是找不到设置好的Integration Services 项目,或者可以为Integration Services 项目设置运行计划?

请指点！

...全文

204 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

拓狼 2006-07-06

打赏
举报

http://community.csdn.net/Expert/topic/4818/4818613.xml?temp=.5967676

cobejordan 2006-07-06

打赏
举报

我给你转到SQL Server版，斑竹ashzs对2005很熟。

redsee 2006-07-04

打赏
举报

具体在SQLSERVER 代理服务里
新建作业类型选Integration Services包
选择刚刚部署上去的Integration Services包

redsee 2006-07-04

打赏
举报

在VS中点部署后
在SQL2005的管理器里面有设置的

INTRODUCTION THE MOST IMPORTANT BUSINESS intelligence tool in the Microsoft Swiss Army knife of tools is SQL Server Integration Services (SSIS). This is because the other tools would be nothing without the cleansing and movement of data into a presentable format. The product can extract, transform, and load (ETL) data astonishingly fast. A 2010 benchmark showed movement of more than a terabyte an hour with SSIS! If you’re new to SSIS, you’ve picked a fantastic fi eld to become involved in. The one consistent skill needed in today’s technical job market is ETL. If a company wants to establish a partnership with another company, it’ll need to communicate data back and forth between the two companies. If your company wants to launch new products, it’ll need a way to integrate those prod- ucts into its website and catalog. All of these types of tasks are going to require the skill set you are developing and will learn in this book. Companies that had never used SQL Server before are now allowing it in their environment because SSIS is such an easy-to-use and cost-effective way to move data. SSIS competes with the largest ETL tools on the market like Informatica, DataStage, and Ab Initio at a tiny fraction of the price. SQL Server 2012 now offers more components that you use to make your life even easier and the performance scales to a level never seen on the SQL Server platform. The best thing about SSIS is its price tag: free with your SQL Server purchase. Many ETL vendors charge hundreds of thousands of dollars, if not millions, for what you will see in this book. SSIS is also a great platform for you to expand and integrate into, which many ETL vendors do not offer. Once you get past the initial learning curve, you’ll be amazed with the power of the tool, and it can take weeks off your time to market. This author team has trained hundreds of people over the years, and you’ll fi nd that the learning curve of SSIS is shallow relative to competing platforms. In SQL Server 2012, the product has matured to its third major envisioning. In this release the focus was on scalability, management, and more advanced data cleansing.

T_sql学习资料，关于sqlsrever2005性能调试和作业，有源代码和文档

自己做了一个SQL Serve版的Oracle Scott 用户下的表。

主要介绍了SQL Server创建维护计划失败（SQL Server:14234 错误）的解决方法,最后使用SQLServer2005 安装向导解决问题,需要的朋友可以参考下

创建数据库维护计划失败的解决方法创建数据库维护计划失败的解决方法创建数据库维护计划失败的解决方法

新技术前沿

6,128

社区成员

4,451

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章