Yeah you can do this. Create OnError Event handler. There you can see the propert "Propogate". Set this value to True. So whatever tasks present in OnError are executed followed...

there was a view which is written as "select top 1 cast(... as datetime)...", which is querying on the table for which data is inserted with file.

When i actually looked...

The System::PackageName variable gives me the name of the Package. But my requirement is to get the container name.

For eg:, I have a script task followed by execute sql...

Hi John/Sharath

Thank you for your suggestion. I too was thinking the same one..

The main need for doing this is, I'm doing logging for my package. I have divided my package...

Did u get to know what the problem was? Is it fixed?? Pls. let us know as I'm also facing a similar problem..

Although the server is having mixed authentication mode, Builtin\Administrators are not part of server admins.We forgot the sql authentication password. So I'm trying to start the box is single user...

No its not on cluster. I stopped the Agent as well.

Are you still looking out the answer for this.?

Below is a sample query to join two tables present in two different databases of the same server.

select a.* from DB1.dbo.[Table] a

inner...

Is a new tab not opening at all? Or is the link not working? If new tab is opening check the link in the url space.

When you move your mouse...

Give the link as /*http://www.google.com*/ instead of /*www.google.com.*/

In this scenario, start the SQL server in single user mode. When server starts in single user mode, all the builit admins of the machine will be the admins of...

http://www.sqlservercentral.com/Forums/Topic375915-146-1.aspx

i hope this wud be helpful in clarifying all your doubts..

I was asked this question in the interview of Microsoft..

So i was looking out the answer...

I could able to rebuild the system databases in SQL 2008 and later restored the databases with the back up taken earlier. I have rebuilt the databases using the below...

I've tried starting SQL Server with the options -m as well as with -f. But i got the error message couldn't find the path. The main problem which I've done...