是否有更动态的 SSIS 配置文件存储解决方案?
从我所读到,共同的解决方案是使用每组配置文件的“标准”地址/文件夹
I. E. C: Config
是否正在让这个变体更具动态性? 通过将它从变量驱动到前面, 或者甚至将服务器名称附加到前面, 从而可以使用共享位置“ serverconfig ” 吗?
提前感谢
两种选择:
关于选择合适的配置战略的更多信息:http://msdn.microsoft.com/en-us/library/cc671625.aspx
.ConfigsMyConfig.dtsConfig. SSIS will try to access the Config directory from the path where your SSIS package is executed. This can be annoying to deploy, as in debug mode, SSIS executes from the bin directory of your project.BIDS 2008 doesn t work on relative path,may be some kind of bug If you try to enter the relative path , on clicking next it calculates the whole path. The best workaround is to open the SSIS xml search for the path you just entered and make it as relative. For eg.
In BIDS package configuration window you have entered path as: c:BIDSabc.config Go to Package xml search for above line and replace with : ..BIDSabc.config
and save it. the work is done, now if you reopen the SSIS in the BIDS window and check the package configuration window it will show the relative path.
要查看 xml, 请到 BIDS 的解决方案探索窗口, 右键单击软件包, 点击视图代码 。
希望这样能帮上忙
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2
I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...