IF gv_configCOBDate = '000-00-00' THEN 

    DTSGlobalVariables.Parent.Steps("DTSStep_DTSDataPumpTask_1").ExecutionStatus = DTSStepExecStat_Waiting

ELSE

 DTSGlobalVariables.Parent.Steps("DTSStep_DTSDataPumpTask_2").ExecutionStatus =   DTSStepExecStat_Waiting

END IF

It seems okay - is there a unique custcode for each customerkey?

create table customer

(

customerkey int,

ccustcode varchar(3)

)

go

create table subcust

(

customerkey int,

custcode varchar(3)

)

go

insert into customer values(1, 'A')

go

insert into customer values(2, 'B')

go

insert into customer...

Ditto from me!  Thanks for being here!

It appears to be due to using an input variable in the same exec sql that creates an output variable. 

Here is one way to get around it:

1 - run ExecSQL...

You can use the File System Object in an ActiveX script to loop through all files in a folder.  You can capture the file names and assign them to global...

I do this for several online reports.  ASP calls a sproc that has a select query as output.

Here are couple of hints:

If a field could be null, replace it with...

Use a derived table:

select a.f1, a.f2

from myTable a

inner join

(select f1 from myOtherTable)myDerivedTable

on a.f1 = myDerivedTable.f1

Hi Eva,

Sounds like this script is actually being executed twice - cuz if you update twice you see one update.  If you insert twice, you see two inserts.  Stick a...

Jeff, this is awesome!  I have created a sproc from this to share with my team - really good stuff!

SELECT RF_ID INTO #t1

FROM RF_INDEX

is not a valid transformation statement, but select myID from myTable is - see the diff?  You cannot use an insert statement - that is...

If you are on the same connection, don't forget about your handy-dandy derived tables:

SELECT * FROM tblOne INNER JOIN

(

SELECT RF_ID

FROM tblTwo

)

tblThree

ON tblThree.RF_ID = tblOne .RF_ID

Try separating the selects into two separate transformations.  They need to go in opposite directions.  You'll need a real table since you are going from one connection to another.  If...

Well, ideally the person responsible for providing you with the CSV should be asked to clean it up.  It's really a piece of junk.  But if you are stuck, clean...

Ah hah.  Maybe those are really sets of single quotes indicating empty strings?  That gives you ten valid fields.  Turn off all string delimiters and try it.  You don't need...

You just need to specify " as your string delimiter.