Post reply

Data import from SQL Server in OWB

  • November 7, 2006 at 3:47 am

    #94806

    All,

    I am unable to import data from text field in SQL Server 2000 in OWB 9.2. Actually the text column is not shown in the list of columns from which data can be selected . Does anyone know how this can be accomplished ?

    Thanks in advance. 

    Rajesh      

  • November 7, 2006 at 9:35 am

    #670316

    I think you would need DTS for that move your data into temp table because a text file SQL Server sees null values so then move it from temp table to your destination table.   Try the link below for free DTS code.  Hope this helps.

    http://www.sqldts.com

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply