Getting Started with Adobe After Effects - Part 6: Motion Blur
Ask
Ask questions, discuss or help others by answering
Related Posts · View All
SQL Server 141
TSQL 75
SSRS 70
SSIS 66
XML 54

Top Categories · View All
SQL Server 141
TSQL 75
SSRS 70
SSIS 66
XML 54

Convert query into SSIS

Apr 30 2012 12:00AM by Anil   

Dear, please convert into SSIS
REPLICATE('0',16-len(CONVERT(VARCHAR,@TERMINALID))) + CONVERT(VARCHAR,@TERMINALID)

my input: 12345 Expected Output: 0000000000012345

Submitted under: Microsoft SQL Server · SSIS - SQL Server Integration Services ·  ·  · 


Anil
274 · 0% · 156

2 Replies

  • Use below expression in derived column (if used)...

    REPLICATE("0",16 - LEN([Column0])) + [Column0]
    

    here,change "Column0" with your column name.

    commented on May 1 2012 5:34AM
    Alpesh Gorasia
    128 · 1% · 392
  • Hi Sandeep, i have another problem My source : Flat files Target : Sybase and datatype is Numeric(20,3)

    i cant do this calculation in SSIS
    ((dt_numeric,20,3)SUBSTRING(STRING,44,11)) / 1000 when running SSIS job, am getting this error: [ADO NET Destination [1057]] Error: An exception has occurred during data insertion, the message returned from the provider is: [ZZZZZ] [Message Class: 16] [Message State: 1] [Transaction State: 0] [Server Name: imalrep] [Native Code: 245] [ASEOLEDB]Domain error during implicit conversion of NUMERIC value '' to a NUMERIC field. [ZZZZZ] [Message Class: 10] [Message State: 0] [Transaction State: 3] [Server Name: imalrep] [Native Code: 3622] [ASEOLEDB]Domain error occurred.

    commented on May 1 2012 7:30AM
    Anil
    274 · 0% · 156

Your Reply


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]