Forum Replies Created

Viewing 15 posts - 16 through 30 (of 94 total)

  • RE: VB Script Task - Running

    Thanks for the replies.
    I got it working with  a excel macro. I recorded the macro in excel doing what I wanted this using a .BAT and .VBS script and...

    April 19, 2018 at 5:44 pm

    #1987612

  • RE: VB Script Task - Running

    I have also tried creating a script.vbs with

    Dim objexcel As New Microsoft.Office.Interop.Excel.Application
    Dim wb As Microsoft.Office.Interop.Excel.Workbook
                wb = objexcel.Workbooks.Open(Filename:="C:\DSM Excel Files\Healthcare Logictics\Download\Z_ZVSDR274_PRINCMTD_00000.xls")
                wb.SaveAs("C:\DSM Excel Files\Healthcare Logictics\Z_ZVSDR274_PRINCMTD_00000.xlsx")           ...

    April 18, 2018 at 11:06 pm

    #1987447

  • RE: VB Script Task - Running

    Thanks for the reply.
    I have created a excel macro which works when I run it in excel. I am trying to run it via the script task. But It comes...

    April 18, 2018 at 8:20 pm

    #1987439

  • RE: For Each Loop - Move to next file

    this is the file task

    April 14, 2018 at 6:00 pm

    #1986856

  • RE: For Each Loop - Move to next file

    Once I change the loop retrieve file name to fully qualified it loads the file but the file task doesn't work.

    April 11, 2018 at 10:45 pm

    #1986510

  • RE: ADO .NET Excel

    I got it working using the Kingsway excel connector. The Microsoft excel connector wont accept the metadata.

    April 8, 2018 at 8:21 pm

    #1985914

  • RE: ADO .NET Excel

    Thanks for the replies.
    I am still unable to connect to the excel xlsx files, These are being generated by IBM TM1. If open and save the excel file...

    April 8, 2018 at 6:45 pm

    #1985910

  • RE: Looping Through Multiple Excel

    I worked it out, both the source folder and source file variables have to resolve before running in the loop. So run the file variable with a file before adding...

    April 2, 2018 at 10:37 pm

    #1985230

  • RE: Conditional Split Expression

    Phil Parkin - Wednesday, March 14, 2018 5:05 PM

    ringovski - Wednesday, March 14, 2018 4:57 PM

    March 14, 2018 at 5:10 pm

    #1983322

  • RE: Remove extra brackets from column

    The first thing I have done is find the rows where there are multiple brackets, so there is a odd number.

                
    September 6, 2017 at 6:48 am
    
            
    #1958333

  • RE: Dynamic Like

    I found a way to do the like in the join that appears to be working.

    UPDATE #temptitle3
         SET SupplementaryInformation = SUBSTRING(Title,CHARINDEX('(',Title),LEN(Title))
         FROM #temptitle3
         JOIN @textsvalueBG...

    August 8, 2017 at 6:03 pm

    #1954548

  • RE: Dynamic Like

    I think the problem is the IN it needs to be a IN Like from title to %val%. How do I make it a like?


    UPDATE...

    August 8, 2017 at 5:44 pm

    #1954546

  • RE: Identity Insert

    I have written a Cursor, but the same issue is happening, columnid is not increasing by 1 each time through the loop. Any suggestions?

    DECLARE @ColumnID...

    July 27, 2017 at 7:38 pm

    #1953137

  • RE: Identity Insert

    Thanks for the reply.
    Unfortunately your row_Number() returns the same as when I tried to use it, which is why I switched to trying using a while loop. The Row_Number()...

    July 27, 2017 at 5:59 pm

    #1953133

  • RE: Format Message

    I do want the 100, but it doesn't work it gets syntax error?

    February 14, 2017 at 5:53 pm

    #1928530

Viewing 15 posts - 16 through 30 (of 94 total)