Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How To Extract Data After The Comma


hi there
i have a field name(fil_srt_cond) with the values of

cmpnt_name,ASC,1,2
cmpnt_stuff,DESC,2,3

i used the char index:-

substring(BSSF.fil_srt_cond,charindex(BS.column_na me,BSSF.fil_srt_cond) + LEN(BS.column_name) +1 ,3) ord,

substring(BSSF.fil_srt_cond,charindex(BS.column_na me,BSSF.fil_srt_cond) + LEN(BS.column_name) +5 ,1) len,

substring(BSSF.fil_srt_cond,charindex(BS.column_na me,BSSF.fil_srt_cond) + LEN(BS.column_name) +7 ,1) str


to display them in their specific fields like

NAME STAR_CHAR LENGTH ORDER
Tag 1 2 ASC

however for cmpnt_stuff,DESC,2,3 i'm getting
NAME STAR_CHAR LENGTH ORDER
Stuff , , DES

therefore i'm not getting the required values 2 and 3.
can u pls help me to find a way how to get the data after the comma. thank you in advance


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Extract Outlook Contacts Data(on Public Directory) Directly In Data Flow
Hi everyone,

I have to extract, dayly a list of contacts on a exchange server in a table on our EDW on sql server 2005. Is it possible to get the information directly from a dataflow or i will have to developpe a script task?

Need help desperatly !!!



View Replies !   View Related
Data Flow Task Error To Extract Data From Sql Server To Excel
Hi All,

I want to export data from SQL Server2005 to an Excel spreadsheet thru "Data Flow Task".I am using OLE DB for SQL Server for the source connection and a Connection To Excel as my destination source. The Excel spreadsheet (2003) exists and has the first row with column names.I don't have any warnings before trying to execute.

The SQL datable fileds are
i) ID - Int

ii) RefID
iii) txtRemarks - nvarchar(MAX)
iv) ddlWaterLevel - nvarchar(50)

While executing the tasks, I got the error
Error: 0xC0202025 at Data Flow Task, Excel Destination [427]: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "Excel Destination" (427) failed the pre-execute phase and returned error code 0xC0202025.


After analysing I found in the DataFlow --> Excel destination --> Advanced Editor for Excel Destination, the default data type for txtRemarks shows as "Unicode string [DT_WSTR]". But this is supposed to be "Unicode text stream [DT_NTEXT]".Even if I change the data type in the design time, It doesn't accept.

Please do help me out.

thanks
Sanra

View Replies !   View Related
Comma Delimited File With Comma Inside A Column
Using Flat File Connection Manager, I am specifying Text Qualifier = Double quotes{"}, and i have TXT file with one column for lastname and first name as "LN,FN", and settings are set to comma delimted, now the connectin manager is creating two different columns for LN and FN,

it was never a problem in DTS 2000.

any work around.

Thanks,

View Replies !   View Related
Extract Data From SQL 6.5
I need to get some data from an enormous, creaky old SQL 6.5 database.I know nothing about either the data schema (though I believe some sortof documentation exists), nor 6.5 for that matter, having come to SQLServer at 7.0.My clients need the data in comma delimited format.Please, can anyone suggest any possibilities? One thing that occurredto me might be to create an Access application, use an ODBC link to theSQL DB, and then leverage Access' not inconsiderable functionality toget the data out.Does anyone foresee any problems with this, or any better ways?Forever in your debt.Edward--The reading group's reading group:http://www.bookgroup.org.uk

View Replies !   View Related
Extract Data From DB2
I have a package which establishes connection with DB2 server.I dont have any db2 application where i can format query for db2.This is my query in access/sql.
can someone help me converting it into a db2 query.i tryed to google and use the functions but i failed and even the error that ssis gives don't help asthey are same for any type of error.
Thanks in ADV

SELECT table1.YYYY & table1.MM as MO_YR,
table2.CNTRYCD AS CNTRY_CD,
Sum(table1.AMT) AS [VALUE]
FROM table1
INNER JOIN table2
ON (table1.MM = table2.MM)
AND (table1.YYYY = table2.YYYY)
WHERE (table1.YYYY BETWEEN YEAR(DATE()) AND YEAR(DATEADD("m",-3,DATE())))
AND (table1.MM BETWEEN MONTH(DATE()) AND MONTH(DATEADD("m",-3,DATE())))
GROUP BY table2.CNTRYCD, table1.YYYY, table1.MM

View Replies !   View Related
Extract Data
I have the following data example,
Street
Forest Ridge Dr
Whites St
Alba Rd

I wish to achieve the following,
Street StreetSuffix
Forest Ridge Dr
Whites St
Alba Rd

I have the following code
INSERT Addr2 (AddressID, LotNo, FlatNumber, HouseNum, Street, StreetSuffix, Locality,
PostCode, [State])
SELECT LotNo, FlatNumber, HouseNum, SUBSTRING(Street, 1, (PATINDEX('% %', Street))),
LTRIM(SUBSTRING(Street, (PATINDEX('% %', Street)), 20)), Locality, PostCode, [State]
FROM Addr1

But i get the following result which is no good!

StreetStreetSuffix
Forest Forest
WhitesWhites
Alba Alba


What am I doing wrong in the Street & StreetSuffix Functions above?


I have this working with a cursor but I'm trying to work out a set based solution as the cursor
takes way to long to complete.


In the Cursor I'm performing the code below per row of AddressID
SET @SpaceLength = (SELECT PATINDEX('% %', @Street))

SET @Suffix = (SELECT SUBSTRING(@Street, @SpaceLength, 20))

SET @Street = (SELECT SUBSTRING(@Street, 1, @SpaceLength))


View Replies !   View Related
Data Extract Question
Hi, I'm hoping someone has an idea or two on this topic. 
Basically I have three tables of data say tContact, tQuestion, tAnswer

tContact
-----------
ContactID
Email
Name

tQuestion
------------
QuestionID
Question

tAnswer
------------
QuestionID
ContactID
Answer

I need to extract the data for the client and they would like to see
the data with one line per contact, but showing every answer to every
question... they would like the data formatted like this:

ContactID, Email, Name, Question1Answer, Question2Answer, Question3Answer, Question4Answer, etc........

Obviously to get the data I cansimply do an outerjoin to get all
contact data then all questions, and answers that exist... but that
will obviously return tabular data with one row per each
answer...  Does anyone have any ideas on how to do this using just
SQL?  I can pull the data and write a function that spits it out
to text using the Stringbuilder class and some logic, but I'm thinking
this must be possible in SQL natively... any help would be more than
appreciated.  Thanks in advance.

-e

View Replies !   View Related
Query Help -- Extract Data, Thanks!
Hello,Please see the original data below. I would like to extract the accountwith the earliest opening date only, and leave all the accounts openedafter that out. Could anybody help me with the query? Thanks a lot!Original Dataperson_idaccountopen_date1000111111115/15/20031000122222226/20/20041000133333332/16/2005Ideal Outputperson_idaccountopen_date1000111111115/15/2003

View Replies !   View Related
How To Extract Data From One Database To Another.
Hi,Anybody have an idea of copying data from tables of a database to anotherdatabase. It should be a choice to select all tables, single table orseveral tables.For them knowing Oracle it is possible to do it with 'exp', where you canchoose to script the database with or without data. So I am trying to getalike to MSSQL. The job is to unload data from a database with onestructure to another database with another structure.Thanks in advanceBest regardsTom Frank

View Replies !   View Related
How Do You Extract Data From A SAS Database?
Does anyone know how to directly extract data from a SAS database (Verison 6.12 or V8)?
Currently I run a SAS program which exports a tab delimited file. I then build a local package to create a SQL 7.0 Table.

View Replies !   View Related
How To Extract Data In Two Table
I've two table.......
One table Name Form1
Ex
----------
Name|F1No
----|-----
23wa|1
xyzx|2
abcd|3
......
......
......
---------
F1No====>primary Key
Second table Name Form2
Ex
--------
F2No
----
3
1
2
2
2
1
......
......
......
--------
F2No===>Foreign Key

i want top 3 Name(field) in first table(Form1).

Result
------
xyzx
23wa
abcd

View Replies !   View Related
Data Extract - Partitioning
Hello,

I have a table containing 3 columns Department Name, RiskScenario and Cost. I am trying to create a data extract that contains the top 3 Risk Scenarios (sorted by Cost) per Department.

I tried using this sql statement in MSQuery but it doesn't work. Any ideas where I'm going wrong or if there is a simpler way to do this?

Select * from (
SelectDepartmentName,`Risk Scenario`,Cost, row_number()OVER (PARTITION BY DepartmentName order by Cost) rn
FROM'Departmental Risks`) where rn <=3

Please help. Just can't figure this out!

Meera



View Replies !   View Related
Take Data, Write Down, And Separate With A , (comma)
Hello there,How can i take data out of my database, put them into a textbox and then separate with a comma..An example:----------------------------------| column Email           || mail1@email.com     || mail2@email.com     || mail3@email.com     |----------------------------------Put them into a textbox and separate with a , (comma)-------------------------------------------------------------------------------------| mail1@email.com, mail2@email.com, mail3@email.com |-------------------------------------------------------------------------------------Anybody who know how I can do that? :S

View Replies !   View Related
Help Moving Comma Delimited Data
I posted this originally in the incorrect forum I believe so I am reposting this in here which I believe is the proper place.

I need to move essentially a flat file from one server to another one and export it into a database on the second server. Does anyone have an easy process to accomplish this? I am currently at a loss. Any advice would be much appreciated.

Thanks

View Replies !   View Related
Function To Extract Delimited Data
I'd need to have a function that allows me to extract 'fields' fromwithin the stringI.E. (kinda pseudo code)declare @foo as varchar(100)set @foo = "Robert*Camarda*123 Main Street"select EXTRACT(@foo, '*', 2) ; -- would return 'Camarda'select EXTRACT(@foo, '*', 3) ;-- returns '123 Main Street'select EXTRACT(@foo, '*', 0) ;-- would return entire stringselect EXTRACT(@foo,'*' , 9) ;-- would return nullExtract( string, text delimiter, occurance)Anyone have something like this as a user defined function in SQL?TIARob

View Replies !   View Related
How To Extract Data From A Concatenated Field
Hi everyone. I need help extracting information from a concatenated field delimited by a '/' character. I know that the logic is to basically find the position of the '/' character and use the substring function to extract the data but I am unfamiliar with how to do this in SQL Server 2000. Please see examples below. Thanks in advance.


FIELD
----------
1234/4567
2345/6754
1234


I need to extract the data before and after the '/' character. There are records however with on the leftmost part of the data such as row number 3.

FIELD 1 FIELD 2
------------------
1234 4567
2345 6754
1234

View Replies !   View Related
MS SQL Job To Extract Data From Oracle/ODBC
Hi all,

I would like some information on extracting data from an ODBC connected database. (oracle is the current master database).

I can connect to the oracle database, and view tables.

But I would like to create a job (in SQL server) that runs every hour to retrieve current data from the oracle database.

Has anyone accomplished this, or is there a tutorial about this procedure?

Any help would be appreciated....

thanks
tony

View Replies !   View Related
Modifying Data From Extract Before Import
Hi all,



Having some fun with an excel import.



I have a excel sheet that has data that needs to be UpSert'ed into 2
different tables. In addition, I need to use a value in the spreadsheet
to determine the PK from a reference data table, for one of the UpSert
oprations.



That is all working now.



The thing I'm struggling with is something I am sure is quite simple -
but I'm not seeing a solution from attempts, googling or BOL.



2 of the columns I receive have either nothing, or X in them. The columns they go into are defined as BIT, NOT NULL.



So, in SQL it would be something relatively simple like:



CASE

When IsAvailable = 'X' then 1

When IsAvailable is null then 1

ELSE 0

end



But I don't know how to do this to data that was in a spreadsheet, and
now is a resultset being handed from a task to another task.



to outline my current solution:

---- table 1 = this all works -------------

Excel Source --> MultiCast (For Table 1)-->Data conversion for
table1-->:Sort for Table1--> Merge Join for table 1 (left Outer
join) as 'left' leg

Table1 Source --> Sort Table1 --> Merge Join for table 1 (left Outer join) as 'right' leg



Merge Join for table 1 --> Conditional Lplit for table1

Conditional Split for table1 (table1 source PK is null) -->Insert Into Table1 Destination

Conditional Split for table1 (table1 source PK is not null) -->Update Table1 OLE DB Command

---- table 2 = this needs to be able to convert X/NULL to BIT -------------

MultiCast (For Table 2)-->Copy Column for Table2 -->Data
Conversion for Table 2-->table3 lookup to get FK-->Sort for
Table2 merge-->Merge Join for table 2 (left outer join) as 'left' leg

Table2 Source --> Sort Table2 --> Merge Join for table 2 (left outer join) as 'right' leg



Merge Join for table 2 --> Conditional split for table 2

Conditional split for table 2(table2 source PK in null) -->insert into table 2

Conditional split for table 2(table2 source PK in not null) -->update table 2 ole db command

-----------------------------------------



Now, if I correct the spreadsheet to have 0's and 1's in the two
column, then the process above works. But I cannot (yet) force business
to do that.

If tried to use SQL Command for the excel source, but there is limited
functionality on the command - I cannot do SQL coalese, isnull or case
statements, which would allow me to resolve that data at source.

I've tried to use derived columns to alter the columns. I think that
the REPLACE (IsAvailable, VariableContainingX,VariableContaining1)
might work to change X's to 1, but that doesn't resolve the NULL issue.

I've tried to use a script component to handle the conversion - which
REALLY feels like a bad way to do this - the .Net script is wrote was:

-------------.net script code-------------

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Imports Microsoft.SqlServer.Dts



Public Class ScriptMain

Inherits UserComponent



Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

If Not (Row.EndOfRowset) Then

If
(Row.IsDotComVanEnabled_IsNull) Or (Row.IsDotComVanEnabled.Equals("X"))
Then

Row.IsDotComVanEnabled = "1"

End If

If
(Row.IsStoreCollectionEnabled_IsNull) Or
(Row.IsStoreCollectionEnabled.Contains("X")) Then

Row.IsStoreCollectionEnabled = "1"

End If

Row.NextRow()

End If



End Sub



End Class

------------------------------------------

I also tried it like this:

----------------1st draft .Net script code--------

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Imports Microsoft.SqlServer.Dts



Public Class ScriptMain

Inherits UserComponent



Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

If
(Row.IsDotComVanEnabled_IsNull) Or (Row.IsDotComVanEnabled.Equals("X"))
Then

Row.IsDotComVanEnabled = "1"

End If

If
(Row.IsStoreCollectionEnabled_IsNull) Or
(Row.IsStoreCollectionEnabled.Contains("X")) Then

Row.IsStoreCollectionEnabled = "1"

End If



End Sub



End Class





-------------------------------------------------



Those both threw the following error;



-------------error information-----------------

Script Component has encountered an exception in user code:

PROJECT NAME: ScriptComponent_a333140d269b413bb1bddef390da7e16

Object reference not set to an instance of an object.



at ScriptComponent_a333140d269b413bb1bddef390da7e16.ScriptMain.Input0_ProcessInputRow(Input0Buffer Row)

at ScriptComponent_a333140d269b413bb1bddef390da7e16.UserComponent.Input0_ProcessInput(Input0Buffer Buffer)

at
xScriptComponent_a333140d269b413bb1bddef390da7e16.UserComponent.ProcessInput(Int32
InputID, PipelineBuffer Buffer)

at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)

-----------------------------------------------



Any ideas?

View Replies !   View Related
Extract Exchange 2003 Data
I have searched everywhere for an answer and seems I am either blind or there is no simple solution. Basically I have a need to report on data stored in an Exchange 2003 data store. There is mention of a OLE DB for Exchange 2000 but nothing for Exchange 2003. For example, A company report on time spent on various categories in a staff's calendar, etc. I would like to use SQl 2005 SSIS to extract and reporting services to report. Why is this so difficult? I come from a Lotus Notes / Domino background and there are numerous articles and ways to do this? Please can some MS guru please give me some direction on where to look?

Cheers

Damien

View Replies !   View Related
Extract Data From Two Excel Files


Hi,
I have just started learning SSIS. Could someone please tell me if where can I find step by step instructions on how to simply extract data from two excel files and populate the relevant table. What I simply want to do is:


Excel File 1(With Columns FirstName, DateJoined)
+
Excel File 2 (with column Summary)
|
|
->Add these three columns to a new table called CustSummary


Any thoughts and suggestions will be really appreciated.

Thanks

View Replies !   View Related
How To Extract The Data From MSSQL05 DB To XML Files?
Dear all,
I have a table containing some information that needed to generate a XML file periodically.
Do anyone has idea how to achieve it in SSIS?
Thanks a lot!

lokman LM

View Replies !   View Related
Extract Pieces Of Data From Excel
In Integration Services I am trying to extract pieces of information from Excel. I would like to select just information from one cell but when I do that I get an error. What I'm typing in is:

SELECT *, Now() FROM [Sheet1$A1]

Here is the error:
------------------------------
Error at Data Flow Task [Excel Source [170]]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine could not find the object 'Sheet1$A1'. Make sure the object exists and that you spell its name and the path name correctly.".

Error at Data Flow Task [Excel Source [170]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC020204A (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------

The only way that I can get the contents of one cell is if I type in a range and indicate in the Connection Manager that the first row has column names. Given that, to get the contents of A2 I am having to type in:

SELECT * , Now() FROM [Sheet1$A1:A2]

This gets me what I want but by using this method I am never able to get information in Row 1. That could pose a problem in the future and I'm sure that there is a better way to do it.

So my question is, how can I get something from a single cell without having to name a range?

Two other questions I have are: 1. Is there a way to get information in one statement from cells that aren't adjacent to one another. For instance, if I wanted the contents of just A2 and C4?; 2. Is there a way that you could select a named range from Excel? That would be good because then I could have Excel control the range and then just call that.

I know this is a lot but I have an impending project where I'll need to do much of this and I have only ever imported the contents of an entire sheet and not specific cells from a worksheet.

Thanks.

View Replies !   View Related
How To Extract Data From Delimited Text!!!


First of all I am a novice here. I am working on a table with a column of URL. I want to seperate the data in the URL delimited by '/'.
Eg:
http://www.simpletech.com/upgrades/aopen/s661fxm/s661fxmintelp4/

Here I want aopen as manufacturer, s661fxm as model_number and intelp4 as submodel_number.
I solved this problem in Oracle using substring and instring. But I have no ides how to achieve this in SQL server.
Please..advice me.
Thanks in advance.



View Replies !   View Related
Design Question Regarding Comma Delimited Data
Hi,

I'm trying to figure out if it's good design practice to have several pieces of data in a one column. I explain by example. Let's say you build a movie site. Each movie can belong to several categories. A movie can be Action, Adventure, Fantasy and Drama all at once. Assume a database table with all the movies and another table with all the categories. Now how would I associate one movie with several categories? Would it be OK if I add a Category field in the movie table and then add several categories in that, delimited by commas? Sort of like below:

movie_title                  | movie_rating |        category_name--------------------------------------------------------------------------------------------------Pirates of the Carribean |      PG-13        | Action,Adventure,FantasyEvil Dead                     |      Unrated      | Horrorand so on ...I can then query the database with a LIKE query if I want to select all movies of a certain category. Personally, I don't like this approach to much, but I can't think of another way to achieve this. Well, there is one other, but I like that one even less. I could create another table that links each movie to a category, but his way each movie with several categories would get a new row. Using the table above, Pirates would get three rows in that table. One with Action, one with Adventure and one with Fantasy. Get my drift? It all seems counter-intuitive. Thoughts? 
Thanks :o)

View Replies !   View Related
Data Row Comma Separated Cell To Many Rows
Hello!

We are on SqlServer 2005.

Let me point out at the beginning that I don't have anyway to normalize this structure or get the admins to change the way the data is stored. We don't own the database where this is housed...we're just given the information via an .xls file...which we import to a SQLServer table.

I have some data that is given to me that has two columns (below is for an example):
Column A is an identifiying number, i.e. for a project
Column B is a comma separated list of account strings for the project

A sample layout of what we get via the .xls file might look like the following (Column A is to the left of the dashes, and Column B is to the right of the dashes):

AA.ProjectBuildTower ----- 2222, 3333, 4444, 5555
BB.ProjectBuildFence ----- X900, 6789, 9000, 9876

What I need to do is now haveprojects listed out in Column A with each of it's account strings in Column B like so:
AA.ProjectBuildTower ----- 2222
AA.ProjectBuildTower ----- 3333
AA.ProjectBuildTower ----- 4444
AA.ProjectBuildTower ----- 5555

BB.ProjectBuildFence ----- X900
BB.ProjectBuildFence ----- 6789
BB.ProjectBuildFence ----- 9000
BB.ProjectBuildFence ----- 9876

Any suggestions would greatly help!

Thanks!

View Replies !   View Related
Export SQL Data To Comma Delimited Csv File
Hi,

I was wondering if anyone might be able to say how I could export data captured via a view into a comma delimited csv file.

So far I have tried using BCP to access my view and export to a CSV file, but the CSV file isn't comma delimited. I tried finding examples but couldn't see what I should do to have a comma delimited file. (I'm getting a bit tired now, so I might be missing something!)

I have created a bat file containing the following code:

bcp "TestDB..GA_FSM_DCSF_Extract" out "C:GA_FSM_DCSF_Extract.csv" -fexport.fmt -e "C:error.log" -c -T -S srckvzg2j -r


Any help / pointers would be much appreciated.

Thanks,

Henrik

View Replies !   View Related
Comma In Value Within Comma Separated File
I have a file which contains comma separated columns. One of columns contains names of companies. Sometimes the names of the companies have a comma as part of the name. For those, the value is surrounded by double-quotes.

But it seems that SSIS ignores the double quotes and ONLY looks for the column separator. This causes my value to be split in half.

Traditionally, I thought parsers that deal with this type of import do not automatically take the first comma following the double-quote as the column separator but instead look for the first comma following the ending quote. (i.e. Look at how Excel performs imports...)

I cannot set the column separator of the column to double-quote comma since only those values that HAVE a comma in them are qualified.

Any ideas?

Here is sample fie content to see what I mean:

342123, Jason, 12345
21, Kim,4567
32.43, John Paul, 1245
23, "Mr. T", 98764
12, "Peter, Paul, Mary", 09643

The last entry should be imported as 12 in the first column, "Peter, Paul, Mary" in the second column and 09643 in the third but instead ends up as 12 in the first, "Peter in second column and Paul, Mary", 09643 in the last.

(Oddly enough, if I remove the first column of numbers the import works like it is supposed.)

View Replies !   View Related
SqlConnection Issues,Unable To Extract Data From Db
Hi all,
I've created a database named HyperCodexDB.mdf and I'm trying to extract some information from, I've no error, but the code after Open() method is even not executed:
Here is the Web.Config







and in the .cs file :

Hashtable names = new Hashtable();
int i = 0;
string conn_str = ConfigurationManager.ConnectionStrings["hcConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(conn_str);
SqlCommand cmd;

cmd = new SqlCommand("SELECT Nom FROM TableRecueil", con);
SqlDataReader rdr = null;

try
{
Label1.Text = "Hello"; ////////????Here changes the value of the label
con.Open();
Label1.Text = "Bye"; ////////????But here the value of Label1.Text remains "Hello"

rdr = cmd.ExecuteReader();
while (rdr.Read())
{
names.Add(i, rdr["Nom"]);
i++;
}
Label1.Text = names[0].ToString();

}
catch (SqlException ex){ }
finally
{if (rdr != null)
{rdr.Close();}
if (con != null)
{con.Close();}}

Thanks in advance
Ali

View Replies !   View Related
Extract Data From SQL Server Into .XLS Or Flat File...
Hi,

I am interested in writing a stored procedure that will compute and select data from SQL Server 2000 database and store it into a .XLS or flat file.

how can i do that ?

need help.

Thanks.

-- Parag

View Replies !   View Related
Sqlserver2005 Limitation To Extract TIMESTAMP Data
Hi,

I have created one Linked server to fetch the data from Oracle server.

I have two tables at Oracle server

1. EMP_Tbl1 (Emp_Cd VARCHAR2(10))

2. EMP_Tbl2 (EMP_ID NUMBER, Emp_Cd VARCHAR2(10))

I can connect to EMP_Tbl1 table through my linked server at SQL Server 2005.

WHILE I cann't connect to EMP_tbl2.


ERROR:
The OLE DB provider "OraOLEDB.Oracle" for linked server "Linked_Facets" supplied inconsistent metadata for a column. The column "EMPID" (compile-time ordinal 1) of object ""SYSTEM"."EMP_ASH"" was reported to have a "DBTYPE" of 5 at compile time and 130 at run time.

OR "The OLE DB provider "OraOLEDB.Oracle" for linked server "Linked_Facets" supplied invalid metadata for column "JOINING_DATE". The data type is not supported."

Reason:
EXECsp_addlinkedserver
@server='Linked_Facets'
,@srvproduct='ORACLE'
,@provider='OraOLEDB.Oracle'--'OraOLEDB.Oracle'
,@datasrc='ameri.corp.ads.valuelabs.net'

I am using 'OraOLEDB.Oracle' as the provider. This has its own limitations. How to conquer this?

View Replies !   View Related
Extract Data From ACCESS Database With Pwd Via ODBC
Hi,

My task is simple, I want to use the execute sql task editor to grab a value from a database in Access and put it in a variable. The connection is via ODBC and the access database is protected by a password.

I've done all the preliminary stuff such as running profiler to make sure that the package is getting the call to the database, setting up the ResultSet to be "single row" in the general tab, mapped the Result Set correctly, but nothing works. I get the same error every time.

This is my sql command:

select count(FingerPrintID) as FingerPrint

from Employee

Result Set is set up like this:

Result Name: FingerPrint ; Variable Name: User:: varDataset

Here is the error I get:

Error: 0xC002F309 at Execute SQL Task, Execute SQL Task: An error occurred while assigning a value to variable "varDataset": "Value does not fall within the expected range.".

My variable is set up as a Int16.

Please help!!!!!

If you could provide step by step example's that would really make my day.



Thanks,

Lawrence


View Replies !   View Related
Unable To Extract Data From Excel Columns
We have some Excel worksheets that have double header rows, so we do not specifically tell the connection manager to treat the first row as header, and instead use customised queries to gather the data out

SELECT F1 As Station, F2 As MonthCommencing, F3 As BuyType,
F4 As CAI, F5 As C30I,
F6 As CAGRP, F7 As C30GRP,
F15 As PAI, F16 As P30I,
F17 As PAGRP, F18 As P30GRP
FROM [Monthly Data$]
WHERE F1 IS NOT NULL
AND F1 <> 'Station' -- This is the actual column header value in the second row.

The thing is, if the very first data row for Column 4 (F4) is NULL, any subsequent data in other below records that may have actual (decimal) data will also be seen as NULL. Only if the first data row has F4 filled with proper value will the below rows reveal their content.

Does anybody know how to get Excel to read the data properly?

View Replies !   View Related
Is There A As400/db2 Native Provider To Extract Data?
Is there a as400/db2 native provider to extract data?

View Replies !   View Related
HOW To Extract Data From A SharePoint List Using SSIS
Has anyone figured out how to extract the data from a SharePoint List into a SQL Table or ssis variable
using SSIS?

View Replies !   View Related
Extract Data From Multiple Oracle Database
I have to extract data from5different oracle databasee with same schema.This will be scheduled job.Can someone guide me.

View Replies !   View Related
SSIS -Data Extract To Flat File
I want to extract data from a table (based on a query) to a flat file.

So I have an OLE DB Source (data access mode SQL command) and then a flat file destination. The extract works finem except it extracts all table rows as one line in the file - whereas i want a separate line per DB record - what am I missing?

Thanks for any help!

View Replies !   View Related
Normalizing Flat Data / Extract One Of Each Type
I'm new to SSIS and have run into a problem I'm hoping someone can help me with.

Basically, I have a flat file that looks something like:

ID,Type,Description,Results
1,Test1,This is a test,5
2,Test1,This is also a 1 test,7
3,Test1,This is also a 1 test,13
4,Test2,This is a second test,14
5,Test2,This is also a second test,18


I'm trying to normalize the data by extracting out individual rows that have the same "Type" column value. So what I want is to extract each unique type and description into a separate table. This would give me two new rows, one for a type of Test1, and one for a type of Test2, with the descriptions. Does this make sense? Then I could relate the individual results to these test types. In my scenario, I don't care which description is used; I just want to take the first description that shows up with the associated "Type."

Does anyone have any idea of how I could go about doing this? I could pull out all unique "Types" from the rows with the Aggregate transformation, but I'm trying to figure out how to get the description that goes along with it.

Thanks,

Brian

View Replies !   View Related
Extract Data From Multiple Oracle Database
I have to extract data from5different oracle databases with same schema.This will be scheduled job.Can someone guide me.

View Replies !   View Related
EXtract Data From 10 Identical Oracle Database Into One


Please guide me urgently how to extract data in SSIS from 10 identical oracle database into 1 sql server database.
There is a table which list all the 10 databases.

View Replies !   View Related
How Extract The Data Of TFINF When Doing Text Mining? Thanks
How Extract the data of TFINF when doing text mining? Thanks

View Replies !   View Related
Can We Extract Data From A XL File To Generate A Sql Report


Hi All,


can we extract data from a XL file to generate a sql report?

Thanks



View Replies !   View Related
Extract Data From Middle Of String In SQL Server
I am trying to write a query in sql query analyzer that will extract a date that appears after the first comma in the string. An example of the data is below:

DAVE,12/31/03,17:18,PERIODENDP
AS,01/16/06,16:51,CUSTOMERS_VW
EM,11/09/07,15:08,ORDER_ENTRY_

I want to select the 8 characters after the first comma in the field, and then convert it to a date format.

I am a novice, so any help with the correct function and syntax would be greatly appreciated.

thanks,
Dave

View Replies !   View Related
Extract Data From Excel 2007 On Vista
Hello all,



I am in the process up testing an upgrade from XP to Vista, and the only thing that I am running into is that my linked servers for Excel that I defined no longer work.



The spreadsheet that I am trying toopen is in the 97-2003 format (not the 2007 format), yet I keep getting the same error message "Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TEST1"



Has anyone successfully created a linked server to an Excel spreadsheet on Vista, and if so, please can you provide some insight into what I am doing wrong.



I tried creating a linked server on an XP box running MS Office 2007, and it worked without any issues.



All comments welcome.



thanks



Steve

View Replies !   View Related
Load Data From Comma Delimited Text File
Hello, i need to load some data from a long comma delimited text file, How can a i do that, using t-sql?, thanks for your help!!!!!

View Replies !   View Related
Transforming Comma-delimited List Row Data To Column
Hi,



I have 2 Tables



Table 1, Row 1





1. Id = 1

2. GraphPoints = 023, 045, 078 (text - data type)



I need to move datato Table 2.



Table 2 should have



1st row



1. Id = 1

2. GraphPoint = 023 (float data type)



2nd row



1. Id = 1

2. GraphPoint = 045 (float data type)



and so on



How do I do that?



Thanks.

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved