Search results for query: *

Hello... I'm hoping someone will point me in the right direction here... I want to automate a service to run every 15 minutes that will log into a website, navigate a couple of menus and then click a button before logging out. Is there a quick and easy (preferably free) non-coding solution out...

Hello... I've published a webservice (Workday WSDL format) from Workday... ...but when I try to set up a webservice task in SSIS I get a "The selected Web method contains unsupported arguments" error Anyone had experience importing WSDL into SQL Server that could give me a tip? Cheers, Mike

Hello! Anyone know of a tool (within SSMS / 3rd party) to take the pain out of setting up unions queries with a large number of columns/sources... It would be great to be able to 'drag and drop' field names into columns ie: Field1 Field2 Field3 CustID CustName Type...

Hi ehaze... No couldn't get it fixed, had to roll back to sp2007 snapshot from friday night and lose the weekend's upgrade work - painful... Need to set it all up on test and see if your idea works before trying again on live... Thanks Mike

Need advice really urgently... if you know how / why please reply asap... thanks! Mike

Hi ehaze... want to move the message from a mailbox into a library...

PS We have SharePoint 2010

Hello! I have 26 mailboxes across 3 exchange servers (2x2003 1x2010). Total size of all mailboxes is 700Gb, 3.5m items in approx 400,000 (sub)folders. We are looking to migrate these to our SharePoint server, just wondering what is the most cost effective method of migrating all mail items...

Hello... I have an SSIS package that runs on a 64bit 2008 SQL Server, works fine. The bottom line is: I'd like a user to be able to kick off the package from their 32bit workstation. They don't have SQL Server or Management Studio installed. I thought I was nearly there when I set up a Job to...

Hello! I wonder if this is possible. I have an SSIS package which imports data from a couple of sources, uses fuzzy lookup and writes results to a table. Is it possible for multiple users to call the same SSIS package (possibly simultaneously)? Here's a little more detail: A front end...

Thanks Bborissov... I'm runing 2008 and you're right! I closed SSMS and reopened and now I have hints!!! If only everything in SQL Server was that easy! Thank you! Mike

Hello! Are you able to set parameter hints for UDF's... Like the little yellow box that pops up when you type: "left(" to help the user add the parameters in the correct order? Cheers! Mike

Thanks r937/Rhys666! I didn't try the rank / partition option at first as I didn't understand it... I found this website which explains it perfectly... http://weblogs.sqlteam.com/jeffs/archive/2007/03/28/60146.aspx I didn't use a CTE, instead I used a dervied table... Also I had duplicate...

Thanks very much for those suggestions... I've set this up but I've noticed that a client can have more than one entry per date. How could I amend these suggestions so the results shows the latest record but just one record per client. (Where there is more than one record per client which...

I can't figure this one out... My table includes [Client], [Dept], [Date], (plus other)fields. I want to see just the record (all fields) relating to the most recent [Date] per [Client]. Any tips greatly appreciated! Mike

Hello... I'm trying to set up a linked server to an IBM Universe DB, I've been told that I need the UNIOLEDB provider... Does anyone know where I can get/downlaod this? Many thanks, Mike

Hello... my SSIS Fuzzy Lookup package is giving a similarity of 1 for a pair of nulls! Anyone know a tidy way to set this to zero from within the package? Many thanks, Mike

I want to have your babies - thank you so much LB Mike

Hello - I'm having trouble with counts!! I've grouped my data and set up a count in the group footer but I want that count to be displayed next to each record in the details... This is what I want to acheive: Client Action Count 123 sale 2 123 buy 2 321 buy 1...

Thanks for both solutions.... r937... your solution fits best with my project... many thanks!