Viewing 15 posts - 11,206 through 11,220 (of 13,877 total)
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
Daniel Bowlin (8/4/2011)
Check a couple things.-Are there any blank rows in your spreadsheet?
-Has the schema of the spreadsheet or the destination changed at all?
Also, what is the worksheet name from...
August 4, 2011 at 7:41 am
sdvoranchik (8/4/2011)
=FORMAT(TODAY(),"MMMM dd, yyyy")
Very generous of you to play "guess the question" 🙂
August 4, 2011 at 7:06 am
Viewing 15 posts - 11,206 through 11,220 (of 13,877 total)