I figured this out.

thanks chandrashekar. i have done that. i'm stuck on the derived column part. i have a conditional split to split into those records that are 100%, some that are errored...

yes, it is coming in as a csv file and being loaded to a table that has all varchar data types. i need to join this table with another and...

that is how we're receiving the data as text. and, need to use ssis to convert this data to proper data type and transform with these scenarios to load to...

i am trying to use XML task editor with these options:

operation type = XSLT

SaveOperationresult = true

second operand type = direct input

second operand =

<xsl:stylesheet version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output match="text" />

<xsl:variable...

this is fine. thank you for all your help lynn and Cadavre!

sorry...

expected result set should be...

Account# RepCode[pr] RepCode[cu]

-------------------- ----------- -----------

12345677 ...

Cadavre,

I didnt realize the data was doing this until i saw it. Maybe this will help you.

CREATE TABLE #Account ([Account#] BIGINT, RepCode CHAR(4))

INSERT INTO #Account

SELECT 12345678, 'XX01'

CREATE TABLE #Accountdim ([Account#]...

Lynn,

this is correct! please advise.

Hi Cadavre,

Thanks for helping with this request. What you have is almost exactly what i want. However, what i found that a lot of the accounts have last two rows...

Hey Lynn,

The post by 'Cadavre' is what i'm trying to do... i did put my query and i can see it... but i'm not sure if you can see it...

i have this query... need help combining into one.

select max(currentdate) as currentdate

, d.accountnumber

, d.repcode as PreviousRepCode

into #tempdim

from tblaccountdim d

where d.currentdate > '2009-01-01'

and ( left(d.repcode ,1) not in...

this is the result i want.

Account# RepCode[pr] RepCode[cu] CurrentDate

12345678 PP21 XX01

12345677 TY00 XAB0

12345679 LM01 Z001

i want account# from tblAccount, Previous second last rep code from tblaccountdim, current repcode from...

sorry. i was in the process of putting my thoughts together so i can show you what i meant in the comments...

i know i missed to include this, but i...

This is not bringing back expected result or the expected row count back.