The best way to get help with this is to include the code in question along with the definitions of the tables and some test data. Without those we're just...

Could we see the definitions of the tables involved?

Whenever we interfere with replication here we then use Redgate SQL Data Compare to check the data. It may be worth investing in a copy, or I believe it is...

kapil_kk (9/16/2013)

---

HI all,

here is the scenario that I faced:

1. I had a table which some data.

2. I need to add a column with not null, While I was doing in...

We've used a Script Task to call WinSCP, not pretty but it works.

PearlJammer1 (9/2/2013)

---

You can also connect to the Integration Services Server via SSMS, right click on the package under 'Stored packages/MSDB' to locate your SSIS package. then right-click on it and...

PearlJammer1 (9/2/2013)

---

There are several ways to open the the actual SSIS package (the dtsx file).

One way is to open Visual Studio, create a new SSIS project and then, in the...

Yes, the DtsConfig file contains parameters for the SSIS package - it is one way of making the package more flexible by changing parameters instead of rebuilding the SSIS package...

Somebody want to change their Server into a games Server.

http://www.sqlservercentral.com/Forums/Topic1487098-391-1.aspx

I thought SQL Server servers were already games machines - Whak-a-mole.

GilaMonster (8/6/2013)

---

The movie's good if...

A simple example of the PIVOT instruction exists on the MSDN. Have a play with that and let us know how you manage when you get the chance:

http://msdn.microsoft.com/en-us/library/ms177410(v=SQL.105).aspx

Because VoucherBookletNo has to be...

"I'm a DBA, it turns out"

How do you suddenly discover that you're a DBA?

I've just recovered from paying for...

I assume that you want to replicate insertions from the Publisher, but keep them on the Subscriber for longer; so when they are deleted from the Publisher the Subscriber still...