Viewing 15 posts - 10,396 through 10,410 (of 13,879 total)
October 11, 2012 at 5:34 am
Your Excel column is holding mixed datatypes, so you'll need to bring in the column as string and add IMEX=1 to the Excel connection string (Google it for details).
October 11, 2012 at 1:12 am
sqlstud (10/10/2012)
Well it sort of depends on what you want. You currently have a datetime column but obviously "DECLINED" isn't going to work there. If you want to keep your...
October 11, 2012 at 1:10 am
Yes, this is harder than you might think. PSEXEC is what I have used in the past.
October 11, 2012 at 1:08 am
I would guess that the worksheet is called something other than 'sheet1'. Find out what that is and change the connection info.
October 11, 2012 at 1:06 am
n79799 (10/9/2012)
October 10, 2012 at 4:09 am
I'd do this by using a Conditional Split in the dataflow. Just redirect the unwanted rows to an output which goes nowhere, while letting the good rows run through as...
October 10, 2012 at 12:51 am
justmohit (10/9/2012)
you can use XML PATH to get the result
Who'd have thought?
Mark, perhaps?
October 9, 2012 at 11:19 am
Another way:
declare @BigString varchar(max) = ''
select @BigString = @BigString + Firstname
from #temp
order by id
select @BigString, lower(@BigString)
October 9, 2012 at 7:47 am
ssms-man (10/9/2012)
Ok, I understand what you want and will add to "to investigate" list. We did not re-use regions till now, so we'll need some time to invest before we...
October 9, 2012 at 6:21 am
ssms-man (10/9/2012)
Phil Parkin (10/9/2012)
ssms-man (10/9/2012)
Phil Parkin (10/8/2012)
October 9, 2012 at 6:09 am
ssms-man (10/9/2012)
Phil Parkin (10/8/2012)
October 9, 2012 at 5:19 am
Steve Jones - SSC Editor (7/28/2008)
October 9, 2012 at 3:06 am
Charmer (10/8/2012)
Phil Parkin (10/8/2012)
Charmer (10/8/2012)
Phil Parkin (10/8/2012)
A no-code solution could utilise FOREACH containers - the container just does not execute if...
October 8, 2012 at 3:15 pm
Four tables with different structures to one file?
October 8, 2012 at 12:46 pm
Viewing 15 posts - 10,396 through 10,410 (of 13,879 total)