eschrepel,

I tried all the steps one by one and it still doesn't work. I even re-booted the system.

Not yet. This is on a dev box running Win server 2003. Let me know if you get any clues or answers.

Thanks,

John

it still won't work.

I enabled named pipes thru sql server ent. mgr. I re-booted. I tried using all three possible accts from the drop down menu: Local system;...

Great!. thx.

I see. cool!! It pointed to the single quotes around the '@'. In t-sql, we use single ' ticks, but I guess in ssis we gotta use double "...

I thought of it already, but I do not own that network share; it's owned by the Exchange server admin b/c these are logs generated by email blasts.

I created the For Each Loop w/Enumerator, but in order for it to look in the directory and grab every CSV file and dump it into a SQL table, I...

Figured it out.

I have to set my field as decimal, then I have to cast the value/field I'm multiplying to float, then multiply by the decimal value and that does...

See the code below:

Selectb.FullName,

a.LANLogin,

b.HireDate,

[Status]= b.Active,

b.Supervisor,

[Month]= a.RecMonth,

Period= a.RecPeriod,

b.[Site],

b.Department,

QA_CE= Isnull(c.QA_CE,0),

PTS_QA_CE= Null,

NoOfScans= Isnull(c.NoOfScans,0),

Consistency= Isnull(c.Consistency,0),

PTS_Consistency = Null,

JobKnowledge = Isnull(d.Grade,0),

PTS_JobKnwldg = Null,

Total= Null

Into#AllTables

From#Period a

InnerJoin

#Employees b

Ona.LANLogin = b.LANLogin

LeftJoin

#CactiData c

Ona.LANLogin = c.CactiAgentId

Anda.RecPeriod = c.RecPeriod

LeftJoin

#Moodle1 d

Ona.LANLogin = d.UserId

Anda.RecPeriod...

Will do. Awesome information.

thx,

I thought the case explanation and attachement were enough to explain, but in any way, it turns out the solution stake owner actually wants to see only the latest two...

I've added an Excel worksheet w/ one record as a sample. It has 2 revision versions. Notice that a single product may have many RM's. They may change, they may...

That's It, Oleg.

Thanks

I've got another challenge, but the opposite way now:

I've gotta import some old outsourced data into our own housed tables, but the values for timestart and timeend are as ...

You're right, the EndDate value was a typo...my bad. I'm implementing your second suggestion b/c it may carry to the next day, however, if the diff is 24 hours...