Forum Replies Created

Viewing 15 posts - 106 through 120 (of 140 total)

  • RE: Help to export data into Execel sheet

    You could export the info into a spreadsheet then use an ActiveX script to rename the file.  This means that the file is always available for the package.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    November 22, 2006 at 3:22 am

    #673402

  • RE: The Test of Time

    Good luck guys.

    Already have fourdeuce.com as a favourite to keep an eye out for what your doing next.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    November 15, 2006 at 2:09 am

    #671875

  • RE: DTS step sequence

    That sounds like the easiest way.  (Anything for an easy life )

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    November 15, 2006 at 1:46 am

    #671871

  • RE: duplicate key row??

    Could it be that there is a null record already in the table?

    The table allows nulls into UserName but the index based on it is unique.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    November 15, 2006 at 1:43 am

    #671870

  • RE: DTS Import from Access

    As Bill said DTS does not like open files so another option rather than a separate Acces database would be a VB front end.

    I have an Access front end whose tables...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    November 15, 2006 at 1:24 am

    #671867

  • RE: Using USE when the database doesn''''t exist.

    Try
     
    IF EXISTS(SELECT * FROM MASTER..SYSDATABASES WHERE NAME = N'myTESTdb')

      USE myTESTdb

    ELSE

      GOTO QuitWithRollback

     
    BEGIN TRANSACTION
    ... some more tsql ...
     
    QuitWithRollback:

    ROLLBACK TRANSACTION

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    October 24, 2006 at 4:34 am

    #667520

  • RE: database connection could not be established!

    Can you connect using the IP?  Does tracert <servername> connect?  I recently had a similar problem and ended up having to put entries into my hosts file as for some...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    October 24, 2006 at 4:16 am

    #667519

  • RE: Closing Out Replies

    I agree with Yelena in at least letting everyone involved know that the problem was resolved.  I'd be inclined (if I found a solution on another site.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    October 24, 2006 at 2:14 am

    #667505

  • RE: Management Studio with SQL2000

    I only use EM to create/edit DTS packages now.  Everything else is done via the Management Studio. 

    I love the ability to modify without having to script out an ALTER...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    September 19, 2006 at 1:34 am

    #661184

  • RE: Scheduled DTS Job fails

    Does the specified user have sufficient privileges to execute the package?  If you schedule the job to run with your ID does it run?

     

    John

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    August 31, 2006 at 6:05 am

    #657764

  • RE: Multiple Emails With One DTS package

    Or, if you can't get that sorted out (I can never get it to work on our system)

    http://sqldev.net/xp/xpsmtp.htm

     

    Cheers

    John

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    August 24, 2006 at 7:12 am

    #656557

  • RE: Run-time error ''''-2147467259 (80004005)'''' :[DBNETLIB][ConnectionOpen(Connect()).] SQL Server doesnot exist r access denied.

    The problem can be around security for the slammer worm, and a dll called DBNETLIB.dll. When this file is out of date, Server 2003 and perhaps SP2 on XP will actually disable...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    August 16, 2006 at 6:47 am

    #655239

  • RE: DST to run by command line but get error message... help!

    http://www.databasejournal.com/features/mssql/article.php/3404791

    The account has to be the package owner, but not much else. (I think)

    John

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    August 15, 2006 at 8:00 am

    #655060

  • RE: DST to run by command line but get error message... help!

    This site has a list of the files required to redistribute a dts package:

    http://www.sqldts.com/default.aspx?225

    I created a self extracting zip file to install the files on target pc's and a batch...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    August 15, 2006 at 5:20 am

    #655028

  • RE: Best Way To Handle File I/O From SQL

    I always use DTS with an ActiveX script and the FileSystemObject to move/delete/rename files.  Moving files first then renaming  (adding the current datetime), works every time for me.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    August 10, 2006 at 2:28 am

    #654222

Viewing 15 posts - 106 through 120 (of 140 total)