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...

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,...

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.

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...

Have you read these 2 articles?

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/cross+tab/65048/

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...

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.

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

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. ...

Not that I know of. If you manager SSRS from SSMS you can more Explorer like feel.

Yup, you are missing a closing parentheses at that point. You have not closed the NOT EXISTS sub-query.

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...

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...

I think you have mistaken the purpose of this web site. SQLServerCentral is not just a technical web site, but...

Duplicate post. Please reply here