Thanks

That solved the problem. I did a restart on the server and it's working again.

Regards

Christo

Hi

I am getting the exact same error when processing my cube as well. does anyone have any advise?

Regards

Christo

Hi

Here is something that you can experiment with (NOTE: You will need a Tally table to make this work. Read this article:http://www.sqlservercentral.com/articles/TSQL/62867/ for a complete explination of it.):

--Create the tables...

I have to agree that this is very strange and it would be nice to know how it managed to happen.

Hi

Running SQL 2005 and 2008 on the same machine hasn't given me any problems but if you install Business Intelligence Development Studio from 2008 after 2005 the package depolyment wizard...

Hi David

Wouldn't it give an error if you try to drop a database that is being used by a query?

Regards

Christo

Hi

Assuming that:

1. The codes that have letters in them will only contain 1 letter.

2. The codes that contain the "-" character only contains one of them.

The following select statement should...

Hi Dave

I'd suggest that you create a secondary table that keeps track of the changes in ASX_code per company over time. The definition might look something like this:

CREATE TABLE Companies...

Thanks Mark!

This really helped me a bunch and I think it's going to help me solve some problems I have been having 😀

Hi

Would it be possible for you to change the procedure/script the you execute int the while loop to do a test and if it would generate an error rather insert...

Hi

Thanks for the posts Jeff and Gail. That is really interesting.

Hi

To assign values to variables inside a script task you must "declare" them in the ReadWriteVariables section of the "Script Task Editor" on the script tab.

To access variables but not...

Hi

Waht error message are you getting? If you can post it we might be able to help 🙂

Hi

If I understand your question correctly then the attached diagram should work.

You first need to check if vRunStage1 is TRUE before you do any thing else. If it is run...

Hi

I'm relatively new to SSIS as well and I have to agree that DTS was a lot quicker and easier.

I would however suggest that you use the SSIS Import...