Ok...

So these are the first two tasks in SSIS.

First runs the insert to the 'META' table.

Second task inserts the records into the 'Primary_Import' table.

The way I wanted this to work...

No.. that is stored in table2

table1:

Name

Addy

Ph.

table2

RunDateTime

The package writes a new timestamp in table2 everytime its fired off, showing the begin time of the package (the update to table1).

Thanks guys.... i worked it out... now, if i were to turn the select into an insert statement?

with basedata (

name,

addy,

...

ok.... i got it... the object referenced at the end is the basedata. so looking at the result set, i see all of the values.... but that leaves me with...

Okay... i read through them, and have a point or two of confusion. In my example above, my source has 'grade1', 'grade2', etc.... however it seems that she is referencing...

Thanks! I understand the unions and can see how it puts it together in a serial fashion, not sure on the 'with basedata' portion though.... could you elaborate on that...

Well, I need a somewhat more intuitive naming convention. I didn't realize this would be an issue with the name.

On a standalone system, is this also the case? With multiple...

Awesome!! Thanks Perry!

Just for the SQL portion.... for example, when loggin into SSMS:

Former:

HQSQL05/INST1

HQSQL05a/INST2

To:

HQSQL05IN1/INST1

HQSQL05IN2/INST2

Dan

The trigger will copy the value from the ModifiedBy column and place it in the AppUser variable so the query (being built towards the bottome) can insert it into the...

I don't disagree, but that would be a bit above what I could get up and running in a short amount of time. I'm relatively new to this kind of...

Its just that part that complains. It's the piece that pulls the users name from the username table, to insert it into the query string below.

Sure...

On that newly created table, there are two columns. One is ModifiedBy and one is ModifiedDate (along with all the form fields). Once the table is created, which is...

It did, Todd, but then it affected another portion.... This piece is the last part of what I need to get the current app user from a table.... i guess...

Thanks Gila ...

How do I get around that? I have to be able to pass in the correct table that is being processed.. 🙁