Forum Replies Created

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

June 21, 2012 at 9:19 pm

#1504329

  • RE: SSIS configuration file ConnectionString Application-Name

    SJanki (6/11/2012)

    What is the Application Name attribute in the connection-string of an ssis configuration file?

    I want to deploy the package into test server , shall I remove this attribute?

    Thanks

    ~SJ

    Please ignore...

    June 11, 2012 at 3:48 pm

    #1499552

  • RE: Setting the Identity in a temp table using a variable

    Eugene Elutin (5/17/2012)

    OP wanted to start IDENTITY from the position calculated/given in variable. The only way to do this is to INSERT with INSERT_IDENTITY ON. It's impossible to do it...

    May 17, 2012 at 12:22 pm

    #1489292

  • RE: group by & having or ranking

    Thanks Jeff. This is useful.

    February 12, 2012 at 7:05 pm

    #1446084

  • RE: group by & having or ranking

    Mark-101232 (2/10/2012)

    DECLARE @t TABLE(PNumber VARCHAR(2),ReasonCode VARCHAR(2))

    INSERT INTO @t(PNumber,ReasonCode)

    SELECT 'P1', 'E1' UNION ALL

    SELECT 'P1', 'E1' UNION ALL

    --SELECT 'P1', 'D1' UNION ALL

    SELECT 'P1', 'D1' UNION ALL

    SELECT 'P1', 'D1' UNION ALL

    SELECT 'P2', 'E1'...

    February 10, 2012 at 9:28 am

    #1445657

  • RE: Cannot delete or create a column marker in Flat File(fixed length) Connection Maanger Editor;SSIS

    Bill Jones-317510 (1/20/2012)

    I have the same problem with a rather large flatfile. Did anyone get a fix for the problem of adding and moving column markers?

    I found the...

    January 22, 2012 at 6:16 am

    #1436883

  • RE: SSIS,Fixed width File,Derived Column Transformation,Error:Conversion for column 0 returned status value 4

    SJanki (10/15/2011)

    Hi

    I have a fixed width flat file having 1300 positions and 165 columns.........

    Data conversion failed, data conversion for column 0 returned status value 4 . Text was truncated or...

    October 15, 2011 at 11:14 am

    #1394976

    • Viewing 15 posts - 16 through 30 (of 63 total)