Viewing 15 posts - 481 through 495 (of 1,081 total)
did you build failure action as well into your dtsx package?
for every success you need to anticipate a failure action as well, maybe use send mail or log a...
December 20, 2011 at 2:09 am
Text to Columns.
in the menu under "Data", "Text to Columns"
December 20, 2011 at 2:07 am
on the package property's, set ON FAILURE report SUCCESS..
see attachment.
December 20, 2011 at 2:02 am
GilaMonster (12/20/2011)
Dev (12/20/2011)
Henrico Bekker (12/20/2011)
some help here....what am i missing from his side?http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
Change compatibility level of your database to make your code bulletproof.
ALTER DATABASE Testing SET COMPATIBILITY_LEVEL =...
December 20, 2011 at 1:55 am
Koen Verbeeck (12/20/2011)
Henrico Bekker (12/20/2011)
I am not a very fast reader as it would take too long to read a book.
Absolutely zero and no offence to Koen, but...
December 20, 2011 at 1:52 am
I only inserted a few of his records, not all, so the value of COUNT is irrelevant here.
December 20, 2011 at 1:49 am
Lynn, he wants the datetime displayed as DATE only...
read my previous posts...which doesnt seem to work on his installation..
December 20, 2011 at 1:45 am
some help here....what am i missing from his side?
http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
December 20, 2011 at 1:18 am
I am not a very fast reader as it would take too long to read a book.
Absolutely zero and no offence to Koen, but being able to read...
December 20, 2011 at 1:12 am
ok replace then:
select (left(convert(varchar, VISIT_DATE, 120),10)) AS 'date', count(VISIT_DATE) as count
from XXOH_AMT
GROUP BY Visit_Date
December 20, 2011 at 1:09 am
are you casting your datetime format to date?
I run 2008 R2 and results:
date count
...
December 20, 2011 at 1:01 am
Dev (12/20/2011)
Considering last three post, I would like to correct my initial suggestion. Please hire a technology independent consultant (like me). SSC is biased for SQL Server. 😀
what...
December 20, 2011 at 12:59 am
somewhat incomplete, just painting the background here...
INSERT INTO XXOH_AMT ( VISIT_DATE, PATIENT_ID,Amount ) VALUES
('07/01/2011 12:00:00 AM','2275', '20') ,
('07/01/2011 12:00:00 AM','2275', '30') ,
('07/01/2011 12:00:00 AM','2275', '40') ,
('07/01/2011 12:00:00 AM','2298', '40')...
December 20, 2011 at 12:44 am
Have to agree with Dev, get a multi skilled, experienced Consultant to advise on your companies needs.
There is never a "yes" or "no" answer upfront, they have to evaluate and...
December 20, 2011 at 12:32 am
Viewing 15 posts - 481 through 495 (of 1,081 total)