is your package saving the password? By Default it does not. You need to check the ProtectionLevel property of the package. Sensitive data, such as passwords, do not get saved.

Can...

You could join using a between clause.

Select

xxx

From

GL_Entry ENT

JOIN GL_Register REG ON REG.Entry_NO Between ENT.From_Entry_NO and ENT.From_Entry_NO

where

ENT.CreationDate = @CreationDate

Should work...

You'll have to use a script task and get the file attributes in there. Once got, you can assign them to a SSIS variable.

See google for getting file attributes in...

What type of connection are you using? Does the account Agent is running under have rights to SQL?

There should also be more to the error which is slightly more descriptive.

Can't help on the dll issue. is that dll on the server?

The first, see error output for destination and redirect error rows. See BOL for more info.

So if I understand you correctly, you have multiple facts which are actually the same barring a few columns which separate them?

if so, would using a multi cast, get distinct...

The variable handling is shaky when using variables like that. Your best bet is to LockOneForRead and assign it to an internal variable, unlock it, and use it like that.

Also,...

For the love of god people, we are not magical people who can see mystical things. If you were so kind as to letting us know what the actual error...

As a side note, there is a memory leak bug with the loop container. This might have been fixed with sp2 - I'm not sure.

if you want to limit your...

I have not used XML in earnest but yes, I cannot see it as being the most performant thing out. Not in any way comparable to relational tables.

The main reason...

As you said, there is no 64bit version of Jet.

A way to do it would be to use SSIS, under 32bit emulation, to import the info.

I don't know of a...

If you on a budget, RAID 5 is the best option for SQL.

The issue with 5 is the overhead of the parity bit being written.

Ideally, you should have a...

I have not used SSIS to push data to Oricle but pretty much sucks what you getting here. I cannot see or think of anything that is wrong.

Having a scratch...

Do you have the problem if you push to a SQL dest? What is the size of your row? Many big fields?

Some trial and error:

Create a small DF with 1000...

Did you hear the rumour about Father Christmas? Something about him not being real... Imagine!