Viewing 15 posts - 4,591 through 4,605 (of 9,643 total)
Dave, nothing scheduled until September now. If I'd have known a couple weeks ago we could have maybe gotten something done in August. Our group meets every other...
July 28, 2009 at 7:37 pm
I'll attempt to answer part of your question.
during data transformation if an error occurs in any row, then I need to skip that error and continue the data loading process,...
July 28, 2009 at 9:43 am
Do you guys meet monthly?
The next time I'm in New England maybe I can schedule to be your area around a meeting time.
July 28, 2009 at 9:33 am
That's odd, because when I have submitted an article, script, or QoD I seem to always be notified about comments. I wonder if there has been a change that...
July 28, 2009 at 9:32 am
Have you read these 2 articles?
July 28, 2009 at 9:30 am
I'm not sure I understand why you need to this? Essentially you are saying that there is a parent-child relationship between parameter1 and parameter2, so how would changing a...
July 28, 2009 at 9:27 am
What type of authentication is your data source using? If you are using Window Authentication then you need to make sure the users have access to the database.
July 28, 2009 at 9:06 am
SSIS implements the IF Else construct as:
condition ? [then result] : [else result]
Everything else in your CASE is similar. CAST is done like this:
(DataType)value
July 28, 2009 at 7:45 am
Here's another option, similar to what Drew has suggested:
DAY(date) < 15 ? DATEADD("Month",DATEDIFF("Month",(DT_DBTIMESTAMP)"1/1/1900",date),(DT_DBTIMESTAMP)"1/1/1900") : date
This is based on the T-SQL date functions posted by Lynn Pettis on his blog. ...
July 28, 2009 at 7:38 am
Not that I know of. If you manager SSRS from SSMS you can more Explorer like feel.
July 28, 2009 at 7:11 am
Yup, you are missing a closing parentheses at that point. You have not closed the NOT EXISTS sub-query.
July 27, 2009 at 9:07 pm
You really can't do what you are asking. You can audit logins/logouts or run a server-side trace to audit the database, but there is no way to trigger an...
July 27, 2009 at 8:19 pm
Just a guess, but I think your parenthesis are likely out of whack. Have you tried commenting out the last union all Select to see if that is the...
July 27, 2009 at 8:13 pm
sjsubscribe (7/27/2009)
What is this nonsense doing on a technical website?
I think you have mistaken the purpose of this web site. SQLServerCentral is not just a technical web site, but...
July 27, 2009 at 12:57 pm
Viewing 15 posts - 4,591 through 4,605 (of 9,643 total)