Forum Replies Created

Viewing 15 posts - 31 through 45 (of 78 total)

  • RE: eliminating comma from a string

    scottichrosaviakosmos (5/9/2011)

    yes, I want to eliminated comma before importing my data into sql server.

    You can first import your data into an SQL staging table. Then run an update statement to...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 9, 2011 at 12:39 am

    #1321559

  • RE: Error while deploying CLR Stored Procedure - There were deployment errors.Continue

    mayank.singla (4/28/2011)

    Hi,

    I am facing issues while deploying CLR Stored procedure. I am not getting any message in error list or in output window but an error box saying "There were...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 28, 2011 at 3:46 am

    #1317119

  • RE: Error while deploying CLR Stored Procedure - There were deployment errors.Continue

    mayank.singla (4/28/2011)

    Hi,

    I am facing issues while deploying CLR Stored procedure. I am not getting any message in error list or in output window but an error box saying "There were...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 28, 2011 at 3:44 am

    #1317118

  • RE: Begin Tran and Commit/Rollback Tran in SSIS

    avadhut.joshi 17339 (4/28/2011)

    if I do it then only 75% of my containers run properly last two containers dont get run..so is there any issue with that..am I doing any mistake...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 28, 2011 at 3:39 am

    #1317113

  • RE: Begin Tran and Commit/Rollback Tran in SSIS

    Did you set the 'RetainSameConnection' property to True on your connection (from the connection manager)?

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 28, 2011 at 3:22 am

    #1317106

  • RE: Begin Tran and Commit/Rollback Tran in SSIS

    avadhut.joshi 17339 (4/28/2011)

    Hi

    I am finding following error for transaction.

    Error: 0xC002F210 at CommitTransaction1, Execute SQL Task: Executing the query "Commit Transaction BeginTransaction1" failed with the following error: "The COMMIT...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 28, 2011 at 2:51 am

    #1317090

  • RE: Memory Utilization of individual db instances of a DB server

    sashikanta.mishra (4/28/2011)

    Hi Gail,

    Thanks for the same.

    Even our team is working on for SQL 2005 and 2008. So, it will be helpful if somebody can tell me how monitor the...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 28, 2011 at 2:39 am

    #1317080

  • RE: Execute SQL task is not changing to green color on success

    sivaprasadyellala (4/27/2011)

    SSIS guru's,

    I am running a delete statement in Execute SQL task passing a...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 28, 2011 at 1:46 am

    #1317073

  • RE: FlatFile source and OLEDB destination

    kiruthika.naren (4/27/2011)

    my text file is not in formatted way. see below example.

    R001D0345003214555 Ambika, Mahesh A

    in the above sample,

    R001 - region

    D0345 - district

    003214555 Ambika, Mahesh A - employee cde...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 28, 2011 at 1:42 am

    #1317072

  • RE: Problem in Oledb Command when calling stored procedure

    BackT0Work (4/26/2011)

    I have a stored procedure

    create procedure ErrorMail_sp

    @JobName varchar(50),

    @TableName varchar(50),

    @Issue varchar(MAX)

    AS

    BEGIN

    declare @desc varchar(MAX)

    set @desc= ' Job Name : ' + @JobName + ' Table Name : '+ @TableName+ ' Issue...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 26, 2011 at 8:05 am

    #1315893

  • RE: Export to Flat File issues plz help me on with it...

    Sri8143 (4/25/2011)

    I am trying to export a table to flat file using Pipe Delimited(Doesnt matter if its other delimited also).

    There is a column which has datatype varchar(512) when exported...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 26, 2011 at 7:01 am

    #1315838

  • RE: SSIS Package Not Writing all the Rows to OLE DB Destination Although shows the complete numbers on dataflow Path

    BackT0Work (4/19/2011)

    my SSIS package loads data from excel file to SQL server table. The excel file has 5000 rows.

    When I execute the Package the number of rows shown in the...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 21, 2011 at 4:39 am

    #1314402

  • RE: Log files in SSIS

    Hello

    Never tried this but maybe you can check if an INSERT/UPDATE trigger on the sysssislog table will do the job for you?

    Also, maybe at the end of your package, you...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 21, 2011 at 4:16 am

    #1314400

  • RE: sp_dts_addlogentry SP

    rmkmurali (4/20/2011)

    [font="Tahoma"]

    Hello Friends,

    I was going through several blogs and found a way to log the package run details to a user defined table. Following is the code for the same.

    CREATE...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 21, 2011 at 4:08 am

    #1314397

  • RE: Tuning image datatype

    ESAT ERKEC (4/15/2011)

    When i remove image column in query it is use index but when i add image column it dosent use index it use clustered index

    When you remove...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 18, 2011 at 1:00 am

    #1312616

Viewing 15 posts - 31 through 45 (of 78 total)