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...

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

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...

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

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

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...

hello... my brain is worn out trying to figure this one out... I have 2 fields (name, answer) In my select statement I want to return I third column that states 'true' if at least one 'correct' exists (in the answer field). something like: Name Answer AtLeastOneCorrect Andy wrong...