SSIS Transfer Object Task

Question

SSIS Transfer Object Task

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Duran SSChampion Points: 13259 More actions · Answer 1

Hi Phil, thanks for getting back.

There is no datbase on the other side, I just wanted to transfer the database along with everything into the 2008 instance (hence setting the model database to 90), do you think it would work better if I created an empty database on the 2008 instance and then set it 90?

Kind Regards,

D.

Phil Parkin SSC Guru Points: 246979 More actions · Answer 2

That won't make your problem go away.

This sounds like a job for backup/restore to me 🙂

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Duran SSChampion Points: 13259 More actions · Answer 3

Thing is I hve tried that and it misses too much stuff. Its so annoying that the Transfer objects task is what I need, but does not work properly.

Regards,

D.

Phil Parkin SSC Guru Points: 246979 More actions · Answer 4

I'm sorry, I don't know what else to suggest.

This link suggests that what you are trying to do should work just fine.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

douglas.allison1 SSC Rookie Points: 41 More actions · Answer 5

I am aware this is an old post but thought I'd share my findings.

Each database does appear to need the same compatibility level. If you go to both databases using SSMS then goto properties of each database and then select options if you check that both compatibility levels are the same Then the "Transfer Objects Task" module in SSIS will work.

This has worked for me and has not appeared to have any knock on effects to anything else.

Hope this helps someone out there.

pmaceke Ten Centuries Points: 1018 More actions · Answer 6

Set the destination to compatibility to 100 and it will work