Activex script - DTSGlobalVariables.Parent - error

Hi,

I migratedDTS From sql server 2000 to 2005 .

But i have problemes with the ativex :

Error: 0xC0048006 at Loop action, ActiveX Script Task: Retrieving the file name for a component failed with error code 0x000F5544.

In DTS ActiveX scripting it was common to get a reference to the package itself using the following line of code:

Dim package = DTSGlobalVariables.Parent

This was used to navigate over the DTS object model , to loop.

Someone can help me to know haw I can do the same thing with the SSIS.

Regards,

chaf wrote:

Hi,

I migrated DTS From sql server 2000 to 2005 .

But i have problemes with the ativex :

Error: 0xC0048006 at Loop action, ActiveX Script Task: Retrieving the file name for a component failed with error code 0x000F5544.

In DTS ActiveX scripting it was common to get a reference to the package itself using the following line of code:

Dim package = DTSGlobalVariables.Parent

This was used to navigate over the DTS object model , to loop.

Someone can help me to know haw I can do the same thing with the SSIS.

Regards,

You should take a look at these links. They will help you:

Get a reference, within a script, to the package using DTSGlobalVariables.Parent
(http://blogs.conchango.com/jamiethomson/archive/2006/07/26/4278.aspx)

Modifing a Package in script
(http://blogs.conchango.com/jamiethomson/archive/2006/06/28/4156.aspx)

-Jamie

Action tracking

Hi,
We have a table that holds thousands of data in SQL server. However, the
data is suddently gone yesterday. I am just wondering if there is a way to
check when and how (who did) the data is gone. Can we track the action from
log files or somewhere?
Thanks in advance!
if you have the database at FULL recovery, download a trial version of Log
Explorer at lumigent.com. It will tell you who's who?
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:86B01DE6-8302-4C6D-9D63-8FFF7D24AB74@.microsoft.com...
> Hi,
> We have a table that holds thousands of data in SQL server. However, the
> data is suddently gone yesterday. I am just wondering if there is a way to
> check when and how (who did) the data is gone. Can we track the action
> from
> log files or somewhere?
> Thanks in advance!
|||Unfortunately, our database is Simple for recovery model. Is there any other
way to find it?
Thanks again!
"ME" wrote:

> if you have the database at FULL recovery, download a trial version of Log
> Explorer at lumigent.com. It will tell you who's who?
> "Jean" <Jean@.discussions.microsoft.com> wrote in message
> news:86B01DE6-8302-4C6D-9D63-8FFF7D24AB74@.microsoft.com...
>
>
|||:-(
why was it set at SIMPLE recovery if you need that much?
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:A7AD9D50-59E2-4B15-A03A-2399645BCC2E@.microsoft.com...[vbcol=seagreen]
> Unfortunately, our database is Simple for recovery model. Is there any
> other
> way to find it?
> Thanks again!
> "ME" wrote:

Action tracking

Hi,
We have a table that holds thousands of data in SQL server. However, the
data is suddently gone yesterday. I am just wondering if there is a way to
check when and how (who did) the data is gone. Can we track the action from
log files or somewhere?
Thanks in advance!if you have the database at FULL recovery, download a trial version of Log
Explorer at lumigent.com. It will tell you who's who?
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:86B01DE6-8302-4C6D-9D63-8FFF7D24AB74@.microsoft.com...
> Hi,
> We have a table that holds thousands of data in SQL server. However, the
> data is suddently gone yesterday. I am just wondering if there is a way to
> check when and how (who did) the data is gone. Can we track the action
> from
> log files or somewhere?
> Thanks in advance!|||Unfortunately, our database is Simple for recovery model. Is there any other
way to find it?
Thanks again!
"ME" wrote:
> if you have the database at FULL recovery, download a trial version of Log
> Explorer at lumigent.com. It will tell you who's who?
> "Jean" <Jean@.discussions.microsoft.com> wrote in message
> news:86B01DE6-8302-4C6D-9D63-8FFF7D24AB74@.microsoft.com...
> > Hi,
> >
> > We have a table that holds thousands of data in SQL server. However, the
> > data is suddently gone yesterday. I am just wondering if there is a way to
> > check when and how (who did) the data is gone. Can we track the action
> > from
> > log files or somewhere?
> >
> > Thanks in advance!
>
>|||Unless you are either running a trace, have c2 auditing,
have some trigger mechanism to sort who did what and when,
or have the utility ME sugested then no.
If I were you I would really see about tightening up
security as you either have a hacker or an inexperienced
user / developer.
Do you have back ups ?
Peter
"Happiness is having a large, loving, caring, close-knit
family in another city."
George Burns
>--Original Message--
>Hi,
>We have a table that holds thousands of data in SQL
server. However, the
>data is suddently gone yesterday. I am just wondering if
there is a way to
>check when and how (who did) the data is gone. Can we
track the action from
>log files or somewhere?
>Thanks in advance!
>.
>|||:-(
why was it set at SIMPLE recovery if you need that much?
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:A7AD9D50-59E2-4B15-A03A-2399645BCC2E@.microsoft.com...
> Unfortunately, our database is Simple for recovery model. Is there any
> other
> way to find it?
> Thanks again!
> "ME" wrote:
>> if you have the database at FULL recovery, download a trial version of
>> Log
>> Explorer at lumigent.com. It will tell you who's who?
>> "Jean" <Jean@.discussions.microsoft.com> wrote in message
>> news:86B01DE6-8302-4C6D-9D63-8FFF7D24AB74@.microsoft.com...
>> > Hi,
>> >
>> > We have a table that holds thousands of data in SQL server. However,
>> > the
>> > data is suddently gone yesterday. I am just wondering if there is a way
>> > to
>> > check when and how (who did) the data is gone. Can we track the action
>> > from
>> > log files or somewhere?
>> >
>> > Thanks in advance!
>>

Action Queries

Two questions.

1. How do I create action queries in SQL Server? From Enterprise Manager -> view I can create, run but NOT save the query.

2. How do I access an SQL server query from access like i would an Access query? Do i have to make a call to a stored procedure or something like that?If you like to reuse a query you can create it in Query Analyzer and then save it to a file. Using Query Analyzer you can then open the file and run the query. You can use any text editor to create a query and save it. Also by using a stored procedure you are saving the SQL to the database so it can be used at any time just by calling it. Depending on how you setup permission you can let other users call your stored procedure.|||I'm a little new at this so bear with me... OK.. I follow you up to the point of the stored procedure. Say i save that file as Test.. Is test.sql the stored procedure? I thought stored procedures were only available inside Enterprise manager. Lastly Once the file containing the sql statement is created, how do i reference the file from enterprise manager? i can figure out how to call a stored procedure in the enterprise manager from Access VBA code.|||Access_Dude,
Action Queries are a bit different in SQL Server to Access. In access, it all gets saved down in the database. In SQL Server, you've got a choice: Either save it down as a .sql file (in effect a text file - rename the extension to .txt, will open it in Notepad, no problems). This allows you to have a permanent copy which you can open from other apps without needing SQL Server - useful for saving down scripts which you want to run again but don't want to keep in the database.
Or, create a Stored Procedure in SQL Server. This will save the SQL into the database itself. As an example:

select Name, Postcode
from Customer
where CustomerID = 123

... can become a stored proc ('action query')...

create proc spGetCustomerNameAndPostcode
as
select Name, Postcode
from Customer
where CustomerID = 123

... it can then be simply called from an app, or from within SQL Server, using:
exec spGetCustomerNameAndPostcode

(Note that the exec isn't always needed, depends on what you're doing)

Hope this helps :)
Jon.|||Access_Dude,
Action Queries are a bit different in SQL Server to Access. In access, it all gets saved down in the database. In SQL Server, you've got a choice: Either save it down as a .sql file (in effect a text file - rename the extension to .txt, will open it in Notepad, no problems). This allows you to have a permanent copy which you can open from other apps without needing SQL Server - useful for saving down scripts which you want to run again but don't want to keep in the database.
Or, create a Stored Procedure in SQL Server. This will save the SQL into the database itself. As an example:

select Name, Postcode
from Customer
where CustomerID = 123

... can become a stored proc ('action query')...

create proc spGetCustomerNameAndPostcode
as
select Name, Postcode
from Customer
where CustomerID = 123

... it can then be simply called from an app, or from within SQL Server, using:
exec spGetCustomerNameAndPostcode

(Note that the exec isn't always needed, depends on what you're doing)

Hope this helps :)
Jon.

Action jumping to wrong report

Hello all,
I have a set of master reports that have linked copies in different
directories based on which customer is logging in to view them. Many of
the fields in these reports have actions to jump to other reports. The
problem I'm running into is that the action is jumping to the report in
the master directory (which has open customer queries) instead of the
one in the customer directory which has a default.
Kind of confusing, so here's an example:
Master reports 1 and 2 in directory /master have a default value of %
for customer and don't prompt for that parameter
Linked reports 1 and 2 in directory /123 have a default value of 123
for customer and don't prompt for that parameter
Report 1 jumps to report 2 when they click on a certain field, but if
it jumps to the report in /master it will query data for all customers.
I want it to jump to the linked report in /123 so it will only query
data for that customer.
If I try to pass in the customer field it gives an error since that
field isn't prompted for. Obviously prompting for the field will defeat
the security. Is there any way to force it to jump to the linked report
in the current directory instead of the one in the directory being
linked from?
Thanks!
JonAfter playing around with the "jump to URL" option I answered my own
question.
=Globals!ReportServerUrl & "?" & Globals.ReportFolder &
"/Report+2&Customer=" Fields!customer.value
Just in case it helps anyone else with a similar question...
Thanks,
Jon

Action in AS 2005

Hello,
Which is the utility of the mitre "Action" in Analysis Services 2005 ?
Thank you for your help!
Nico
You may place an action on dimension members and levels(and other things)...
( You may do this in SQL 2000 as well.)
The action occurs when a user selects, or right clicks on the member or
level ( depending on the support from the front end client which is being
using.)
SQL 2k actions include the following
Select the type of action. The following table summarizes the available
types.
Type Description
Command Line Executes a command at the command prompt in Microsoft
Windows NT 4.0 or Windows 2000
Statement Executes an OLE DB command
HTML Executes an HTML script in an Internet browser
URL Displays a variable page in an Internet browser
Data set Retrieves a dataset
Rowset Retrieves a rowset
Proprietary Performs an operation using an interface different from
those listed earlier in this table
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"pralnico" <pralnico@.discussions.microsoft.com> wrote in message
news:2C1C2836-90F7-44AF-AD83-B24FC9B88146@.microsoft.com...
> Hello,
> Which is the utility of the mitre "Action" in Analysis Services 2005 ?
> Thank you for your help!
> Nico

Action in AS 2005

Hello,
Which is the utility of the mitre "Action" in Analysis Services 2005 ?
Thank you for your help!
NicoYou may place an action on dimension members and levels(and other things)...
( You may do this in SQL 2000 as well.)
The action occurs when a user selects, or right clicks on the member or
level ( depending on the support from the front end client which is being
using.)
SQL 2k actions include the following
Select the type of action. The following table summarizes the available
types.
Type Description
Command Line Executes a command at the command prompt in Microsoft
Windows NT 4.0 or Windows 2000
Statement Executes an OLE DB command
HTML Executes an HTML script in an Internet browser
URL Displays a variable page in an Internet browser
Data set Retrieves a dataset
Rowset Retrieves a rowset
Proprietary Performs an operation using an interface different from
those listed earlier in this table
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"pralnico" <pralnico@.discussions.microsoft.com> wrote in message
news:2C1C2836-90F7-44AF-AD83-B24FC9B88146@.microsoft.com...
> Hello,
> Which is the utility of the mitre "Action" in Analysis Services 2005 ?
> Thank you for your help!
> Nico

Action in AS 2005

Hello,
Which is the utility of the mitre "Action" in Analysis Services 2005 ?
Thank you for your help!
NicoYou may place an action on dimension members and levels(and other things)...
( You may do this in SQL 2000 as well.)
The action occurs when a user selects, or right clicks on the member or
level ( depending on the support from the front end client which is being
using.)
SQL 2k actions include the following
Select the type of action. The following table summarizes the available
types.
Type Description
Command Line Executes a command at the command prompt in Microsoft®
Windows NT® 4.0 or Windows® 2000
Statement Executes an OLE DB command
HTML Executes an HTML script in an Internet browser
URL Displays a variable page in an Internet browser
Data set Retrieves a dataset
Rowset Retrieves a rowset
Proprietary Performs an operation using an interface different from
those listed earlier in this table
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"pralnico" <pralnico@.discussions.microsoft.com> wrote in message
news:2C1C2836-90F7-44AF-AD83-B24FC9B88146@.microsoft.com...
> Hello,
> Which is the utility of the mitre "Action" in Analysis Services 2005 ?
> Thank you for your help!
> Nico

Accessing reports through URL

Hello, All !!

I'm now getting problems with access reports through URL.
The situation is:
I'm posting the form to the frame, action attribute's URL includes
querystring.
Also I have some inputs in the form.
I'm using method=post.

Problem is that Report Server ignores parameters from query of the action.

I think it should work with them but it doesn't.

If anyone knows what's the matter here, please !

Thank you,
Alexander Yaremchuk

What version of the SQL RS are you using. The latest SQL 2005 CTP drop had this bug, which has been fixed since then.
Thanks
Tudor