Viewing 15 posts - 11,221 through 11,235 (of 13,877 total)
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
What I need to do is send an email based on teh value of that variable.
You can use precedence constraints to control which logical path an SSIS package follows. So...
July 27, 2011 at 1:56 am
Can you just scan the results of the queries by eye to determine which is behaving unexpectedly?
Once you know which query is returning the wrong results, it will be easier...
July 26, 2011 at 5:37 am
Viewing 15 posts - 11,221 through 11,235 (of 13,877 total)