Henning Rathjen (5/9/2016)

---

Hello russds,

Do you use the SSDT?

In a package you can use the lookUp transformation-task. In my opinion it's the best way to get the surrogate key from dimensions.

If...

Awesome fast response, thank you! Unfortunately that command returns 0 results for me. Any other ways of checking? I poked around the query a little, tried removing things,...

Same issue here. What are some tools/commands I can use to see what's starting the trace everytime the service/server restarts? I looked in the SQL Server -> SQL...

Thanks Bob. Yeah I had found that article too during my research. As you said, trouble is i don't have access to the SQL 2000 box. I'm...

Thank you I actually had found that article, and did try that, and it still didn't work. I did get it worked out using an odbc connection.

Thanks!

-Russ

Thanks Bob. I had seen that before, different error message and plus I don't have access to the SQL 2000 machine, so I didn't fully go down that path....

Thank you. My issue is actually just with setting up a Linked Server. It appears the problem is that I'm using SQL Server 64 bit and trying to...

yes, i did check those as true.

I believe the problem to be around the fact that the 2008 machine is 64 bit. I have setup the linked server on...

Did you get this worked out? Were there any special issues with regards to the Linked Servers? I'm doing the same thing, and have added a Linked Server,...