Thanks Koen

Got it fixed...

the reason for this issue;

Folder permissions are not enough. The files created (*.cer and *.pvk) will be ACL-ed by the creator instance to prevent any other account...

Got the fix

Thanks Nils; The scripts are very helpful.

WangcChiKaBastar (12/15/2011)

---

I found the table its sys.certificates.

When I send a message to the target queue, messages appears on sys,transmission_queue table with error message 'DNS lookup failed with error: '11001(No such...

Nils Gustav Stråbø (11/22/2011)

---

Unless there is a requirement to to use Windows authentication I would rather recommend certificate authentication between the servers.

I wrote a tutorial with examples (for personal use)...

Post the Table DDL and sample data for "DSCOString" and "DSDemand" table DDL

Thanks that helped alot.

SQLState = S1000, NativeError = 0

Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in

BCP data-file

0 rows copied.

I got this Error.

I even added the "format file".

I have...

GilaMonster (7/26/2011)

---

anand_vanam (7/26/2011)

---

I have an identity column on all the tables so no issue if the object is a Table. I am getting count by using this query SELECT IDENT_CURRENT...

Koen Verbeeck (6/26/2011)

---

The problem is that the events from the task propagate from the task itself to the package.

This has the consequence that the event handlers are fired more than...

Thanks for your suggestions.

GSquared (5/16/2011)

---

You theoretically could that in the table and procedure.

Add a "flagged for update/replacement" type column. If the query finds a row exists with the requested values, it flags...

latingntlman (4/11/2011)

---

I created the For Each Loop w/Enumerator, but in order for it to look in the directory and grab every CSV file and dump it into a SQL table,...

Use PIVOT transformation