yeah... of course it should!

It Appears i've had a bit of a blonde moment! I don't know why I didn't think of that

Thank you!

This is such a great forum. I'd agree with all the above comments and it's great to be able to call upon others experiences and equally use your own...

Have a read through the attached troubleshooting document.

Very useful document, which covers everthing you need to know, including some common example scenarios and also set SPN commands.

😉

wow. Thanks for all the quick responses!. That's perfect thank you.

As always the ladies and gents of sqlserver central have been a great help.!

Everyday is a school day...............:-D

Sure,

I've got no problem in creating an article for it. 🙂 Should be pretty quick to knock together.

Tim - Thanks for posting.

I've managed to create a dynamic ETL process to split data into SQL tables (including creating the table if required) using this process with a few...

well, for now I'm going to use the Kimball SCD as amongst other things it doesn't destroy the data flow when I need to make a change.

Also it has...

right,

I've come up with this t-SQL to give me almost what I need:

SELECTDISTINCT

s1.voyno

,s1.sco as [sco1]

,s2.sco as [sco2]

,s3.sco as [sco3]

,s4.sco as [sco4]

,s5.sco as [sco5]

,s6.sco as [sco6]

,s7.sco as [sco7]

fromdbo.VoyageSCOss1

LEFT OUTER JOINdbo.VoyageSCOss2

ons1.voyno=s2.voyno

ANDs1.sco!=s2.sco

LEFT...

Here a useful reference which is what pointed me in the right direction:

http://publib.boulder.ibm.com/html/as400/java/rzahhx08.htm

Hi,

I never posted back, but I did manage to get FTP to as AS 400 working.

Manually putting a file on the server, you would do something like the following from...

Hi thanks for letting me know.

Turns out a simple restart of the SSIS service worked!

could you give an example of using the GAC tool though, I colleague has since...

Hi

I'm just setting up reporting services in Sharepoint Integrated mode.

Should I be able to view the Report Manager site as you would, with a non-sharepoint integrated report server?

Everything in the...

Although, I've just seem your screen shot, so If I can dynamically generate the logfile each time then that may actually be a good way forward.

Not a bad suggestion. but I think it would be easier just to...

lol 🙂 fair point.