COLLATE Error In DTS File Import

Mar 19, 2001

I am getting an error inserting a simple text file into a SQL2000 database table.
The text file is one column, comma delimited, and the DTS package to insert it into a table fails citing an error executing a 'COLLATE' statement.
Thanks for the help!

View 1 Replies


ADVERTISEMENT

Error Regarding File Import Through Import Wizard

Jan 12, 2006

Hi all,

when trying to ímport files to our database server from a client, I keep getting an error:

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source_txt" (1).
 (SQL Server Import and Export Wizard)
 
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (175).
 (SQL Server Import and Export Wizard)

... doing the same import when logged on the server, hasn't been giving me any errors, how come. I can from my client without trouble import tables from other DB servers but when ever it is files it won't do it.

 

I tried as mentioned in other threads rerun setup to re-install SSIS, but as it was already installed it wouldn't re-install. My next move would be to make a clean install, but not sure it would help, as I think this is a buck.

best regards

 

Musa Rusid

View 1 Replies View Related

Syntax Error Near 'COLLATE'

May 19, 2004

I am attempting an import of an SQL DB from a local MSDE SQL Server to an SQLServer 2000. I used the Web Data Administrator to create an export file, and then I wanted to perform an import to the actual server. I get the error "Syntax error near 'COLLATE'". I don't know much about syntax when it comes to this. Here is a snippet from there. I am new to this, so I hope someone out there can help me out.
CREATE DATABASE [NewDB] ON (NAME = N'NewDB', FILENAME = N'CORRECTFILEPATH' , SIZE = 3, FILEGROWTH = 10%) LOG ON (NAME = N'NewDB_log', FILENAME = N'CORRECTFILEPATH' , SIZE = 1, FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
All the "N" don't look like they belong, but they have been added throughout the entire SQL document.

View 9 Replies View Related

Alter Database/collate Error

Dec 6, 2007

We're upgrading to SQL Server 2005, and we've restored databases from SQL Server 2000 to the development server (SQL Server 2005). Part of what we need to do is alter the database collation to SQL_Latin1_General_CP1_CI_AS; our SQL Server 2000 server is case-sensitive.

My initial attempts to alter the database;

alter database RGDWDEV collate SQL_Latin1_General_CP1_CI_AS

failed because of the presence of computed columns and user functions. So, I wrote scripts to save the definitions of the computed columns and functions, and wrote scripts to drop them. Now that they are gone, I expected to be able to successfully execute the above 'alter database' statement, but I am now getting this error;

Msg 1505, Level 16, State 1, Line 1
CREATE UNIQUE INDEX terminated because a duplicate key was found for object name 'sys.sysschobjs' and index name 'nc1'. The duplicate key value is (0, 1, DISB_ADJ).
Msg 5072, Level 16, State 1, Line 1
ALTER DATABASE failed. The default collation of database 'RGDWDEV' cannot be set to SQL_Latin1_General_CP1_CI_AS.

I do not know how to fix this.

Can anyone help me?

thank you, beth

View 9 Replies View Related

Error 0xc0202055...while Import Data From Csv File

Jun 7, 2007

I receiveed the error:

Error 0xc0202055: Data Flow Task: The column delimiter for column "Column x" was not found.


I would like to have the import continue., even the error occur. I have the error output to ignore, but doesn't seem to be working. Any suggestion on what to do next, or how to skip the row that create the problem.





thanks

View 1 Replies View Related

Error 0xC0047012 Trying To Import Flat File In SSIS

Apr 6, 2006



I'm trying to do a simple flat file import of a .csv file. The task keeps failing on me and I get the following error

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039

I looked up the error codes and the only information I can find is that a thread is failing. What would cause this and how can I fix it? I can open the same file in Excel without any problems. I'd really appreciate any insight that anyone has to offer.

View 4 Replies View Related

Flat File Random Import Error With Ole Db Destination Object

Mar 12, 2008

Hello,
I get errors during import process from flat files to sql table (random missing rows) when I have more files to load through a "for each loop" cycle.
If one of the files is not present (because not yet generated by an other process) many of the rows present in the next file are skipped during import operation. This happens even if the "maximumErrorCount" is set to 10000.
The error reported is Warning: 0x8020200F at Import File Bolle , Source_Bolle [1]: There is a partial row at the end of the file
Sql 2005 has Service Pack 2 installed.
Can some one help me?
Thanks and regards

View 5 Replies View Related

SQL 2012 :: Flat File Import Tasks Fail With Error 0xc02020a1

Aug 25, 2015

The import from Flat File Source fails: Error 0xc02020a1: Data Flow Task 1: Data conversion failed.

The data conversion for column "ArticleName" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)

I have changed the size of the column "ArticleName" (varchar) to max but the error comes up again.

The data i want to import came with multiple flat files. They all could import properly but this one is a problem.

View 1 Replies View Related

Error With Text Qualifier In Qualified Field During Flat File Import

Nov 8, 2007



We have a flat file import proces which imports data from a series of unicode flat files.

The files have text qualifiers and are being imported to a table with the following format:
CREATE TABLE [dsa].[OBS](
[Kundenummer] [nvarchar](10) NULL,
[Navn] [nvarchar](60) NULL,
[Adresse] [nvarchar](50) NULL,
[PostnrBynavn] [nvarchar](50) NULL,
[Kursusdato] [datetime] NULL,
[Varighed] [decimal](18, 2) NULL,
[Kursustype] [nvarchar](100) NULL,
[Risikokoder] [nvarchar](50) NULL
) ON [PRIMARY]

In one of our files we have two rows that looks like this:
"19298529";"THIS IS ROW 1";"ADDRESS 9 -13";"4200 SLAGELSE";"02-05-2006";8.00;"Kombikursus Førstehjælp - Brand 8 lek.";"37"
"19448242";"THIS IS ROW 2";"ADDRESS 50";"4140 BORUP";"04-05-2006";4.00;""Fra vil selv - til kan selv". Om børn 1½ - 3 Ã¥r";"22"


Both rows are OK according to the format, but the second row actually contains the text qualifier in one of the qualified fields (""Fra vil selv - til kan selv". Om børn 1½ - 3 Ã¥r"). It's the title of a course with a comment.
The proces fails on this file, and wont even redirect the row, as it does on other erroneous rows in other files we import.

We believe this is a valid text, but apparently SSIS doesn't
Is this a bug or is this record not allowed?
Is there a work around, and why wont SSIS redirect the row?

We believe the reason is that the field before is not text quaified (which is of course specified in the connection manager).

Thanks in advance,

Lasse

View 4 Replies View Related

Csv File Import: Bulk Insert Data Conversion Error (type Mismatch)

Sep 27, 2004

Hi,

Iam trying to import data from a csv file into my table in SQL Server 2000. My table is called as temp_table and consists of 3 fields.

column datatype
-------- -----------
program nvarchar(20)
description nvarchar(50)
pId int

pId has been set to primary key with auto_increment.

My csv file has 2 columns of data and it looks like follows:

program, description
"prog1", "this is program1"
"prog2", "this is program2"
"prog3", "this is program3"


Now i use BULK INSERT like this

"BULK INSERT ord_programs FROM 'C:datafile.csv' WITH (FIELDTERMINATOR=',', ROWTERMINATOR='', FIRSTROW=2)"

to import data into my table in SQL server and it gives me this error

"Bulk insert data conversion error (type mismatch) for row 2, column 3 (pId)"

I guess i have to use fileformat or something since i dont have anything for pId field in the csv file to make it work...

Please help me out guys and please post a snippet of code if you have.

Thank You.

View 2 Replies View Related

Memo Data Type Import Error While Importing Data From Access File Into SQl Server 2005

Sep 10, 2007

I have one column in SQL Server 2005 of data type VARCHAR(4000).

I have imported sql Server 2005 database data into one mdb file.After importing a data into the mdb file, above column
data type converted into the memo type in the Access database.

now when I am trying to import a data from this MS Access File(db1.mdb) into the another SQL Server 2005 database, got the error of Unicode Converting a memo data type conversion in Export/Import data wizard.

Could you please let me know what is the reason?

I know that memo data type does not supported into the SQl Server 2005.

I am with SQL Server 2005 Standard Edition with SP2.

Please help me to understans this issue correctly?

View 4 Replies View Related

Error Trying To Import MS Access 2003 Database Via SQL Server Import And Export Wizard - Too Many Sessions Already Active

Nov 29, 2006

I am trying to simplify a query given to me by one of my collegues written using the query designer of Access. Looking at the query there seem to be some syntax differences, so to see if this was the case I thought I would import the database to my SQL Server Developer edition.

I tried to start the wizard from within SQL Server Management Studio Express as shown in one of the articles on MSDN which did not work, but the manual method also suggested did work.

Trouble is that it gets most of the way through the import until it spews forth the following error messages:

- Prepare for Execute (Error)
Messages
Error 0xc0202009: {332B4EB1-AF51-4FFF-A3C9-3AEE594FCB11}: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Could not start session. Too many sessions already active.".
(SQL Server Import and Export Wizard)

Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.
(SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task: component "Source 33 - ATable" (2065) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard).

There does not seem to be any method of specifying a number of sessions, so I don't see how to get round the problem.

Does anyone know how I can get the import to work?

View 2 Replies View Related

Collate

Jun 4, 2002

Can you use "COLLATE" (see below) on SQL Server 7? I get "incorrect syntax" error?


CREATE TABLE [dbo].[CellFormat] (
[Category] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[BackColor] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FontColor] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BackColorDesc] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FontColorDesc] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

Thanks,

strat

View 1 Replies View Related

Collate In SQL 8.0

Jul 17, 2002

Have an old DB (6.5) Upgrade to (8.0). And when i make a script from the SQL.8 to the backup server i gett Collate Errors. So i wonder if there are someway to script the Table without the Collate´s or if i can make som settings on the Backup server so it will accept Collate in the script..

Best Regards Johan

View 2 Replies View Related

COLLATE Problem

Feb 8, 2008

Hi!

I have an application that access an SQL Server database with collate Turkish_CI_AS.

The application work fine (I have special attention with the 'i'/'I' problem).

We sended our application to some partners, that have the collate of their server as Turkish_CI_AI.

One of the database are alread with this collate, and one is create during installation, with the Turkish_CI_AS collate.

And they get some wird problems, like the message "Item cannot be found in collection corresponding to the requested name or ordinal".

Can someone bring me some "light" please? :)
I'm using SQL Server 2000, some stored procedures and an Delphi 7.0 application.

Thanks in advance and sorry for be so newbe ;)!

View 6 Replies View Related

What's COLLATE Latin1_General_BIN?

Mar 6, 2008

I am new to Stored Procedure, so I want to find out what is COLLATE Latin1_General_BIN means?

For example:

Declare @Var_Tbl Table
(CUSTID INT NOT NULL,
FIRSTNAME VARCHAR(20) COLLATE Latin1_General_BIN NOT NULL,
CUSTOMER VARCHAR(9) COLLATE Latin1_General_BIN NOT NULL
)

Any helps would appreciated.

NLD

View 2 Replies View Related

How To Change The Collate?

Mar 3, 2008



I have created SQL Compact .sdf file and i want to change the collate for it now to Arabic?

how can i do that?

View 1 Replies View Related

Need Idea About COLLATE

Sep 12, 2007

I need help regarding what is a collate and where to use.If any examples with INNER JOIN it could be more helpful....

View 13 Replies View Related

Stored Procedure And A DB With Collate That Is CI...

Oct 12, 2006

i have a sp that when i add to a CS database it doesnt give me an error but when i add to a CI database it errors out.
what can i do to it to make it not error on the CI situtation?

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


-- Accounts Payable
ALTER PROCEDURE [dbo].[isp_ap_calc_apt_totals]
@p_comp char(2),
@p_vend char(6),
@p_asofdate char(8)
as

if (@p_asofdate <= '00000000')
begin
set @p_asofdate = '99999999'
end

delete from XAPAPTTOT
where xapt_comp = @p_comp and xapt_vend = @p_vend and xapt_asof_date = @p_asofdate

insert into XAPAPTTOT
select apph_comp, apph_vend, apph_type, apph_id, @p_asofdate,
sum(apph_paymnts),
sum(apph_discts),
sum(apph_adjts),
count(apph_paymnts),
sum(apph_paymnts)+ sum(apph_discts) + sum(apph_adjts) +
(select apt_gross from APTRANF
where apt_comp = @p_comp and apt_vend = @p_vend
and apt_type = apph_type and apt_id = apph_id),
0,
max(str(yy,4) + replace(str(mm,2),' ','0') + replace(str(dd,2),' ','0'))
from APPHISTF
where apph_comp = @p_comp and apph_vend = @p_vend
and str(yy,4) + replace(str(mm,2),' ','0') + replace(str(dd,2),' ','0') <= @p_asofdate
group by apph_comp, apph_vend, apph_type, apph_id

update XAPAPTTOT
set xapt_last_payck =
(select max(apph_payck) from APPHISTF
where apph_comp = xapt_comp and apph_vend = xapt_vend and apph_type = xapt_type
and apph_id = xapt_id
and str(yy,4) + replace(str(mm,2),' ','0') + replace(str(dd,2),' ','0') = xapt_last_paydt )
where xapt_comp = @p_comp and xapt_vend = @p_vend and xapt_asof_date = @p_asofdate

View 3 Replies View Related

Collate SQL_Latin1_General_CP850_BIN To SQL_Latin1_General_CP1_CI_AS

Jul 23, 2005

Hi, I have a SQL Server for a SAP database with the collationSQL_Latin1_General_CP850_BIN. When I connect to that server (or, inthis example, to another server with the SQL_Latin1_General_CP850_BINcollation) and execute a select, the accents seem weird:select t.TEXTfrom [GC-SAP02].P01.p01.AGR_TEXTS twhere t.MANDT = '300'and t.SPRAS = 'E'and t.AGR_NAME = 'ZCD_GEST_DEUDA_PATENTE_SD'TEXT-----------------------------------Gesti¾n de deudas patentes en SD UP(1 row(s) affected)But if I connect to a "normal" SQL Server with aSQL_Latin1_General_CP1_CI_AS collation, and execute the same selectthru a linked server:TEXT-----------------------------------Gestión de deudas patentes en SD UP(1 row(s) affected)I need to perform the select connected to theSQL_Latin1_General_CP850_BIN and get the results as I were connected tothe SQL_Latin1_General_CP1_CI_AS server. I tried with cast and collate,but I can't get it to work:select t.TEXT collate SQL_Latin1_General_CP1_CI_ASfrom [GC-SAP02].P01.p01.AGR_TEXTS twhere t.MANDT = '300'and t.SPRAS = 'E'and t.AGR_NAME = 'ZCD_GEST_DEUDA_PATENTE_SD'Any ideas??? Thanks in advance for your help !!!Manuel Daponte

View 1 Replies View Related

How To Get All Collate In SQL Server That Installed In My System ???

Jul 4, 2007

I created DB Generator and want to enable user choose collate which desired.
So I would like to retreive all collate in SQL Server to show for user can see all available collate.
 
 
Please give me some idea......
 

View 1 Replies View Related

Why Do We Need To Collate One Column While Creating Table?

Apr 21, 2008

Hi,Good morning to All.
I have some doubt.I cannot do anything without knowing the reason why we are doing that particular thing.
Any way, my doubt is:
While creating table, in some places I see COLLATE clause.
For example, recently I have seen this.
CREATE TABLE dbo.OrderDetails(       OrderDetailID INT IDENTITY(1,1) NOT NULL,       ItemNumber VARCHAR(20) COLLATE SQL_Latin1_General_CP1_CI_As NULL,       Qty INT NULL)ON [PRIMARY]
In the above table, why the Collate clause for ItemNumber column? What is the advantage with that clause?I have seen sql server help for this. I have found 1011 results for the query SELECT * FROM fn_helpcollations().Then I searched for SQL_Latin related collations using: SELECT * FROM fn_helpcollations() where name like 'SQL_Latin%'I have found 31 results.How can I know which clause i have to use for which type of query?
Can anybody please tell answers for all these doubts?
Thanks in advance.
Regards,Ashok kumar.

View 1 Replies View Related

What Is The Query To Kown The Collate Of The Database ?

Sep 14, 2006

What is the SQL query or stored procedure to kown the collate of the database ?
Thanks

View 1 Replies View Related

Can't Change The Currente Collate Of My Database

Nov 5, 2007

Hi, i'm having a problem with my database. When i created it i specifie the collate sql_latin1_general_cp1_ci_as but now that i'm working on my domain server, the server only acepts databases with the collate latin1_general_ci_as so i tried to change my current (on my localhost) collate but i'm always getting this error:


Msg 5030, Level 16, State 2, Line 2

The database could not be exclusively locked to perform the operation.

Msg 5072, Level 16, State 1, Line 2

ALTER DATABASE failed. The default collation of database 'databasexpto' cannot be set to Latin1_General_CI_AS.

How can i do it?

View 5 Replies View Related

Search Transformation - Collate Issues

Sep 6, 2007



Hi,
I'm trying to do a search over a table, the problem is that the default collate applied by this transofrmation is case sensitive... i need a non case sensitive collate. If i edit the SQL Statement to set another Case sensitive collate manually inside the statement, the problem is that if a field (wich is involved in search transformation ) has a null value, the transformation doesnt find any record (it doesnt happens if a dont introduce manually the collate in the statement, null values dont rise any error, and the transofrmation works fine).

Sorry for my english lol.

View 11 Replies View Related

Transact SQL :: CASE WHEN - Adding Collate Into It

Aug 20, 2015

Tried a few ways and I can ge this to work at the end in then WHEN part. Just struggling to put this together to be accepted as a CASE WHEN statement, probably missing the obvious.

Case when Postcode like '%[abcdefghijklmnopqrstuvwxyz%]' then 'Lowercase Postcode' else 'Postcode OK' end as [DQPostcode]

collate Latin1_General_CS_AS

Simple terms looking for all instances of Lowercase characters in the Postcode field

View 5 Replies View Related

DTS File Import When File Is Locked

Jan 29, 2003

Guys.

This has been an issue for me. It happens once in a while.

I am importing a File from a shared folder thru DTS package. Once in a while the DTS package fails due to the following error.

"Error Opening Data File: Process cannot access the file because it is being used by another process"

Is there anyway I can specify that the file is going to be opened in read only, so that the DTS will not fail?

Any other solution/suggestion?

-MAK

View 1 Replies View Related

Alter Database Model COLLATE SQL_Latin1_General_CP1_CI_AS

Jun 8, 2005

Hi folks,

I do not have a backup of the model database and have had to rebuild SQL Server 2000 once already. All my databases except model and tempdb have the collation SQL_Latin1_General_CP1_CI_AS those two have Latin1_General_CI_AS.

During SQL rebuild I've restored over master and msdb and they work fine. Only came across problem with stored procedure and I'm lost as to how to alter model without a backup of it.

Any easy way to change model collation?
The command listed in subject fails as it is a system table.

Is it as simple as going into single user mode and trying that command again?

Help please this is day 3 of my little nightmare.

View 3 Replies View Related

Change Collations In Many Tables Defined Using COLLATE

Jun 9, 2004

I have (inherited a) a db with lots of tables looking like the definition at the end of the message.

I need to change all these tables, so that all the textual fields follow the default DB collation.

Any help appreciated!
THANX...

CREATE TABLE [Club] (
[id] [int] NOT NULL ,
[name] [varchar] (100) COLLATE Greek_CI_AS NOT NULL ,
[address] [varchar] (255) COLLATE Greek_CI_AS NULL ,
[zoomAreaId] [int] NULL ,
[phone] [varchar] (255) COLLATE Greek_CI_AS NULL ,
[contact] [varchar] (50) COLLATE Greek_CI_AS NULL ,
[clubCategoryId] [int] NULL ,
[unused] [varchar] (2) COLLATE Greek_CI_AS NULL ,
[monday] [int] NULL ,
[tuesday] [int] NULL ,
[wednesday] [int] NULL ,
[thursday] [int] NULL ,
[friday] [int] NULL ,
[saturday] [int] NULL ,
[sunday] [int] NULL ,
[comments] [text] COLLATE Greek_CI_AS NULL ,
[URL] [varchar] (255) COLLATE Greek_CI_AS NULL ,
[image] [varchar] (50) COLLATE Greek_CI_AS NULL ,
[priceCategoryId] [int] NULL ,
[ratingId] [int] NULL ,
[entryDate] [datetime] NULL ,
[WAPText] [varchar] (255) COLLATE Greek_CI_AS NULL ,
[SMSText] [varchar] (160) COLLATE Greek_CI_AS NULL ,
[SMSAddress] [varchar] (50) COLLATE Greek_CI_AS NULL ,
[active] [bit] NOT NULL ,
[content_id] [bigint] NULL ,
[disp_as_propos] [bit] NULL ,
[date2disp] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

View 2 Replies View Related

Collate Problem In Windows 2003 Server

Mar 14, 2008



I build a asp.net web site on my laptop and accessting data with my vb.net code from SQL server 2005 which is installed on windows 2003 R2 server. All works fine.



but when I hosted this website on the IIS server which is physically the same Windows 2003 Server R2 with SQL Server 2005, the sql queries are not executing well and not getting the result. After some R&D What I found is that the Column Names CASE in the SQL Database and in my SQL Query is not matching. I find that SQL server 2005 collate is allready set to SQL_Latin1_General_CP1_CI_AS. I have lots of pages with lots of sql queries and near about 500 SQL Databases, and its quiet tuff to match all columns CASING.



1. How can I change the collate of windows 2003 server R2?

or

2. How can I run my wesite on this Server properly?

3. What is actually going on (website working on Windows XP but not working well on Windows 2003 server).





View 3 Replies View Related

Expression Type Numeric Is Invalid For COLLATE Clause

Oct 16, 2013

I have a query however i am getting the following error message “Msg 447, Level 16, State 0, Line 1 Expression type numeric is invalid for COLLATE clause.“

This is my query

SELECT
sjo.ID,
sjo.MID,
sjo.Trade_Association_Name,
da1.Account_Name As Trade_Association_Name,
substring(do.[MM-CHN-AGENT],2,12) as Mass_Agent_Chain_No,

[Code] ....

And Dan.Stg_Jitter_Opp2 table consists of the following

ColumnNameData Type
Idvarchar(50)
Mid numeric(18, 0)
RecordTypeIDvarchar(50)
Trade_Association_Name varchar(50)

And [FDMS].[SalesForce].[DailyAccounts]table consists of the following

ColumnNameData Type
Idint
Account_Idvarchar(18)
account_Name varchar(150)
mid_externalvarchar(15)
Mid_internalvarchar(15)

View 5 Replies View Related

Question About User Defined Data Type And 'COLLATE SQL_Latin1_General_CP1_CI_AS'

Apr 8, 2004

What is 'COLLATE SQL_Latin1_General_CP1_CI_AS'? I am new to
SQLServer, and couldn't find much information on the Web. Also,
I am trying to understand user defined data types. For example,

In the following example, what is '[Price_DT]' data type? and how would
it be referenced at the time of 'INSERT'.

CREATE TABLE [dbo].[Dist_Orders_Master_Index] (
[SubTotal] [Price_DT] NOT NULL ,
[Tax] [Price_DT] NOT NULL
) ON [PRIMARY]

View 1 Replies View Related

How To Import XML File Into SQL.

Dec 28, 2005

I want to import XML file as the '@doc' value when I execute 'sp_xml_preparedocument', many thanks!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved