Viewing 5 posts - 1 through 5 (of 5 total)
Problem solved with the below code and adding (as col1) where highlighted..
--File 2 OPTION.txt
SELECT DISTINCT
B12.MODLN_USC_C + ';' +
LEFT(ENT_ENTITY_C, 1) +
SUBSTRING(ENT_ENTITY_C, 3, 1) +
SUBSTRING(ENT_ENTITY_C, 6, 1) +
SUBSTRING(ENT_ENTITY_C, 4,...
January 28, 2011 at 4:31 am
Problem fixed using the below code and adding the as col1 highlighted
--File 2 OPTION.txt
SELECT DISTINCT
B12.MODLN_USC_C + ';' +
LEFT(ENT_ENTITY_C, 1) +
SUBSTRING(ENT_ENTITY_C, 3, 1) +
SUBSTRING(ENT_ENTITY_C, 6, 1) +
SUBSTRING(ENT_ENTITY_C, 4,...
January 28, 2011 at 4:18 am
I get the "Error at Data Flow Task [OLE DB Source [1]]: There is a data source column with no name. Each data source column must have a name.
Exception from...
January 28, 2011 at 2:27 am
I have the below query in a data flow and cannot get it to work no matter what I do
SELECT DISTINCT
B12.MODLN_USC_C + ';' +
LEFT(ENT_ENTITY_C, 1) +
SUBSTRING(ENT_ENTITY_C, 3, 1) +...
January 27, 2011 at 6:26 am
its ok I solved with the below for anyone that was interested.. 🙂
SELECT BRANDNAME,MODELNAME,VIEWCARNAME,SOURCENAME,VIDEOCARID,MODELFILE,PUBPATHACTIVE,PUBPATHINTERNETSMALL,PUBPATHINTRANETSMALL
FROM AUTOMOTION,SOURCE,BRAND,MODEL,VIEWCAR LEFT JOIN VIEWPIC
ON VIEWPIC.CARID = VIEWCAR.VIEWCARID
AND (VIEWPIC.MODELVIEW2 = 24 OR VIEWPIC.MODELVIEW2 =...
August 18, 2009 at 2:55 am
Viewing 5 posts - 1 through 5 (of 5 total)