我正在使用一种习俗“Connection Manager”,与一个专有数据库进行会谈。 该物体的习俗财产部分的一个领域称为“DataQuery”,其中你可以确定另一端将执行的询问。
我想利用“Task”号信,利用一些变数、一些正本逻辑等,在飞地上架设“Q”号。
问题在于我知道如何在文字任务中设定一个变数,但我不相信(或如果可能的话)合成物来确定习惯财产价值。
Some, psuedo code would be:
MyConnectionManager.Properties["DataQuery"] = myQueryString;
提前感谢!
您是否掌握更多有关海关联系管理人员的信息,一般而言,查询不是联系管理人本身的一部分。
也许你可以:
利用文字任务将习俗问题划分为变量。
在习俗联系的特性方面,扩大表述
在财产项下裁定“数据”
在相应的表述中,使用了文字任务中产生的变量。
页: 1
选择连接财产,利用描述任务中产生的变数作为表达方式建立联系
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 ...