General speaking, the relationship between dim and fact is the dimkey. If your dim has start_date and end_date then yes your fact table should reference the dimkey.

Building UDM database(STAR) best...

run as stored proc.

No you can't, you can only run it as VB code.

you don't have to ....choose one..

select a.name

     , actual = sum(ta.amount)

     , budget = sum(tb.amount)

from Account a

   , SubAccount sa

   , Trans ta, Trans tb

where a.AccountNum = sa.AccountNum

and sa.SubAccountNum =...

nope.

your global variable will 'always' be initilised to the value that you last saved your package.

You may want to save the value into tmp table/file and upload to global vairable everytime...

if you can run your reporting services reports as a batch file, thens use Execute Process Task to call the batch file.

how did you excute on sqlAgent?

your problem is, from source table your RECID(or row_id) column is defined as NULL but your destination table RECID is  not NULL.

The means that some of the records in source table have NULL value...

assuming you have fixed number of files, otherwise you probably have to play activeX to connections.

1. Create an ini file and use dynamic properties task to initialize the file name.

eg....

try DDQ - data driven query task.

sleeping - waiting on disk I/O or some other resource, also means that process is running extensive disk I/O. Also indicates if connection is made to the database and doing nothing...

sleeping - waiting on disk I/O or some other resource, also means that process is running extensive disk I/O. Also indicates if connection is made to the database and doing nothing...

someone had posted once, either bounce the server or create a local instance on the server.

this sounds stupid....you may want to check line 93 in your text file to see any different from other lines.

are you able to post your text file and dll?