I believe that the trigger executes under the same credentials as the event which fired it.

So the users doing the inserts in DB1 also need rights in DB2.

Please post the text of the error message.

ronan.healy (8/5/2014)

---

ya use them to no difference. its grand the client will just have to use tab delimited text files going forward if they are going to have bad data...

When would you have a non-multiline CSV? Wouldn't that just be column headings without data?

ronan.healy (8/5/2014)

---

iv tried them all they don't seem to work. I have colons and semi colons in some fields so cant use that. when I try tab or vertical get...

ronan.healy (8/5/2014)

---

its not a single column there is 20 columns in the file. I can see why its causing the error. on the column delimiter its set to comma(,)

if I...

If it's a single column, how are you doing...

ronan.healy (8/5/2014)

---

hi

im using the following code to remove a comma

REPLACE([Counter Party Ref],", "," ")

the value in the column comes in like this

EDQE40000222004,0S0

any reason why my replace wont work or...

mathews.subbu (8/5/2014)

---

Hi All,

I have developed one SSIS package to import the CSV file values into DB table.

Everything Works fine.:w00t:

But i need some other workflows to CHECK the CSV file row...

Koen Verbeeck (8/5/2014)

---

And you should finish your statements with the...

Unless your database is case-sensitive, you don't need the UPPERs.

Also you should always qualify your tables with their schema.

So I've rewritten your query a little to account for the above.

with...

PIVOT should get you what you need. Have a look at this example and see whether it helps you.

I have an 'XML-hacker' solution:

declare @add1 xml

set @add1 = (SELECT a.* from @address a

where a.AddressID = 9

FOR XML path('Addresses'))

if @add1 is null

begin

set @add1 = cast('<Addresses>

<AddressID />

<AddressType />

<Address1 />

<Address2 />

<City...

Don't think this works if there is no underlying row selected.

ronan.healy (7/30/2014)

---

yes its just going from 1 column in flat file to 1 column in a table just with the new fix up data.

so say its security name in the...