Forum Replies Created

Viewing 15 posts - 421 through 435 (of 544 total)

  • RE: SQL Server 2008 Client Import Export Wizard

    Revenant (1/6/2012)

    Please note that the native TIMESTAMP is not a DATETIME type.

    i agree with you..i hope she is not using Timestamp for datetime

    January 6, 2012 at 2:02 am

    #1429480

  • RE: SQL Server 2008 Client Import Export Wizard

    nazareena.sulthana (1/5/2012)

    Hi

    Thanks for the response i have solved that issue by modifying the related Mapping file (data type DT_DBTIMESTAMP for that 135 datatype mapping).

    But after that also when i...

    January 6, 2012 at 1:06 am

    #1429468

  • RE: Pass Result of Stored Procedure to SSIS Variable

    Triality (1/4/2012)

    The stored procedure selects it.

    in the Result Set , add the variable which you want to store the sp value and put 0 in the result name only if...

    January 5, 2012 at 5:01 am

    #1428909

  • RE: SQL Server 2008 Client Import Export Wizard

    nazareena.sulthana (1/4/2012)

    SQL Server 2008 Client Import Export Wizard

    for timestamp field iam getting error in the conversion in the source data type it shows 135. please help me on this

    this is...

    January 5, 2012 at 4:57 am

    #1428906

  • RE: Trying SQL Server Import and Export Wizard

    nazareena.sulthana (1/5/2012)

    Trying SQL Server Import and Export Wizard iam getting this error

    Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [SCHSPEC].[CDI_MBS] (

    [CDI_NAME] VAR..." failed with the following error:...

    January 5, 2012 at 4:54 am

    #1428904

  • RE: pass database name through a variable?

    John Mitchell-245523 (1/4/2012)

    That won't work. Why do you want to build your SQL statement dynamically? It's the same statement you're going to execute no matter what environment you're...

    January 4, 2012 at 4:23 am

    #1428171

  • RE: pass database name through a variable?

    John Mitchell-245523 (1/4/2012)

    Well, if you don't know the database name, you're stuck. Can you not just ask the owner of the server? Once you find out the name...

    January 4, 2012 at 4:09 am

    #1428165

  • RE: pass database name through a variable?

    John Mitchell-245523 (1/4/2012)

    How is the database name determined? If you're always passing in the same name, that doesn't sound very dynamic. Maybe what you need is to use...

    January 4, 2012 at 3:51 am

    #1428160

  • RE: How to split the Records?

    Koen Verbeeck (12/20/2011)

    Charmer (12/20/2011)

    Hi Friends ,

    i have column name CrossStreets in an excel sheet which will be having datas like "W MENOMONEE RIVER PKWY"....

    i need to split the records into...

    December 20, 2011 at 6:32 am

    #1423606

  • RE: How to split the Records?

    Henrico Bekker (12/20/2011)

    Charmer (12/20/2011)

    Henrico Bekker (12/20/2011)

    Text to Columns.

    in the menu under "Data", "Text to Columns"

    sorry i gave a wrong information...my source is .mdb....

    MS ACCESS?

    yes pal...

    December 20, 2011 at 3:20 am

    #1423518

  • RE: How to split the Records?

    Henrico Bekker (12/20/2011)

    Text to Columns.

    in the menu under "Data", "Text to Columns"

    sorry i gave a wrong information...my source is .mdb....

    December 20, 2011 at 2:27 am

    #1423494

  • RE: how to create a Log Files...?

    herladygeekedness (12/13/2011)

    I get lost when you are talking about executing on a client pc. All of our SSIS packages execute at server level. Are you creating a client...

    December 13, 2011 at 7:42 am

    #1420611

  • RE: how to create a Log Files...?

    Koen Verbeeck (12/13/2011)

    It is the only way.

    You redirect all the rows that generate an error to an output. Include the ErrorCode and the ErrorColumn with it and with some scripting,...

    December 13, 2011 at 7:01 am

    #1420586

  • RE: how to create a Log Files...?

    Koen Verbeeck (12/13/2011)

    But you will be developing the package itself, right?

    then we need to redirect row for each and every column right..? because i am not aware of data's i...

    December 13, 2011 at 6:36 am

    #1420575

  • RE: how to create a Log Files...?

    Koen Verbeeck (12/13/2011)

    Charmer (12/13/2011)

    Koen Verbeeck (12/13/2011)

    Read this article, it has pictures, maybe that helps.

    http://msdn.microsoft.com/en-us/library/ms141679.aspx

    i understood that you fell sick of me...that's why you mentioned like "it has pictures"...sorry buddy...i have...

    December 13, 2011 at 6:24 am

    #1420565

Viewing 15 posts - 421 through 435 (of 544 total)