m.mukesh.mca2009 (8/7/2014)

---

Hi

I have a table like below.

ID eIDinCountoutCount

417720NULL NULL

1000010331 7

1000010346 ...

Have a read here and see whether it makes sense, then come back with any follow-up questions.

As you're using project deployment, you must be on SSIS 2012.

So your config info should be coming straight out of an SSISDB environment - no XML required.

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.