Yeah you can still use DTS in 2008, but I would recommend against it and re-write your DTS into SSIS as DTS has been depreciated since the release of SQL2005...

Sorry Wendy do you mean the deploy option within BIDS?

Personally I group tasks in order of acheving the overall goal. So for example, if one goal is to copy 100 tables from ServerA to ServerB, I would class...

There is the execution log view which is in the reportserver database which stores the marjority of this information. The only thing it doesnt do is if they logged...

Following on from Jared's script, this is the script that I use as it shows me the parameter values as well as the parts of the subscription I need to...

The solution is the root element of the overall SSIS file structure which is determined by the .SLN file extension, which is usually in the root of the directory. ...

Is this in one particular DB or is it multiple DB's and server level rights?

The four main tables for DB permissions would be a join on these from within the...

reidres (5/15/2012)

---

And I am unclear as to why the three temp tables response would be offered, first because there are three and not one, and second because I thought that...

Sorry I finish work at 4 UK time and dont have time on the forums due to family committments.

Yes you will create them in computer manager

Unsure on the passwords part,...

Thanks for the heads up Gail, much appreciated as always.

Thanks Gail, I'm sitting the ITP for administration in 2 weeks. I was going to go for the MCSE Data Platform so will need to get up to speed...

Well thats the bit I am struggling with, as I thought of adding an extra chart area which is of a line chart type which does an average on the...

No, not to worry, I'm in the same boat at the moment where we are designing a internet facing SSRS solution for our new SaaS product which is in development...

Sure, there are plenty out there on Google, but this is the one I use, you may find a better one in the searches depending what you actually want to...

You will need to create a number of windows accounts in computer manager, then grant them the nessesary access they need in SQL, then grant them the nessesary access the...