Here is the query:

SELECT [USERLOGIN]

,[USERFIRSTNAME]

,[USERLASTNAME]

,[ACTIVETODATE]

,[ACTIVATED]

,[DEACTIVATED]

,[USERID] - Unique ID

FROM

The table was provided by product that we use in client location. Order can be anything, but need to cover all records from table in 100 batches.

Thanks,

I get this when I execute a SQL Job.

Thanks,

Mahesh Mamidi

Yes, varchar columns are fine. But each element of the xml should go into separate column. But how do I extract the XML data elements into a table?

--Mahesh

Can someone help me in this? It's little urgent.....

--Mahesh

using XML we can store full xml in one column. But I am looking at storing XML data elements into table columns. For instance I have below xml

-...

Can someone help me on this? I am posting XML here

(?xml version="1.0" encoding="UTF-8" ?>

(?test-Property-Set EscapeNames="false"?>

- (testMessage xmlns="http://schemas.microsoft.it.relationshipmanagement/2007/test/testaccountmessage" TimeZone="W. Europe Standard Time" SegmentationNewId="1+7CP4+0" IsPrimaryChange="" UserId="1-PMIZNX" SubsidiaryNewId="1-8471-22"...

Can someone help me on this? I am posting my XML file here

-

-

-

...

Can anyone help me in this?

Mahesh

File doesn't have any footer.

Will you be able to give me the right query for this problem?

To create file format

Exec master..xp_cmdShell 'bcp US..TEST1 format -c -f  "D:\nnf.txt"  -S  SERVERNAME  -U SA...

1. If you look at my Bulk Insert statement I am ignoring header record by giving "FIRSTROW = 2"

2. When I generate file format using BCP command it is generating...

Okay.

Table Format

8.0

46

1       SQLNCHAR      2       510     "|"                       1     Token                     SQL_Latin1_General_CP1_CI_AS

2       SQLNCHAR      2       510     "|"                       2     Symbol                    SQL_Latin1_General_CP1_CI_AS

3       SQLNCHAR      2       510     "|"                       3     Series                    SQL_Latin1_General_CP1_CI_AS

4       SQLNCHAR      2       510     "|"                       4     InstrumentType            SQL_Latin1_General_CP1_CI_AS

5      ...

How to upload my sample file to this email thread?  I want to give my sample text file and also table format file, so that any of you can help...

Anybody can help me in this?

Test1 table contains around 40 fields with VARCHAR(255) and also I tried with proper data types. still same error.

Can't provide the data

using SQL...