Hello,

I am developng and debugging on my PC.

The package has not been deployed anywhere as yet.

The file exists on my PC.

Hi,

Thats the solution... thankyou.

thanks guys.

I will look into those options.

Doing a three day course on SSIS in a few weeks, hopefully they will cover stuff like that.

Hi,

I think you will find that from within the SSIS studio you may only debug.

Packages are executed upon the sql server.

I don't think its the same as developing programming language...

Hi,

I was more interested in discovering if a function or stored procedure was the best approach considering i need to sue both 2000 and 2005 🙂 (Assuming a relational...

Hi,

that just sucks.....

think i will tell the users its not possible, and they'll have to wait until the test server upgrade.

Hi,

Thanks for assitance.

Unfortunatley I am not responsible for what software is installed on the server, so Reporting Services is a no-go.

Incidently, can reporting services be run a clustered 64 bit...

Hi,

Reporting Services not installed.

The query returns lots or rows, (695). I assume these aren't all unused? Which of the columns do you suppose says categorically that the index is unused?

something very wrong with the way this topic is displayed.

Centre aligned... words at the end of lines are cut off....

Hi,

Check that your user account has permissions withing the MSDB account on the SSIS ( DTS ) roles.

Hi,

Permissions were the first thing I thought of... But wouldn't it be the case that if I can see whats in the table with my accont, i should be able...

thanks for all replies.......

Hi,

So what you are saying is, I DO need access to the file system on the server?

When running the 'Package Installation Wizard' on the 'Select Installation Folder' page, I can...

Hi,

I combined date and time together : Format([Date] & ' ' & [tbl_history].[Time],'dd-mmm-yyyy hh:nn')

thanks, will give it a look.