I tried to look at your issue but the columns you posted do not match with those on the dm view, so, those values are the result of a process...

You can do a Google search on "windows 7 last logged on user registry" some hits are worth reading.

I will try to identify the package that is now taken most of the time narrowing the scope of the troubleshooting, then you can focus on the tasks that package...

Hi Azdeji

The Foreach Loop Controller is the way to go, please refer to the picture below and the following steps:

0. Add the Foreach Loop Controller[/b]

1. Add a package's variable FileName...

Hi Beginner,

I don't like the idea of updating a 'temporary table' by your procedure, even though it gets an unique name, I will suggest implementing an SSIS package taking care...

Hi Jay,

That's correct, Report Manager ask your credentials, you should be able to reach it after login, its screen looks like the one below:

If you can't get the Report Manager...

Hi Jay,

I will take you step by step.

Step 1: Check Reporting Services Configuration

1. Click on Start -> All Programs -> navigate to your Microsoft Sql Server XXXX program group ->...

Adding to Antony`s answer, you can do that with SSMS export feature.

Sorry mate, like yourself, I am in the process of learning SSIS, you may do a Google search for ssis parameters or get the book SQL Server 2008 Integration Services,...

Hi del-lee,

As you are re-installing, have you re-assigned your account to the report server roles?

Actually sqlstud,

There is a third option, setting up a package parameter taking the name of your target (dev or prd) server, then internally build the connection string that you will...

cafescott (6/5/2012)

I have a pair of SSIS newbie questions. After having spent some time trying to search for answers here I am.

I have a package with multiple tasks....

Your package will have a connection to a database containing the configuration table, if your dev and prd enviroments share this server-database you will be fine, if they do not,...

Suresh B. (6/6/2012)

Thanks for the detailed post with screen shots.

You can publish it as a blog or article. Becuase, I believe no one...

sqlstud (6/6/2012)

But i need to use it in different environments ie Dev and Test etc...

How can we pointing to different environments?

If we run the package, it should take the...