Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 1,353 total)

  • RE: Terminate DTS package w/o failure

    You're welcome.

  • RE: Terminate DTS package w/o failure

    While there is a way to use your own step names using Disconnected Edit, I have not used that, and so have always had to use the name given to...

  • RE: Terminate DTS package w/o failure

    I too have found the Do not execute to not be the best way to do this, so why not try my suggestion and disable the subsequent step if there...

  • RE: Terminate DTS package w/o failure

    I have sometimes found the don't execute task method to not be completely reliable.  You could also try a variation of this.  I use this to disable the subsequent step. ...

  • RE: using IN operator in stored procedure

    Similar to the above solution, you could create a temp table in a business object, populate it with the entries selected, and write the stored procedure to use the temp...

  • RE: Can a report have a dynamic DSN?

    Not sure to which post you are referring because the time stamps are close, but if it's mine above, I am talking about a web application.  The reports are on...

  • RE: Can a report have a dynamic DSN?

    We create a business object on each server (dev, test, train, and production) that provides the connection information.  That component is accessed by each object, so as each object is...

  • RE: Which Approach? Job Steps or DTS Tasks

    I prefer fewer larger ones, though I do separate out smaller ones that could be independently used for other things.  For example, if I have an import that triggers a...

  • RE: DTS and Triggers

    I agree that cursors should be avoided at almost all costs.  If you find this is one of those rare events that would require a record iteration, however, since you...

  • RE: SQLServerAgentMail error

    Go to SQL Server Properties (Configure), under the Server Settings tab there is a SQL Mail Portion.

  • RE: SQLServerAgentMail error

    I don't know if this is the only way it can be done, but we do it this way and it works.  The SQLServerAgent runs under its own user account...

  • RE: SET STRANSACTION ISOLATION LEVEL

    We use this command in all our report SPS, or as a connection property, and it works as expected. 

  • RE: FTP File

    I did know that. What I'm looking for is some code, preferable VBScript, to FTP the file out. I've seen one sample, but it's not particularly clear, using...

  • RE: Usage of

    tbl may not say much, if all your tables were to start with that, although it certainly distinguishes them from the system tables. But when you have tlkp, tbl,...

  • RE: Guru needed- Real versus BigInt

    I know this is an old topic, but I've been busy. My two cents: Numbers that are not calculatable are strings. Char(10) for phone numbers. The...

Viewing 15 posts - 1,276 through 1,290 (of 1,353 total)