I am sure that the remote login password must be the access database password, it is used the map the local sql login with that of the access database user...

If you read the OP's original post he has mentioned that he wanted the entire text that follows the last space.

Though your...

If you read the OP's original post he has mentioned that he wanted the entire text that follows the last space.

Though your...

Thanks Jeff:-), it just that...

GSquared (5/29/2009)

---

In the OP's example XML, the elements were uppercase on my screen. That might be something with the scripts on the page, but it's how they show on...

Firstly, Shouldn't the system database be "System Database=system.mdb" instead of "System Database=system.mdw"?

Secondly, you doesn't seem to set the remote login and password for the server login. remote login should...

Once you have the for each loop enumerator working, add 1 script task and read the above link posted by Jack that explains how to read a text file. ...

X-Query is case sensitive, so all the methods and the data elements used in the xml must match with that used in the methods. For e.g.

The method "Value" should...

The 3rd biggest thing is that you can write recursive queries using CTE.

See if this helps.

; WITH TestCTE

AS

(

SELECT'FFX Buy USD/Sell AUD, Broker 703 MATURITY 11/05/09 SOLD AUD 18,669,911.96' AS SomeText

UNION ALL

SELECT'FFX Buy $/Sell $, Broker 471 MATURITY 11/05/09 SOLD $878.96' AS SomeText

UNION...

sateesh.kamalakar (5/29/2009)

---

HI

When i am applying the sbinding it is showing the error as like this .

If u can help it will be great . urgent...

I am glad that you worked it out very well, once you had all in things in place, post back the working code to see if everything is okay. ...

Taken straight from Books Online:

When updateusage is specified, the SQL Server 2005 Database Engine scans the data pages in the database and makes any required corrections to the sys.allocation_units and...

faiz_ku (5/26/2009)

---

Can I insert data from a table which is on other database on the same server through query, Like I want to insert data from master.employee table into northwind.employee...

I am just running out of ideas:w00t:, that's what you don't get when working late:-D. Well, one thing that I am sure of is that its definitely a file access/security...