Forum Replies Created

Viewing 15 posts - 1 through 15 (of 23 total)

  • RE: Error code: 0x80040E21.

    Someone posted this answer in previous post on your error.

    Here's below answer.

    Hi the below steps might help to solve issue more quickly.

    1.Use the OLE DB Destination.

    2.Use the "Table or...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    June 19, 2014 at 3:11 pm

    #1723426

  • RE: Can some one confirm that - It is possible to find table size and in that table each row size.

    SELECT

    t.NAME AS TableName,

    s.Name AS SchemaName,

    p.rows AS RowCounts,

    SUM(a.total_pages) * 8 AS TotalSpaceKB,

    ...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    June 10, 2014 at 10:15 am

    #1720494

  • RE: SSIS Strange error when running as SQL Agent

    As with My data I created one file and table Here I am attaching both.

    If you create package and It will throw you error at row 2.

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    June 4, 2014 at 2:51 pm

    #1719020

  • RE: SSIS Strange error when running as SQL Agent

    Yes It will convert it to 0. But I had the same issue and I used derive column with above expression and converted empty space into NULL and then I...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    June 4, 2014 at 2:29 pm

    #1719002

  • RE: SSIS Strange error when running as SQL Agent

    The column after "A" is "" that means it's empty so SSIS takes empty space as string.

    You are getting error because your destination column is Integer.

    You need to...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    June 4, 2014 at 2:12 pm

    #1718993

  • RE: SSIS Strange error when running as SQL Agent

    This error you are getting has lots of possibilities. Is your file has text qualifier??

    If yes then you might have " " empty space in between and your destination column...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    June 4, 2014 at 2:07 pm

    #1718992

  • RE: Null values in Text Qualifier Error Issue

    I found out the problem.

    In my destination database that empty space in column is int. so SSIS can't take empty space in " " as int. thats why I...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 28, 2014 at 8:10 am

    #1717029

  • RE: Null values in Text Qualifier Error Issue

    I am getting error at flat file connection.

    [FF_SRC - Raw Data File [27]] Error: Data conversion failed. The data conversion for column "Time-UTC-Sec" returned status value 2 and status...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 27, 2014 at 1:11 pm

    #1716831

  • RE: Datetime conversion

    select convert(char(20),cast('1/1/2010 8:30 PM' as datetime),120)

    Result: 2010-01-01 20:30:00

    I can use this query in SSMS but I dont know how to use this query in SSIS.Which convert AM/PM format in...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 23, 2014 at 7:42 am

    #1716058

  • RE: Datetime conversion

    Thanks Sean for your reply.

    the raw files which has columns CreationDate, StartDate and EndDate are by default in string. Which has format 1/1/2010 12:00:00 PM.

    Now I want to...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 23, 2014 at 7:40 am

    #1716057

  • RE: String or binary data would be truncated.

    Actually in my case I had Data Dictionary. So I used to get all data types from there. so

    Cause At my work We were loading first client data to...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 16, 2014 at 1:33 pm

    #1714326

  • RE: String or binary data would be truncated.

    Here is the script to copy table structure from temp to target.

    CREATE TABLE TagetTableName

    AS

    SELECT TOP 0 * FROM TempTableName.

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 16, 2014 at 1:05 pm

    #1714319

  • RE: String or binary data would be truncated.

    This error you are getting because your target table has column length different than the temp table.

    Make sure you have target table structure same as temp table.

    I used...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 16, 2014 at 1:03 pm

    #1714316

  • RE: Using CTAS create stored Procedure for Client

    If any way I can create variable in SSIS and change table name???

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 15, 2014 at 1:12 pm

    #1714011

  • RE: Using CTAS create stored Procedure for Client

    The reason is that data coming that are very large more than billions of records for each client.

    So I can't put it in same table.

    I created SSIS packsges which...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 14, 2014 at 1:02 pm

    #1713585

Viewing 15 posts - 1 through 15 (of 23 total)