Forum Replies Created

Viewing 15 posts - 166 through 180 (of 203 total)

  • RE: problem with row delimeter

    Imports System

    Imports System.Data

    Imports System.Math

    Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

    Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

    Public Class ScriptMain

    Inherits UserComponent

    Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

    ...

  • RE: problem with row delimeter

    Kbattta, I don't agree with u . that might be a solution, but what if u load file daily and ur load is automatic. u don't want to open each...

  • RE: problem with row delimeter

    Samtel.. , u sound mad and frasutrated. Common this is not the place to show, and my appologies if i am wrong.

    What i understand is--u have a flat file and...

  • RE: Bulk Insert Task Within ForEachLoopContainer???

    Dear Pu.........,

    My assumption was not a statement, it was a question becoz i was failing. Finally with some tweaks i was able to do it. There was nothing wrong...

  • RE: ACTIve X Script and/or Script Task...Alternatives

    SORRY.......

    Here is the code---------

    '**********************************************************************

    ' Visual Basic ActiveX Script

    '************************************************************************

    Function Main()

    Dim fso

    Dim fil

    Dim fold

    Dim coll

    Dim CurrentDate

    Dim i

    Dim arrFiles()

    Dim pkg

    Dim stpContinue

    Dim stpStop

    set fso = CREATEOBJECT("Scripting.FileSystemObject")

    set fold = fso.GetFolder(DTSGlobalVariables("FilePathRoot").Value)

    set coll = fold.files

    CurrentDate...

  • RE: DTS Migration Wizard Error

    HEllo, I am doing Migration Too. never had problem of these type. However, there are some task that will never get migrated, so bettr is skip and run the wizard....

  • RE: SEND MAIL TASKS for OnError Event Handlers

    Thanks Michael , I will try your first option tomorrow.

    I think i am not clear in explaning my problem. I want to send email as weel as log the problem...

  • RE: DATA FLOW TASKS IN SSIS....! A CHallenge ? Or ...??

    Yes Throws me error, becoz those empty strings gets truncated and sql server thinks some data are being lost. tried every possible cobinations that I could think of

  • RE: connection proerty in Execute SQL TASK

    When u click the propert expression square eclipse on the right, an expression builder opens, where u can bulid the expression and also u can evaluate it before u press...

  • RE: blank dates

    I am not sure exactly i understood everything here.

    But, few days back i used to have the same problem with null columns that was a dbtimestamp. My case was i...

  • RE: Making it easier to move between environments

    Thanks Prarav!!!! Aprreciate ur time and response. let me try here . U r right, u don't learn until u make mistakes. i will update the progress. Once agian thanks.

  • RE: Bulk Insert error logging

    One option I can think of is redirect error to flat file. Just use dataviewers to see how the bad rows gets directed.

    Thanks.,

  • RE: Making it easier to move between environments

    I understood this part. The problem, or i would say my confusion is , ok, i have 30 bulk insert connections, and every bulk insert connectiosn uses different files, however...

  • RE: Making it easier to move between environments

    Thanks Pravar!!! What i did was something little different. I have like 50+ packages. All together there are 6 databases that i will be connected to. SO for eack database...

  • RE: Making it easier to move between environments

    Pravar YOu are absolutely right!!!!! If u are using XML file and reuse same file for other packages then u have to have same connections for all other packages ....

Viewing 15 posts - 166 through 180 (of 203 total)