My SqlComand on SSIS - DataFlow OLE DB Command seems not works

Posted by Angel Escobedo on Stack Overflow See other posts from Stack Overflow or by Angel Escobedo
Published on 2009-09-17T15:22:18Z Indexed on 2010/04/08 8:03 UTC
Read the original article Hit count: 510

Filed under:

Hello Im using OLE DB Source for get rows from a dBase IV file and it works, then I split the data and perform a group by with aggregate component. So I obtain a row with two columns with "null" value :

CompanyID | CompanyName |  SubTotal  |    Tax      | TotalRevenue 
   Null        Null         145487      27642.53      173129.53

this success because all rows have been grouped with out taking care about the firsts columns and just Summing the valuable columns, so I need to change that null for default values as CompanyID = "100000000" and CompanyName = "Others". I try use SqlCommand on a OLE DB Command Component :

SELECT "10000000" AS RUCCLI , "Otros - Varios" AS RAZCLI FROM RGVCAFAC 

<property id="1505" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="Notify">SELECT "10000000" AS RUCCLI , "Otros - Varios" AS RAZCLI FROM RGVCAFAC</property>

but nothings happens, why? and finally the task finish when the data is inserted on a SQL Server Table.

Im using the same connection manager on extracting data and transform. (View Code)

<DTS:Property DTS:Name="ConnectionString">Data Source=C:\CONTA\Resocen\Agosto\;Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Extended Properties=dBASE IV;</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>

alt text

all work is on memory, Im not using cache manager connections

© Stack Overflow or respective owner

Related posts about ssis