Viewing 15 posts - 11,221 through 11,235 (of 13,879 total)
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
radb4u (8/3/2011)
Row.vchImportCustomerPhoneNumber = nonumbers.Replace(phone, String.Empty)
Error says 'disallow implicit conversion of string to integer'.
So, I am trying to change the data...
August 3, 2011 at 9:02 am
radb4u (8/3/2011)
I have written a script to format the phone number (to exclude special charecters). It was working fine. But, in between testing it started not working. It i sgiving...
August 3, 2011 at 8:48 am
Ninja's_RGR'us (8/3/2011)
Ya but you can format the date to whatever you want once in ASPX. I would search there rather than SQL side.
I agree with this - it seems...
August 3, 2011 at 7:17 am
Ninja's_RGR'us (8/1/2011)
Anyone has a link to says that the set statement is ALWAYS eveluated /...
August 1, 2011 at 9:03 am
Are you 100% sure about that one [Wink].
I know you've been around here for a very long time and I hate to suggest that you are wrong, but how does...
August 1, 2011 at 9:00 am
You can't do that - all of your field references will be to the situation as it was 'before update'.
So you need to write things out in full rather than...
August 1, 2011 at 8:38 am
Not sure I understand.
Use SELECT instead of PRINT?
July 30, 2011 at 5:00 am
What do you mean by 'not working'? Wrong result, or error? If error, please post the error.
Have you considered doing this in T-SQL as part of your select?
July 30, 2011 at 3:01 am
TTboy (7/29/2011)
Mainly I have 2 tables: TableA and TableB.
A record in TableA can have...
July 29, 2011 at 9:30 am
Edward-445599 (7/28/2011)
steveb. (7/28/2011)
one way is to write an update or delete statement in the ole destination and use this in...
July 28, 2011 at 3:01 am
steveb. (7/28/2011)
one way is to write an update or delete statement in the ole destination and use this in the...
July 28, 2011 at 2:50 am
Viewing 15 posts - 11,221 through 11,235 (of 13,879 total)