Viewing 15 posts - 11,206 through 11,220 (of 13,877 total)
Please explain why you want to use a 'temp variable' rather than a table variable. What do you think the difference is?
August 10, 2011 at 10:33 am
Paul?
Please provide sample source data & an idea of what the required results are (follow the link in my signature for advice on how best to ask for help).
August 10, 2011 at 9:38 am
ChrisM@Work (8/10/2011)
Try adding COUNT(*) OVER(PARTITION BY Residence_Address) to your first query.
From this, it sounds like you have managed to understand the initial post. I salute you sir 🙂
August 10, 2011 at 9:01 am
Thank you.
Eugene, your answers make a lot of sense, thanks for taking the time to respond.
Phil
August 10, 2011 at 7:34 am
Can you change the format of the spreadsheet?
Or perhaps add a new worksheet which formats a copy of the data nicely, ready for import? If you do it right, it...
August 9, 2011 at 12:54 pm
hemani2000 (8/9/2011)
Hi,I am getting the following error message when I run my SSIS package with more than 200,000 records to go through LookUps and FuzzyLookUps but it w
A bit too...
August 9, 2011 at 9:47 am
Elliott Whitlow (8/9/2011)
Phil Parkin (8/9/2011)
Elliott Whitlow (8/9/2011)
August 9, 2011 at 9:39 am
sahoong (8/9/2011)
August 9, 2011 at 9:36 am
I don't think that this is a problem with SSIS. That error is an FTP error. Have you tried FTPing the file manually, by some other mechanism, just to check...
August 9, 2011 at 9:27 am
Elliott Whitlow (8/9/2011)
August 9, 2011 at 9:23 am
sahoong (8/9/2011)
I have this task to accomplish
Please take last night’s full backup and convert it to a standard Microsoft SQL backup file, compress the file and then FTP it to...
August 9, 2011 at 9:15 am
Aparna-1 (8/9/2011)
I have a script task that invokes a webservice. The response of the webservice is saved as a string.
I then call an execute sql task to save the...
August 9, 2011 at 2:34 am
kramaswamy (8/5/2011)
Is SSIS more, less, or just as efficient as SQL Server at handling data...
August 8, 2011 at 1:55 pm
Is the package picking up a configuration from somewhere which contains the problematic connection?
August 8, 2011 at 5:01 am
Viewing 15 posts - 11,206 through 11,220 (of 13,877 total)