is there a way to import cXML data and also to generate cXML data using SSIS Package? If anyone could kindly guide me to right direction will be much appreciated.
View Complete Post
I am looking for best solution to perform incremental data load from MySQL database to SQL Server 2008. I tried to follow instructions from articles on incremental data load in SSIS using MD5 hashes but I failed to make connection in Lookup transformation
editor between MySQL Id (4 byte unsigned integer) and Id in SQl Server 2008 table which is bigint. i tried to add data conversion and convert MySQl Id to string. It works fine when you map this field directly to OLEDB destination but in Lookup
component it failed.
Any input greatly appriciated.
could any one tell me how could i load data from EXCEl file to XML
if some one could provide with appropriate link then it will b a great help
i have taken Excel source part is completed ..but what to do after that..
Hi, I have an issue where I am trying to reduce the time it takes to load SSAS cube data to SQL table using SSIS.
Within a Data flow task I have an OEDB source where in I select "command from variable" where the variable holds the dynamic MDX. I then have a data conv, lookup, derived transform and OLEDB destination respectively.
However the load takes some 2.5 hours for inserting 1 million rows. Any pointers as to how I may reduce it?
I have around 110 columns returned from the source MDX and it has 1 million rows as I said.
the lookup is to get a key not present in cube. since the lookup table is huge, i am using partial cache and the derived column transform just adds a string (hard coded) value of "ETL" and a time using getdate(). Data conversion is for the obvious conv for
ntext data (returned from MDX to corresponding datatypes in SQL table...I have the fast load option in the OLEDB destination.
I can't use openquery though. Let me know what may I do to reduce the load time.
I have used the above method to configure my crystal report ...
Its working fine , But i have huge number of data in database ....
So , it take long time to load the report ...
So , i have decided to show only the last 50 records inserted into the database , not all the 500 records to be loaded every time.
Plz help me with this issue ...
Also , Plz explain me abt index legend in crystal report.
A data source control is a server control that wraps some basic functions of a data source - be it a SQL Server database, an XML document, an Excel worksheet, or a sitemap description. Through the services of a similar component, data-bound controls can fetch data as well as insert new records or update and delete existing ones. Data source controls enable a consistent model across a variety of data sources and dramatically reduce the amount of code needed to implement a two-way data-binding scenario. This article provides an introduction to data source controls and other related data binding features.
MSDN Magazine June 2004
I have a Ajax Accordion control on my page with treeview in Content Template. As the treeview for each pane are big. I am wondering whether I can load the treeview from codebehind only after the pane is selected. I can reuse the code from ItemDataBound of Accordion control.