We stage our tables there.

The ETL proces can be divided in 3 steps:

1. Import: here you gather your data from various sources (Excel files, other databases et cetera) --> the...

Oh, you're making me blush 😀

Most questions in these forums are the other way around 😀

Did you change anything in the package? For example, set the OLE DB Destination to fast load or something like...

Paul_Harvey (4/20/2010)

---

Thanks very much! My package now executes immediately, rather than pausing before it starts. There is still a minor 10 second pause between packages, but this is...

It can potentially prevent the entire package from running, if you use only one precedence constraint.

However, more than one precedence constraint can depart from a single task. If you use...

Is this what you're looking for?

In BIDS, select Database -> Generate Relational Schema...

Et voila, you've solved your own question 🙂

Use the expressions on...

In the package properties, under Execution, set DelayValidation to True.

I'm not sure how much time this will save, so just try it out and let us know 🙂

If you want to store SSIS packages in the MSDB folder from BIDS, install BIDS helper. It is free and extremely useful.

Then you can deploy packages to MSDB with two...

And the award for the Shortest answer ever that was also actually helpful goes to...

😀

Tables in a database will do. If needed, some primary keys, foreign keys and indexes on those tables.

Do you have more specific questions?

You could try the following expression:

@[User::vRootFolder] + "\\" + @[System::PackageName] + ".dtsx"

EDIT:

Forget about this suggestion, I forget that you were trying to call the subpackages from a master package. @[System::PackageName]...

Regardless of the fact that is the wrong forum and topic, an answer to your question:

the datatype datetime is used to store AND the date portion AND the time portion.

You...

I interprete it as:

SCOPE_IDENTITY returns the value of the last identity value inserted in the same scope. Since the scope is the whole batch, it doesn't matter if the identity...

nigel. (4/19/2010)

---

/* lots of quoting here */

I don't think so. The SCOPE_IDENTITY (or @@IDENTITY) function will return the value appropriate to the most recent INSERT statement whether that statement affects...