Data...

Are you explicity converting these datatype with a conversion transformation?

Are you able to post a screen-shot of this..?

enzomenoni (1/16/2009)

---

Hi All,

Hope someone can help with this. I have tried a few of the solutions around the web but am unable to get this to work.

Here's the problem.....

I am...

I guess number one.

What is the prize if I get this right?

There could be a couple of issues, how are you connecting to the SQL server ? if you are using ODBC then there is a possibility that...

There a few apps out there that you can use, I use Red-Gate, but you may find most of them are similarly priced.

To simply copy the tables you could...

You can use Management studio for this, expand the replication node and start a new publication.

though this can be quite a complex topic, esp. when you run into issues with...

Shaun McGuile (1/15/2009)

---

steveb (1/15/2009)

---

I would use SSIS, as this seems like a simple project to give you exposure to it. Also it is becoming a requirement for...

I would use SSIS, as this seems like a simple project to give you exposure to it. Also it is becoming a requirement for a lot of...

I agree with what has been said about FTS,...

Alternatively you can use SSIS for this, I did something similar recently and found SSIS worked perfectly.

You can use merge replication for this, this way only the data changed will be copied back and this should be a lot faster. Also merge replication allows you...

Seems like it may be a security issues then, Are you running this package from a SQL server agent job?

If so does this agent have the appropriate permissions to...

Try goint to start---> run --> devenv.exe to load this.

Also do you also have Visual Studio installed as well, as it will be avaliable in there as...

You could try a log-reader but be aware that these can be quite expensive, and it may hard explaining to your boss why you did not have any backups.