What type of connection are you using?

I got this error a couple of days ago on my daily data warehouse load. I just re-ran the load, it worked and it hasn't failed since.

I am pretty sure this...

A foreign key constraint is a relationship between tables to enforce data integrity. It basically checks for the existence of a key in one table before allowing the record in the...

Is your linked server an Excel file??

When you expand the linked server under Security in Enterprise Manager can you see a list of tables when you click on Tables ?

Daniel

Hi,

I had a similar requirement for incrementally loading data into our DW and this is how I did it.

To do this you will need a global variable and a dynamic...

Your problem is that the UDF is only available through a SQL Server connection. I think you have two options.

1. Re-write the UDF as a vbscript function and then paste this function into all...

Hi Dan,

Debugging VB script in DTS is a next to impossible and the documentation isn't great. That said, here is a link to the DTS programming reference which should help.

If there are no dependencies between the packages then it would be easiest to remove the package that runs only between Tuesday and Saturday from the master package and schedule...

You could start by reading some of the information on this site.

http://www.kimballgroup.com/

Good luck!!!!!

Is the KEEPNULLS option suitable?

Daniel

I've not come across this berfore. Try using a dynamic properties task to set the batch file location from a global variable each time the package runs.

Daniel

Try This.

Select

FK_Book,

Category

From

#BookCategory

Where

FK_Book

Not In (Select