We wish to import data into a SQL Server database from a source location located elsewhere in the company WAN in another country.
我们正在利用SSIS进行进口,但想知道做 extract和改造的最佳地点是什么。 我们可以对来源服务器形成一种看法,而信息社会首脑会议将直接从中检索数据。 另一种办法是将档案从来文方中删除,由SSIS从该档案中进口数据。
我认为前者是一个更清洁的解决办法,但想知道在利用档案或直接利用数据的潜在问题方面是否有任何好处?
增 编
我尽可能避免使用档案,特别是如果你的起点是数据库的话。 通过抽取档案,你将在这个过程中增加不必要的一层,从而增加错误的影像。 使用抽取文档的典型问题包括不知情地使用旧/不完整的档案(如果提取失败的话),掩盖用户手工编辑的改动(数据问题档案中的直接内容)。
If you have a SQL Server database, then creating a stored procedure, view or entering sql into SSIS would give you defined interface between source and SSIS. Including the transform with the extract does blur the interface a little, but is quite common for simple transformation that do not depend on any target (or secondary source) data for the load.
在数据交易状况时(采用两种方法)可能需要考虑一个问题。 根据你的消息来源,你可能需要处理各个完整状态的数据,并采取适当行动。
I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...
In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user ...
I have been trying to execute a MS SQL Server stored procedure via JDBC today and have been unsuccessful thus far. The stored procedure has 1 input and 1 output parameter. With every combination I ...
Is it possible to use the sqlcmd command to dump table structure the way it can be done with mysqldump?
Hi I have the following SP, however when I use LINQ to SQL it generates 2 multiple recordsets. For my sanity I am trying to fathom out what it is in the stored procedure that is doing this and would ...
I want to create a table in MS SQL Server 2005 to record details of certain system operations. As you can see from the table design below, every column apart from Details is is non nullable. CREATE ...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...
How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8
