Forum Replies Created

Viewing 15 posts - 91 through 105 (of 140 total)

  • RE: hi i want to copy a zip mfile from one location to other after renaming it in DTS Packages using VB Script

    What error are you getting?

    The script is a straight copy from one that is in use on our servers. 

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

    December 28, 2006 at 4:02 am

    #680231

  • RE: hi i want to copy a zip mfile from one location to other after renaming it in DTS Packages using VB Script

    Alternatively you could use a scripting task and the FSO to avoid using xp_cmdshell

     

    Dim oFSO

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

    December 28, 2006 at 3:23 am

    #680228

  • RE: Remove non numeric characters

    This is our server at work (Twin 1.2Mhz PIII's & 1Gb Ram)

     

    --===== Frank's function

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    DBCC execution completed. If DBCC...

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

    December 21, 2006 at 4:56 am

    #679369

  • RE: Combo Box Limited to 36000 records or so

    At least until version 11 (1,000,000 rows)

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

    December 6, 2006 at 3:30 am

    #676161

  • RE: Dtsrun.exe without SQL2000

    Have a look here to start

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

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

    November 29, 2006 at 3:28 am

    #674614

  • RE: Security Question->User need to Alter tables, but objets must remain current dbo

    It's ok as long as they don't start arguing.  Then it gets too loud.

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

    November 28, 2006 at 7:04 am

    #674322

  • RE: Dynamically set Text File Source in SSIS

    Are you using a Script Component in SSIS?

    You could try using the ForEach component and set it to look for the part of the filename that does not change.

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

    November 28, 2006 at 2:15 am

    #674261

  • RE: Upsert Dimension Table

    The article is printed in one of the fullstops via microfilm (lol)

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

    November 28, 2006 at 1:47 am

    #674255

  • RE: Security Question->User need to Alter tables, but objets must remain current dbo

    Fortunately I am the only DBA here so what I say goes!! (As long as I listen to myself )

    OOps just been told...

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

    November 28, 2006 at 1:15 am

    #674247

  • RE: Unable to establish connection

    Ad the server is local, have you tried rebooting the machine?

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

    November 27, 2006 at 4:49 am

    #674003

  • RE: Unable to establish connection

    Can you connect to the server using its IP address?

    Can you ping and tracert to the server via its name?

    I had this problem and "fixed" it my adding an entry...

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

    November 27, 2006 at 2:05 am

    #673984

  • RE: Security Question->User need to Alter tables, but objets must remain current dbo

    Users altering tables

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

    November 24, 2006 at 2:27 am

    #673765

  • RE: DTS Export to CSV

    Are the quotes around each field?  If so it could be set to quote text.

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

    November 24, 2006 at 2:20 am

    #673764

  • RE: Conditional Order By?

    How about something like:

    DECLARE @Order string

    DECLARE @sql string

    SET @sql = "SELECT * FROM Blah "

    SET @Order = CASE WHEN

    @orderId = 1 then "title asc"

    when @orderId = 2 then "title...

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

    November 24, 2006 at 2:08 am

    #673761

  • RE: Good DBA books for SQL Server 2005 and SSIS?

    Watch out for chapter 6 (Evaluate SQL Task).  Don't spend time trying to figure out the problem, go to their web site and forum.

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

    November 24, 2006 at 1:22 am

    #673756

Viewing 15 posts - 91 through 105 (of 140 total)