xml - How to get the SQL query from a file in SSIS -

-

I am new to SSIS. I have a database from which I am receiving data Suppose DB is source and destination Anything can happen. (I tried DB in Excel and it worked fine)

In the source I have a custom query to get the data I wrote in properties that

Now I want to change it. I want to put it in some configuration file (XML file). That is, I want to get source queries from the XML file. How can I do this?

I am trying to do things as a whole newbie so please give your answer in particular.

UPDATE :

This is my package

I clicked the wet DB source twice, now this is what I wrote there

Enter image details here

I select the query in a configuration (XML) file, Age of exp> 4) Want to

  1. Create a package level variable for your query:

  2. SQL command instead of SQL command Change your source editor ("with the appropriate variable") to use: Enter image details here

  3. Go to the SSIS menu and click on "Package Configuration ..." and then click To enable the package configuration, click the "Add ..." button Enter image details here

... By default, it uses an XML configuration file, which is probably easy to work with, specify the file name - file The extension is .dtsConfig. If the file is not present on your machine, it will make one for you. Click Next.

  1. Find your variable, find the value property for the variable, and check the box for it. Click Next. Enter image details here

  2. For any of your configurations choose name .

  3. Find the configuration file on your file system, click again, then click Close in the package configuration list, so that you pay attention to your file system. If necessary, right-click an XML editor and edit Enter image details here


Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

c# - Chart control: Design messed Up after clearing and re-adding Y-Values -

-
Image
The day was struggling with this. I have three series on a chart that looks like this. Note: I am using vanof control. They are being added on the basis of input from the calculation. I am using this code to add value to each series. this.chart1.Series ["green"]. Points. AddY (greenvalue); This.chart1.Series ["totalsaving"] Points.AddY (totalsavingvalue). This.chart1.Series ["blue"] Points.AddY (bluevalue). I have set series properties like this. Both green and totalsaving are set to StackedColumn, the blue chart is set to the column for type. I started then To do is a button that brings the user back to the input field and then I am using this code to clear the series values ​​on the start code. chart 1. Series ["totaling"]. Points. clear (); Chart1.Series ["green"] Points.Clear () .; Chart1.Series ["blue"] Points.Clear () .; The same calculation click above is being calculated for the calculation of th...
Read more

Python Gstreamer for Lion -

-
I am working on a Kiwi project, and I want to be able to play it video, but I have been Gstreamer To set up I have to face a terrible time. I tried the brew install gst-python , but I get the following message, which is quite meaningless for me. brew install gst-python == & gt; GST-Python Dependency Installation: pygtk == & gt; Http://ftp.acc.umu.se/pub/GNOME/sources/pygtk/2.24/pygtk- Downloading- Pre-Downloaded: / Library / Catches / Homebrew /pygtk-2.24.0.tar .bz2 == & gt; Checking for .configure --prefix = / usr / local / cellar / pygtk / 2.24.0 pkg-config ... no GLIB - version & gt; = 2.8.0 ... No *** A new enough version of Pkg-config was not found. *** Configure http://www.freedesktop.org/software/pkgconfig/: Error: Need a gobject to create pygtk? Based on the site, I have to clone a repository, but is there a specific place in which the repository is needed? Is there an easy way to get Gstreamer, like PIP, or do I have to do all this to get it? This...
Read more