我有许多文件*.sql 书写文件,希望将这些档案纳入我的信息社会首脑会议一揽子计划。
能否将这些*.sql文档作为我一揽子发言中选择/Insert/Update/Create/Alter/Drop声明的来源?
目标是在不修改一揽子计划的情况下积极改变文字。
增 编
You can use Execute SQL Task where the statements come from these sql files. For example if you loop all your files of *.sql type in a foreach loop, then use Execute SQL task on the file connection you re looping on, you should be able to run all these SQL files without any problems. (Change SQLSourceType in the General pane of the Execute SQL Task editor)
您不使用“sql”文档,而是能够安排从Variables那里来的发言。 你可以从一揽子方案组合中确定这些变量,这些变量可以是XML文档。 这些XML文件可以储存库,而你可以在不必编辑或重新调配包裹的情况下加以改动,这应当给你以灵活性,以便你能够检索。 该连接了你如何建立这一联系。
If I can do the required ETL requirements using stored procedures, any advantages of using SSIS packages instead? My ETL stuff is nothing major. I feel like using an old technology. I like SQL. Old ...
I am using SSIS and I need to transform a date. How can I transform a date in String format (e.g. 14/09/1980) to the same but in date format in VB.NET? I would like the datetime format to insert it ...
I have written a SSIS 2005 script task that connects to Active Directory and reads user accountnames to store in database. I was able to successfully test this on my local system by executing dtexec....
I want to know how to import .mdb (MS Office 07) file into Sql server 2008 by SSIS. I need to run this ETL packet in such a way that it checks for duplicates, and if any doesnt re-insert them, but ...
I need to execute 29 ssis packages. So planning to create one master package which will execute all these packages. I don t know how to implement this. Can you please explain in brief. Thanks in ...
I have a server that has a SQL Agent job setup to run a two part datawarehouse build and Analysis Services cube build. The job ran successfully until there was a problem with Management Studio and ....
In SSIS 2008, the ability to reference other class libraries has been added. Is there anyway to resolve the references to a non-GAC location when deployed to a non-developer environment? For instance, ...
I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...
