View Complete Post
I would like to identifying the source & destination tables of the data flow or the transformation task.
I need to create a custom component which i can put into existing packages which can do some validation.
Please suggest ways i can accomplish this.
I'm using SSIS 2008
I have a data flow that gets data from an Excel spreadsheet. It then does numerous lookups to my database to ensure that all the entities in the spreadsheet are present in my dimension tables. For each of these lookups, I redirect rows with
"no matching entries" to be written to another spreadsheet which is then sent to an email address for action.
I have a Package scoped variable that I want to update if any of the lookups have rows with no matching entries. This is used later in the package to determine if it should proceed or not. So this variable only needs to be updated once if any of the lookups
What are the options for doing this? What is the best way?
I am trying to use the SSIS XML Source object to insert data from an XML file into a relational database. Within the file and database there are several one to many relationships. For example, the Person table has a one to many relationship with
the Phone table - one person can have multiple phone numbers.
In my XML file, the PersonID is declared only once and that is with the person data. I need the PersonID as a foreign key for the phone data. The XML Source object displays multiple outputs for the XML file, including one each for Person and
Phone. However the Phone output does not include the PersonID which is required to insert the data into the Phone table.
How can I get the PersonID to appear with the Phone data? Is it a matter of modifying the XSD file, or is there method within SSIS where I can combine XML elements from different levels?
Having difficulty with an idea for a SQL query today. I am working with a data set that points to an ODBC data source. The data source has several TRANSACTIONmmyyyy tables (mm - month, yyyy - year ), each holding data for a particular month,
going back several years. Each table has identical fields and data types.
If I were to run the query below for just one month ( say I took out mmyyyy and plugged in a month and year, 052010 ) it will pull totals for the AccountNum I specify.
mmyyyy.Amount ) As
mmyyyy.AcctNum = TOTALS.AcctNum AND
mmyyyy.Region = TOTALS.Region AND
I find this advice in the SSIS forum . . . but I can't find the DataReader Source in the Data Flow source items . . . nor do I seem to be able to 'Add Item' that time.
Advice appears to be I should use DataReader Source when pulling data from Oracle using ODBC e.g.:
"ODBC is supported in the data flow by the Data Reader source adapter. I think the original problem may have been that you were trying to use the Data Reader source with an ODBC connection manager.
To extract data from an ODBC source, try the following:
Any help getting the DataReader Source to appear in the BIDS toolbox appreciated.
Thank you and a Happy time with family tomorrow,
I have a page in my website where there is very little code-behind. I only have two lines of code in Page_Load() and the rest of the code is declarative ASP.NET code. I have a FormView control which uses a SqlDataSource to get some order information. The SqlDataSource calls a stored procedure called usp_GetOrderDetails, here's the code for the SqlDataSource:
<asp:SqlDataSource ID="sdsFormOrderDetails" runat="server" ConnectionString="<%$ ConnectionStrings:ForexDB %>" ProviderName="<%$ ConnectionStrings:ForexDB.ProviderName %>" SelectCommand="usp_GetOrderDetails" SelectCommandType="StoredProcedure" UpdateCommand="usp_UpdateOrder" UpdateCommandType="StoredProcedure" > <SelectParameters> <asp:ControlParameter Name="orderId" ControlID="grdOrders" PropertyName="SelectedDataKey.Value" /> </SelectParameters> <UpdateParameters> <asp:ControlParameter Name="orderId" ControlID="frmOrderDetails" PropertyName="SelectedValue" /> </UpdateParameters> </asp:SqlDataSource>
If you want to save, organize, and annotate snapshots of your database data, find an easy way to install and configure Subversion, and automate the organization of your source code, then you'll want to read more about these latest tools.
MSDN Magazine August 2009
Flow documents offer enormous flexibility in arranging text layout and pagination, but they don't support data binding, so you can't dynamically change content. Here we build a component to solve that problem.
Vincent Van Den Berghe
MSDN Magazine April 2009
In T-SQL, views and derived tables serve similar purposes and have their advantages. But when working with SQL Server 2005,there's a third option--using Common Table Expressions (CTEs). John Papa explains.
MSDN Magazine October 2007
Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.
MSDN Magazine February 2007
This month John Papa fields some of his favorite questions regarding data manipulation with ADO.NET.
MSDN Magazine January 2007
ASP. NET 2. 0 introduces a series of new tools that improve data access including several data source and data bound controls. The new assortment of data source controls can eliminate a ton of repetitive code that was required in ASP.
MSDN Magazine January 2005
Managing relations in a database became a whole lot easier with ADO. NET. Instead of returning a single rowset to a data store, you can return a series of rowsets and relate them within a DataSet. There are numerous advantages to using related DataTables in ADO.
MSDN Magazine January 2003
I am Visual Web Developer user and facing a problem when I am creating a local report (.rdlc) file.
I am using Business objects as the Data Source for this report. It was working perfectly until all the items in the Website Data Source window suddenly "disappeared". The "Add New Data Source" button on this window is also disabled. Now the window is just like a blank box only. And I can't continue working with the report file like this...
I have tried undoing what I did before but it does not help at all...
Any reason for this to happen? There is no sign or something at least indicating what is wrong.
ps: found a similar thread in this forum but not solved