sql server 2019

Technical Article

RE: obtaining a reference to the current package

  • Reply

Dim objPkg  ' Get Package object  Set objPkg = DTSGlobalVariables.Parent This will get you a reference to the package itself. Then you can access all the properties you just mind have to google ad dig around for what you need syntax wise. I have no test machin here so if you need more help leave a […]

2005-04-30

Technical Article

RE: Use RAISERROR with International error messages?

  • Reply

Ah, ussage is your promblem! this is how you are supposed to use it:at setup time call sp_addmessage for all required languagesex:use master exec sp_addmessage @msgnum = 50001, @severity = 10,  @msgtext = N'US English message',    @lang = 'us_english'EXEC sp_addmessage @msgnum = 50001, @severity = 10,    @msgtext = N'Mensaje en Español',    @lang = […]

You rated this post out of 5. Change rating

2005-04-28

Technical Article

RE: Recursive Queries in SQL:1999 and SQL Server 2005

  • Reply

I apologize in advance if this set of questions takes the topic too far off track.  We can easily take the conversations to a different thread if appropriate.Excellent article.  It is very clear that 2005 will greatly simplify traversing hierarchies and networks, at least from a syntax perspective.    Most of my work uses multiple orthoganal hierarchies and […]

You rated this post out of 5. Change rating

2005-04-28

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers