Agree with previous comment. Try changing INNER JOIN to LEFT JOIN and see whether that helps you.

This behaviour (selecting from temp tables) changed in SSIS 2012. Rather than declaring dummy metadata in your proc, you should use the WITH RESULT SETS option when you run the...

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...