Reading An XML Dataset Into A SQL Server Dynamically
Sep 8, 2005
Hi,
I have multiple XML files that I am reading into a DataSet in C#. What I
would want to do it Create Tables from the DataSet in the destination
database and fill the tables with data from the DataSet.
Any ideas???
Thank you.
*** Sent via Developersdex http://www.developersdex.com ***
View 1 Replies
ADVERTISEMENT
Oct 7, 2007
Hi,I have a requirement to load data from a flat file.The flat file has a naming convention and thus a timestamp is appended to it. eg : RMRS_07102007_001.delThis makes the file name different each day, Is there any method where by I can provide a dynamic name in the file connection manager.P.S. I tried a variable in For each loop with file enumatror and stored that in a variable , but I was not able to use that variable in File connection manager. pls guide if i was missing anything.Thanks in Advance, Ashish Prasad
View 1 Replies
View Related
May 29, 2008
How do I address specific fields within a Dataset? I have built the DataSet from an SQL SELECT and now need to grab some of the data. I am a bit confused. Here is a code snippet (C#) but the compiler complains about my arrays. Can anyone offer a suggestion or two?
using (SqlConnection config = new SqlConnection(configString))
{
SqlConnection con = new SqlConnection(configString);
String selectString = "SELECT Column, FlowPoint, Label FROM CounterConfigurator";
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = selectString;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
config.Open();
da.Fill(ds, "Labels");
DataTable dt = ds.Tables["Labels"];
config.Close();
/*-----------------------------------------------------------------------------
*At this point, I have filled the data table, "Labels", with the values
*from the CounterConfigurator table in the DB "Logger".
-------------------------------------------------------------------------------*/
//Labels
foreach (DataRow row in dt.Rows)
{
//lblPT1.Text = row[0][0]; The first column is the TOTAL Column.
lblPT10.Text = row[1][2];
lblPT11.Text = row[2][2];
lblPT12.Text = row[3][2];
lblPT13.Text = row[4][2];
lblPT14.Text = row[5][2];
lblPT15.Text = row[2];
lblPT16.Text = row[7][2];
lblPT2.Text = row[2];
lblPT3.Text = row[9][2];
lblPT4.Text = row[10][2];
lblPT5.Text = row[11][2];
lblPT6.Text = row[12][2];
lblPT7.Text = row[13][2];
lblPT8.Text = row[14][2];
lblPT9.Text = row[15][2];
}
//FlowPoints
foreach (DataRow row in dt.Rows)
{
//PT1 = row[0][1]; The first column is the TOTAL Column.
PT10 = row[1][1];
PT11 = row[2][1];
PT12 = row[3][1];
PT13 = row[4][1];
PT14 = row[5][1];
PT15 = row[1];
PT16 = row[7][1];
PT2 = row[1];
PT3 = row[9][1];
PT4 = row[10][1];
PT5 = row[11][1];
PT6 = row[12][1];
PT7 = row[13][1];
PT8 = row[14][1];
PT9 = row[15][1];
}
}
}
View 1 Replies
View Related
Apr 16, 2007
HI ,
I am using SQL Server 2005 Reporting Services. I have many parameters to pass to the dataset. Is there a way to change the dataset dynamically based on the parameters selected?
Suppose If param1 is selected, I want to use dataset1 and if param 2 is selected. I want to use dataset2 and so on... in my reports.
Any help is greately appreicated!
Thanks in advance!
View 8 Replies
View Related
Jan 25, 2007
Is it possible to pass the dataset dynamically in ssrs???
I am using sqlserver express edition at present. so in future it may change. is it possible to change the dataset in future or not???
View 5 Replies
View Related
Jan 26, 2007
I am building a mailing list report.
I have the report all built to display name, address, etc and this works well if i build the dataset in RS.
Problem:
I want to use this same report to build mailing list for any group of people the user selects while using a c# application.
Question:
Is there anyway to build a dataset in an application then send it to RS?
thanks
lucas
View 5 Replies
View Related
Jan 30, 2008
Hi All,
I have a Dataset. I use this dataset in my matrix for grouping based on the underlying table columns names. Users can add columns to the underlying table that the DataSet refers.
Now my problem is:
The data is grouped based on the column name selected from the parameter.
If the user adds a column to this table how will the dataset refresh so that it contains the newly added field for grouping data.
View 5 Replies
View Related
Jan 31, 2008
Hi All,
How to assign dataset(meaning SQL Query) to a report at RunTime. Please help me in doing this it's urgent.
-SR
View 4 Replies
View Related
May 1, 2007
Hi all,
Is there a way to change the dataset being used by a table dynamically ?
Regards,
Neil
View 2 Replies
View Related
Jul 27, 2007
It's been a while since I used Reporting Services so I'm sure this is really straight forward. Basically I have the following report parameters:
reportMonth - Just a non-queried list of months for the user to select
reportYear - Generated using the following query from dataset "Years":
declare @curYear int
set @curYear = 2000
declare @yearTable table (repYear int not null)
while @curYear <= year(getdate())
begin
insert into @yearTable(repYear) values (@curYear)
set @curYear = @curYear + 1
end
select * from @yearTable
This generated a list like:
2000
2001
2002
etc.
I then have a 2nd dataset "Main" which I'd like to use both the reportMonth and reportYear parameters in once they've been generated. How do I go about setting this up and referencing the parameters? I've tried a few things but nothing seems to be working.
Thanks
View 10 Replies
View Related
Apr 30, 2007
I have a remote report ...
I need to call one of two stored procedures depending on which parameters were passed to the report. (Both stored procedures return the same fields.)
Does SQL Reporting Services allow you to switch the dataset or stored procedure name dynamically? If so, where do I put the logic? Right now I have it working with one stored procedure.
I'm thinking that I should just make one stored procedure that takes all parameters and calls one of the other two stored procedures. Do I have any options besides this?
Thanks in advance!
View 3 Replies
View Related
Jul 18, 2007
Hi All,
I am working on a report which displays profit and loss discrepancy between two systems. So if there is discrepancy, in other words, the dataset returns value, then I want reporting serive to deliever the report to intended users. I am currently using standard edition with no data-driven subscription support.
I do not know what is the workaround for this implementation. Tks for advise in advance.
Alex
View 7 Replies
View Related
May 26, 2015
I have a report with multiple datasets, the first of which pulls in data based on user entered parameters (sales date range and property use codes). Dataset1 pulls property id's and other sales data from a table (2014_COST) based on the user's parameters. I have set up another table (AUDITS) that I would like to use in dataset6. This table has 3 columns (Property ID's, Sales Price and Sales Date). I would like for dataset6 to pull the Property ID's that are NOT contained in the results from dataset1. In other words, I'd like the results of dataset6 to show me the property id's that are contained in the AUDITS table but which are not being pulled into dataset1. Both tables are in the same database.
View 0 Replies
View Related
Oct 1, 2015
I have a small number of rows in a dataset, Table 1. There is a CLOB on a large dataset, Table 2. They join on a PK. I would like to retrieve this CLOB and add it to the data flow for Table1. In short I want to emulate the following:
Table 1: Small table without CLOB, 10 rows.
Table 2: Large table with CLOB, 10,000,000 rows
select CLOB
from table2
where pk = (select pk from table1)
I want this to return the CLOBs for the small number of rows in Table 1. The PK is indexed obviously so it should be a fast look up.
Table 1 and Table 2 live on different Oracle databases. How do I perform this operation efficiently in SSIS? It seems the Lookup and Merge Join wont do this.
View 2 Replies
View Related
May 27, 2015
I have a report with multiple datasets, the first of which pulls in data based on user entered parameters (sales date range and property use codes). Dataset1 pulls property id's and other sales data from a table (2014_COST) based on the user's parameters.
I have set up another table (AUDITS) that I would like to use in dataset6. This table has 3 columns (Property ID's, Sales Price and Sales Date). I would like for dataset6 to pull the Property ID's that are NOT contained in the results from dataset1. In other words, I'd like the results of dataset6 to show me the property id's that are contained in the AUDITS table but which are not being pulled into dataset1. Both tables are in the same database.
View 3 Replies
View Related
May 21, 2007
I found out the data I need for my SQL Report is already defined in a dynamic dataset on another web service. Is there a way to use web services to call another web service to get the dataset I need to generate a report? Examples would help if you have any, thanks for looking
View 2 Replies
View Related
Oct 4, 2007
I have an Excel sheet that is dynamically updated (through DDE) and I want to import this data to a table in SQL Server 2005. Using SQL Server Management Studio to configure an Excel data source as a linked server.
(http://support.microsoft.com/kb/306397/EN-US/)
Following the first 5 steps should let me acces the table (but I cannot view the data in SQL Server 2005). However, I could not find how to export the data into an existing table. Does anyone know how or can give a pointer to document describing how to do this?
View 8 Replies
View Related
Oct 12, 2007
Is there any way to display this information in the report?
Thanks
View 3 Replies
View Related
Oct 28, 2006
I am using sql server 2005.and planning on putting my html pages into the sql server as to many editting is going on the web site.(a news site) what are pros and cons using sql server as a holder of the aspx.HTML code ?*using a varchar(MAX) field for htmlcode thanks
View 1 Replies
View Related
Apr 21, 2004
ok I use a datareader..Perhaps not the best method..but...if a better one exsits please let me know...
The problem...
I get info on a user....It returns an unknown amount of rows back....lets say two for instance....
ok...
How do I tell the number of rows....also the ability to reference each row and items in that row....
..
i.e. Row contains this
uname | password | address | Phone | notes
Like I said could contain multiple rows
I need to figure out info for specific rows and items in it....
in datareader I know you can reference each item which I guess you could use x number of variables to get each item in the row but that is tedious....
IS there a better answer????
View 3 Replies
View Related
May 14, 2004
Hi
I am using the following example for reading images.
But, I want to attach the image to independent ASP.NET image control. Not in a datagrid.
Any ideas on how to do that? Please explain.
Thanks
P.
View 2 Replies
View Related
Feb 27, 2004
hi to all
I have been trying to read XML file in SQL Server with Stored Procedure. but i coud't get any solution.
can any one Help me.
I have XML file with List Of Countryes each Country has Id.
I need to read all Country Id,CountryName and need to be insert into DataBase or Return as String (output parameter).
How do I achive this? please Help me.
Cheers
:confused:
Buddu
View 1 Replies
View Related
Mar 24, 2008
Not sure if I am posting this in the correct placed. Here is what I am trying to do. Read an xml files which is very large and is our store xml file. I want to import this data into a database nightly. I can down load the file and I have noticed that it has one line in it that will keep me from reading it: <!DOCTYPE StoreExport SYSTEM "http://..../doc/dtd/StoreExport.dtd"> Once I removed this line I can get the data needed to go into the database. I would removed the old table first then replace it with the information from here.
Can anyone help. I hope I have given enough information for this type of issue. I was told integration services would do this, but I am not sure how. Could someone point me in the right direction.
Thank you for any an all help.
Dee
View 13 Replies
View Related
Mar 24, 2008
Not sure if I am posting this in the correct placed. Here is what I am trying to do. Read an xml files which is very large and is our store xml file. I want to import this data into a database nightly. I can down load the file and I have noticed that it has one line in it that will keep me from reading it: <!DOCTYPE StoreExport SYSTEM "http://..../doc/dtd/StoreExport.dtd"> Once I removed this line I can get the data needed to go into the database. I would removed the old table first then replace it with the information from here.
Can anyone help. I hope I have given enough information for this type of issue.
Thank you for any an all help.
Dee
View 4 Replies
View Related
Jul 7, 2006
Hello,
I could save the file in the sql server database. The problem i am having is, I am not able to read the document from the database. I do not want to use response.outputstream......
I have to read the file for specific contents. Anyhelp would be great.
- Suresh
View 2 Replies
View Related
Feb 22, 2008
Can anyone explain me simple language and easy to understand query execution plan. I am a fresher assigned to read and evaluate execution plan. i do not understand where is the problem. what percentage is considered as good sql and what percentage is considered as bad sql.
how do i understand whether there is a problem in sql or joins or index or anything else. Please explain me step by step what should be considered and what recomenendation should i give for each problem.
View 6 Replies
View Related
May 7, 2008
Hi,
I have a stored procedure attached below. It returns 2 rows in the SQL Management studio when I execute MyStorProc 0,28. But in my program which uses ADOHelper, it returns a dataset with tables.count=0.
if I comment out the line --If @Status = 0 then it returns the rows. Obviously it does not stop in
if @Status=0 even if I pass @status=0. What am I doing wrong?
Any help is appreciated.
ALTER PROCEDURE [dbo].[MyStorProc]
(
@Status smallint,
@RowCount int = NULL,
@FacilityId numeric(10,0) = NULL,
@QueueID numeric (10,0)= NULL,
@VendorId numeric(10, 0) = NULL
)
AS
SET NOCOUNT ON
SET CONCAT_NULL_YIELDS_NULL OFF
If @Status = 0
BEGIN
SELECT ......
END
If @Status = 1
BEGIN
SELECT......
END
View 4 Replies
View Related
Mar 25, 2008
Hi All,
I Need to load the text(CSV) files into sql server using text reader. Please can any one give me the code for that.
I want read that file in web page only. I can't use Bulk Insert.
First I will read the file into data set. Then i wanna update that in sql server table.
Thank you,
View 1 Replies
View Related
Jun 17, 2004
A section of this company's intranet site where I just started interning at has little company anniversary and birthday sections that look like (for the anniversary section.. in the birthday section, it looks the same, except it doesn't say how old the comployee is):
-Steve Cunningham 6/1 - 6 yrs
-Andrew Brown 6/3 - 11yrs
-Lisa Stone 6/4 - 3 yrs
How can I get it so instead of manually changing that text every month, it will look at a SQL database and automatically change that text every month? I'm guessing the pseudocode would be if the b-day or anniv. month matches the current month, display the first and last name, the date, and number of years (which would have to be calculated maybe?) Any help would be GREAT! Thanks!!
~Michael
View 2 Replies
View Related
Mar 13, 2007
Hi,
I am trying to read data from a column of an excel file which contains numbers in some cutom format _($* #,##0.000_);_($* (#,##0.000);_($* "-"??_);_(@_)
When I click on the preview button in the transformation properties I am not able to see any data in this column.
Please let me know if there is any setting in DTS which would allow me to read data in any format in the excel file.
Thanks!!
Rajan
View 2 Replies
View Related
Aug 17, 2000
What is the best way to read and edit data in the tables of a sql server 6.5 database?
Thanks
Gunnar
gunnardl@yahoo.com
View 1 Replies
View Related
Jul 28, 2006
I'm trying to pull certain Filemaker 5 tables into SQL Server 2000 inan automated import job using a file DSN. Everything resides locallyon a Windows XP machine. My process works fine on a test FM file withno password, but with the real FM files, all password protected, itfails with this error:******Error Source: Microsoft OLE DB Provider for ODBC DriversError Description: Unspecified error[FileMaker][ODBC FileMaker Pro driver]An error has occurred whiletrying to gather a list of available tables.[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed.Context: Error calling GetRowSet to get DBSCHEMA_TABLES schema info.Your provider does not support all the schema rowsets required by DTS.******This happens whether or not I supply a password to the SQL Server job.It has been nagging me for days and I can't find any documentation onit. Has anyone else encountered this?Thanks very much.Scott
View 1 Replies
View Related
Jun 7, 2007
Hi,
I'm new to SSIS.
Is there any recommended reading material that you suggest to learn more how SSIS works?
Thank you!
View 1 Replies
View Related