Thanks for the response, I may even call back the HR recruiter and ask if this is written or verbal. Because I think if it is written I do...

scratch this...we had MOM and Sharepoint on one server. It is MOM that needed Report Server...hey it's monday!

Have a good weekend...going to digest this...the script has potential because I will have to massage and add more rows later, the down and dirty of adjusting the source file...

To all last question and then I will let you enjoy the weekend.

RowNumber() can this SQL 2005 function be used on a database with 80 compatibility? (2005 SP2 applied)

The staging area is the table it is going to...bad ERP desgin what can I say.

So my raw source goes to project_jrnl_load_trans and then the process moves it to the...

Hi Jack,

Ok I am getting this thanks..one more question my script if I gloss over it states 'journal_line_nbr is not a member of 'ScriptComponent_....'

To answer your question, why not...

Jack/Matt,

I really do appreciate this, I am understanding how this works I have two questions:

1. Do I need to create a blank column in Derived column task for the journal...

Just want to clear this up as i am still learning SSIS.

So after my Derived Column transformation task I want to connect a script component transformation task?

The code you provide...

Hi Jack,

My source is an Excel file going into a SQL 2005 table. So will the variable function still work?

Sure run DBCC SHOWCONTIG

Pages Scanned tells you the page count

Jeff,

That's it, I was ignoring the page count...these are all small tables well under 1000, testing out the new SQL Admin tool from Idera on Quick Reindex and saw this...thanks

Never mind found it under MS Tech Net

Again thanks...Built-in Admin are not part of our security user IDs (and never have) most is locked down

I have changed sa but really what is stopping the person from going...

I always document to the hilt, now getting the CFO involved..that's funny..considering in the place I work we report directly under the CFO (we have no CIO) and thus our...

Thanks again to all...

On most of these items especially creating triggers, that project alone could take me over 3 months to do and plus most of our software is vendor...