From your question, I assume that this is similar to a data warehousing scenario where you have multiple dimensions and a central fact tied with relationship constraints. One thing is...

I was hoping any of the folks to put in some suggestions for my request.

Any ideas fellas?

Any sort of help would be much appreciated.

Thanks 🙂

I did a quick test as following:

1) Created a test job with a simple t-sql step and scheduled the job to run every minute.

Test:

1) Enabled Job - Enabled Schedule -...

I did a quick test as following:

1) Created a test job with a simple t-sql step and scheduled the job to run every minute.

Test:

1) Enabled Job - Enabled Schedule -...

Koen,

That was my bad. I accidently posted in the business...

Yes.

I have an excel connection manager within the package itself. I have also installed the ACE 12.0 64-bit OLE DB provider for Excel since i came to know that the...

Hi,

I don't think i am explicitly mentioning any connections in the job step. All the connections are built withint the package itself.

Yes, i have the 32-bit runtime execution option in...

This worked for me. I was getting this error when i ran the package from a job step. After removing one set of the quotes and replacing as "EXCEL 8.0;HDR=YES",...