Filter Cube Data

Hi

i am using pivot table 11 to display the data from SSAS Cube. the problem is

1- pivot table fetches all the data and display it according to the design. but what i need is

a- the user could only see the data which was posted by himself.

b. He must be unaware of the data posted by other users.

in database table there is a field named userId which is also which is part of dimenssion in myCube.

i dont want to use filteraxes for this purpose actually i want the user to be unaware of other users of system also

any single helping word will be appriciated

Regards

Salman Bashir

Hi Salman,

You can define custom dimension security rules for the "UserID" attribute - the MDX function: UserName (which returns "domain\user") is typically used for this purpose:

http://msdn2.microsoft.com/en-us/library/ms175366.aspx

>>

SQL Server 2005 Books Online

Granting Custom Access to Dimension Data

...

Understanding the IsAllowed Property

The IsAllowed property determines whether the database role can access attribute members. By default, a database role that has access to a dimension cannot access attribute hierarchies.

Understanding the AllowedSet Property

The AllowedSet property uses a Multidimensional Expressions (MDX) expression to determine which attribute members can be viewed by the database role (the allowed set). The allowed set can include no (default), all, or some attribute members. If you allow access to an attribute and do not define any members of the allowed set, access to all members is granted. If you allow access to an attribute and define a specific set of attribute members, only the specifically allowed members are visible. Specifically defining an allowed set may limit the visibility of attribute members added after the allowed set is defined.

...

Understanding the VisualTotals Property

The VisualTotals property indicates whether the aggregated cell values that are displayed are calculated according to all cell values or only according to the cell values that are visible to the database role.

By default, the VisualTotals property is disabled (set to False). This default setting maximizes performance because Analysis Services can quickly calculate the total of all cell values, instead of having to spend time selecting which cells values to calculate.

However, having the VisualTotals property disabled could create a security issue if a user can use the aggregated cell values to deduce values for attribute members to which the user's database role does not have access. For example, Analysis Services uses the values for three attribute members to calculate an aggregated cell value. The database role has access to view two of these three attribute members. Using the aggregated cell value, a member of this database role would be able to deduce the value for the third attribute member.

If a user can deduce values for attribute members to which the user's database role does not have access, security best practice dictates that you enable (set to True) the VisualTotals property for the attribute. When you enable the VisualTotals property, a database role can only view aggregated totals for dimension members to which the role has permission. For example, enabling the VisualTotals property means that the database role will see an aggregated total that includes only those states (that is, members of the State attribute) that are visible to the role. The aggregated total will not include the values for all states.

Understanding the DefaultMember Property

The DefaultMember property determines the data set that is returned to a client when an attribute is not explicitly included in a query. When the attribute is not explicitly included, Analysis Services uses one of the following default members for the attribute:

If the database role defines a default member for the attribute, Analysis Services uses this default member.
If the database role does not define a default member for the attribute, Analysis Services uses the default member that is defined for the attribute itself. The default member for an attribute, unless you specify otherwise, is the All member (unless the attribute is defined as non-aggregatable).
|||

Dear sir

i am really thankful to you for your such a quick reply. it is no doubt very much helpful but my requirments are a bit different

i have custom role management system and i dont use the roles and user accounts in operating system but there are roles which are defined in my personal database and there are user accounts under those roles.

whenever a user inserts a record in database it leaves a refference tag (His LoginName (which is from a table named users in the same database and have no relation with os or domain users) with that record) which identify that which user is owner of that record.

when user sign in with my application (basically with my own role management system) a global reference to his LoginName (which is from User table in my role management system) is created when his session starts. now from this application he opens a form on which a pivot table is placed which is getting data from the cube (whose datasource is the database i defined in 2nd paragraph) now i want pivot table to send a LoginNameas parameter and cube send back the data with this username and all calculations must be performed on this filter data

|||

Actually, dynamic dimension data security as described above should still work - if you set the SSAS "CustomData" connection property to the custom "LoginName" managed by your app. Then you would access the user "LoginName" via the "CustomData" MDX function:

http://msdn2.microsoft.com/en-us/library/ms145582.aspx

>>

SQL Server 2005 Books Online

CustomData (MDX)

Updated: 17 July 2006

Returns the value of the CustomData connection string property if defined; otherwise, null.

...

For example, this function can be used in a dynamic security expression to select the allowed/denied set members for the string value in the CustomData connection string property.

>>

|||

Hi Salman,

were you able to figure out the solution. if yes could you please post you example details.

Thanks

Milind

|||

I am also having the same problem of filtering the cube data based on users defined in a database. were you able to find a solution for this?

Thanks,

Maximus11

Filter Cube Data

Hi

i am using pivot table 11 to display the data from SSAS Cube. the problem is

1- pivot table fetches all the data and display it according to the design. but what i need is

a- the user could only see the data which was posted by himself.

b. He must be unaware of the data posted by other users.

in database table there is a field named userId which is also which is part of dimenssion in myCube.

i dont want to use filteraxes for this purpose actually i want the user to be unaware of other users of system also

any single helping word will be appriciated

Regards

Salman Bashir

Hi Salman,

You can define custom dimension security rules for the "UserID" attribute - the MDX function: UserName (which returns "domain\user") is typically used for this purpose:

http://msdn2.microsoft.com/en-us/library/ms175366.aspx

>>

SQL Server 2005 Books Online

Granting Custom Access to Dimension Data

...

Understanding the IsAllowed Property

The IsAllowed property determines whether the database role can access attribute members. By default, a database role that has access to a dimension cannot access attribute hierarchies.

Understanding the AllowedSet Property

The AllowedSet property uses a Multidimensional Expressions (MDX) expression to determine which attribute members can be viewed by the database role (the allowed set). The allowed set can include no (default), all, or some attribute members. If you allow access to an attribute and do not define any members of the allowed set, access to all members is granted. If you allow access to an attribute and define a specific set of attribute members, only the specifically allowed members are visible. Specifically defining an allowed set may limit the visibility of attribute members added after the allowed set is defined.

...

Understanding the VisualTotals Property

The VisualTotals property indicates whether the aggregated cell values that are displayed are calculated according to all cell values or only according to the cell values that are visible to the database role.

By default, the VisualTotals property is disabled (set to False). This default setting maximizes performance because Analysis Services can quickly calculate the total of all cell values, instead of having to spend time selecting which cells values to calculate.

However, having the VisualTotals property disabled could create a security issue if a user can use the aggregated cell values to deduce values for attribute members to which the user's database role does not have access. For example, Analysis Services uses the values for three attribute members to calculate an aggregated cell value. The database role has access to view two of these three attribute members. Using the aggregated cell value, a member of this database role would be able to deduce the value for the third attribute member.

If a user can deduce values for attribute members to which the user's database role does not have access, security best practice dictates that you enable (set to True) the VisualTotals property for the attribute. When you enable the VisualTotals property, a database role can only view aggregated totals for dimension members to which the role has permission. For example, enabling the VisualTotals property means that the database role will see an aggregated total that includes only those states (that is, members of the State attribute) that are visible to the role. The aggregated total will not include the values for all states.

Understanding the DefaultMember Property

The DefaultMember property determines the data set that is returned to a client when an attribute is not explicitly included in a query. When the attribute is not explicitly included, Analysis Services uses one of the following default members for the attribute:

If the database role defines a default member for the attribute, Analysis Services uses this default member.

If the database role does not define a default member for the attribute, Analysis Services uses the default member that is defined for the attribute itself. The default member for an attribute, unless you specify otherwise, is the All member (unless the attribute is defined as non-aggregatable).
|||

Dear sir

i am really thankful to you for your such a quick reply. it is no doubt very much helpful but my requirments are a bit different

i have custom role management system and i dont use the roles and user accounts in operating system but there are roles which are defined in my personal database and there are user accounts under those roles.

whenever a user inserts a record in database it leaves a refference tag (His LoginName (which is from a table named users in the same database and have no relation with os or domain users) with that record) which identify that which user is owner of that record.

when user sign in with my application (basically with my own role management system) a global reference to his LoginName (which is from User table in my role management system) is created when his session starts. now from this application he opens a form on which a pivot table is placed which is getting data from the cube (whose datasource is the database i defined in 2nd paragraph) now i want pivot table to send a LoginNameas parameter and cube send back the data with this username and all calculations must be performed on this filter data

|||

Actually, dynamic dimension data security as described above should still work - if you set the SSAS "CustomData" connection property to the custom "LoginName" managed by your app. Then you would access the user "LoginName" via the "CustomData" MDX function:

http://msdn2.microsoft.com/en-us/library/ms145582.aspx

>>

SQL Server 2005 Books Online

CustomData (MDX)

Updated: 17 July 2006

Returns the value of the CustomData connection string property if defined; otherwise, null.

...

For example, this function can be used in a dynamic security expression to select the allowed/denied set members for the string value in the CustomData connection string property.

>>

|||

Hi Salman,

were you able to figure out the solution. if yes could you please post you example details.

Thanks

Milind

|||

I am also having the same problem of filtering the cube data based on users defined in a database. were you able to find a solution for this?

Thanks,

Maximus11

Filter by uniqueidentifier in DPW's don't work, and yet sometimes do?

According to Microsoft, when executing a query against a linked server, any
filtering (where condition) against a uniqueidentifier or bit columns cannot
be applied on the remote server. Instead, all rows in the remote server's
table will be brought across the wire, and the filter condition will be
applied locally.
This can be demonstrated by declaring a view
CREATE VIEW ActionItems AS SELECT * FROM
RemoteServer.dbo.Database.ActionItems
that queries the table
CREATE TABLE [ActionItems1] (
[ActionItemID] [uniqueidentifier] NOT NULL CONSTRAINT
[DF_ActionItems1_ActionItemID] DEFAULT (newid()),
[AssociatedEmployeeID] [uniqueidentifier] NULL ,
[AssociatedActionItemID] [uniqueidentifier] NOT NULL , --clustered
[ParentActionItemID] [uniqueidentifier] NULL ,
CONSTRAINT [PK_ActionItems1_1] PRIMARY KEY NONCLUSTERED
(
[ActionItemID]
)
)
Now, i will try to filter by a uniqueidentifier:
SELECT ActionItemID FROM ActionItems
WHERE ActionItemID = '28E5D33A-8946-48A6-BEFC-A0C07914D440'
StmtText
------
|--Filter(WHERE[Jango].[CasinoHR].[dbo].[ActionItems1].[ActionItemID]=28E5D33A-8946-48A6-BEFC-A0C07914D440))
|--Remote Query(SOURCEJango), QUERYSELECT Tbl1001."ActionItemID"
Col1003 FROM "CasinoHR"."dbo"."ActionItems1" Tbl1001))
And as expected and documented, all rows are returned, then a filter is
applied to get the one row.
But wait! Now i will try to filter by a uniqueidentifier:
SELECT ActionItemID FROM ActionItems
WHERE AssociatedEmployeeID = '4C5CD857-8DD4-4279-B017-7CF1C49B23D9'
StmtText
--------
|--Remote Query(SOURCEJango), QUERYSELECT Tbl1001."ActionItemID"
Col1004 FROM "CasinoHR"."dbo"."ActionItems1" Tbl1001 WHERE
Tbl1001."AssociatedEmployeeID"=?))
And not as expected, and opposite as documented, only the matching rows are
returned - and the filter is applied on the remote server.
But wait! Now i will try to filter by a uniqueidentifer:
SELECT ActionItemID FROM ActionItems
WHERE AssociatedEmployeeID is not null
StmtText
-------
|--Filter(WHERE[Jango].[CasinoHR].[dbo].[ActionItems1].[AssociatedEmployeeID]<>NULL))
|--Remote Query(SOURCEJango), QUERYSELECT
Tbl1001."AssociatedEmployeeID" Col1005,Tbl1001."ActionItemID" Col1003 FROM
"CasinoHR"."dbo"."ActionItems1" Tbl1001))
And as expected and documented, all rows are returned, then a filter is
applied to get the one row.
But wait! Now i will try to filter by a uniqueidentifier:
SELECT ActionItemID FROM ActionItems
WHERE AssociatedActionItemID = 'C8A32A8F-2AF8-4B4A-9954-27274F4F6B01'
StmtText
-------
|--Remote Query(SOURCEJango), QUERYSELECT Tbl1001."ActionItemID"
Col1004 FROM "CasinoHR"."dbo"."ActionItems1" Tbl1001 WHERE
Tbl1001."AssociatedActionItemID"=?))
And not as expected, and opposite as documented, only the matching rows are
returned - and the filter is applied on the remote server.
So what's up? Either SQL Server can pass a filter condition on a
uniqueidentifier field to the remote server, or it cannot. Which is it? The
documentation says it cannot. The documentation does not say that it cannot
except for sometimes - who's logic isn't apparent or logical.
Oops, DPW should be DPV
Distributed Partitioned Views
sql

Filter by uniqueidentifier in DPW's don't work, and yet sometimes do?

According to Microsoft, when executing a query against a linked server, any
filtering (where condition) against a uniqueidentifier or bit columns cannot
be applied on the remote server. Instead, all rows in the remote server's
table will be brought across the wire, and the filter condition will be
applied locally.
This can be demonstrated by declaring a view
CREATE VIEW ActionItems AS SELECT * FROM
RemoteServer.dbo.Database.ActionItems
that queries the table
CREATE TABLE [ActionItems1] (
[ActionItemID] [uniqueidentifier] NOT NULL CONSTRAINT
[DF_ActionItems1_ActionItemID] DEFAULT (newid()),
[AssociatedEmployeeID] [uniqueidentifier] NULL ,
[AssociatedActionItemID] [uniqueidentifier] NOT NULL , --clustered
[ParentActionItemID] [uniqueidentifier] NULL ,
CONSTRAINT [PK_ActionItems1_1] PRIMARY KEY NONCLUSTERED
(
[ActionItemID]
)
)
Now, i will try to filter by a uniqueidentifier:
SELECT ActionItemID FROM ActionItems
WHERE ActionItemID = '28E5D33A-8946-48A6-BEFC-A0C07914D440'
StmtText
----
----
|--Filter(WHERE[Jango].[CasinoHR].[dbo].[ActionItems1].
1;ActionItemID]=28E5D33A-8946-48A6-BEFC-A0C07914D440))
|--Remote Query(SOURCEJango), QUERYSELECT Tbl1001."ActionItemID"
Col1003 FROM "CasinoHR"."dbo"."ActionItems1" Tbl1001))
And as expected and documented, all rows are returned, then a filter is
applied to get the one row.
But wait! Now i will try to filter by a uniqueidentifier:
SELECT ActionItemID FROM ActionItems
WHERE AssociatedEmployeeID = '4C5CD857-8DD4-4279-B017-7CF1C49B23D9'
StmtText
----
----
--
|--Remote Query(SOURCEJango), QUERYSELECT Tbl1001."ActionItemID"
Col1004 FROM "CasinoHR"."dbo"."ActionItems1" Tbl1001 WHERE
Tbl1001."AssociatedEmployeeID"=?))
And not as expected, and opposite as documented, only the matching rows are
returned - and the filter is applied on the remote server.
But wait! Now i will try to filter by a uniqueidentifer:
SELECT ActionItemID FROM ActionItems
WHERE AssociatedEmployeeID is not null
StmtText
----
----
--
|--Filter(WHERE[Jango].[CasinoHR].[dbo].[ActionItems1].
1;AssociatedEmployeeID]<>NULL))
|--Remote Query(SOURCEJango), QUERYSELECT
Tbl1001."AssociatedEmployeeID" Col1005,Tbl1001."ActionItemID" Col1003 FROM
"CasinoHR"."dbo"."ActionItems1" Tbl1001))
And as expected and documented, all rows are returned, then a filter is
applied to get the one row.
But wait! Now i will try to filter by a uniqueidentifier:
SELECT ActionItemID FROM ActionItems
WHERE AssociatedActionItemID = 'C8A32A8F-2AF8-4B4A-9954-27274F4F6B01'
StmtText
----
----
--
|--Remote Query(SOURCEJango), QUERYSELECT Tbl1001."ActionItemID"
Col1004 FROM "CasinoHR"."dbo"."ActionItems1" Tbl1001 WHERE
Tbl1001."AssociatedActionItemID"=?))
And not as expected, and opposite as documented, only the matching rows are
returned - and the filter is applied on the remote server.
So what's up? Either SQL Server can pass a filter condition on a
uniqueidentifier field to the remote server, or it cannot. Which is it? The
documentation says it cannot. The documentation does not say that it cannot
except for sometimes - who's logic isn't apparent or logical.Oops, DPW should be DPV
Distributed Partitioned Views

Filter by uniqueidentifier in DPW's don't work, and yet sometimes do?

According to Microsoft, when executing a query against a linked server, any
filtering (where condition) against a uniqueidentifier or bit columns cannot
be applied on the remote server. Instead, all rows in the remote server's
table will be brought across the wire, and the filter condition will be
applied locally.
This can be demonstrated by declaring a view
CREATE VIEW ActionItems AS SELECT * FROM
RemoteServer.dbo.Database.ActionItems
that queries the table
CREATE TABLE [ActionItems1] (
[ActionItemID] [uniqueidentifier] NOT NULL CONSTRAINT
[DF_ActionItems1_ActionItemID] DEFAULT (newid()),
[AssociatedEmployeeID] [uniqueidentifier] NULL ,
[AssociatedActionItemID] [uniqueidentifier] NOT NULL , --clustered
[ParentActionItemID] [uniqueidentifier] NULL ,
CONSTRAINT [PK_ActionItems1_1] PRIMARY KEY NONCLUSTERED
(
[ActionItemID]
)
)
Now, i will try to filter by a uniqueidentifier:
SELECT ActionItemID FROM ActionItems
WHERE ActionItemID = '28E5D33A-8946-48A6-BEFC-A0C07914D440'
StmtText
------
|--Filter(WHERE:([Jango].[CasinoHR].[dbo].[ActionItems1].[ActionItemID]=28E5D33A-8946-48A6-BEFC-A0C07914D440))
|--Remote Query(SOURCE:(Jango), QUERY:(SELECT Tbl1001."ActionItemID"
Col1003 FROM "CasinoHR"."dbo"."ActionItems1" Tbl1001))
And as expected and documented, all rows are returned, then a filter is
applied to get the one row.
But wait! Now i will try to filter by a uniqueidentifier:
SELECT ActionItemID FROM ActionItems
WHERE AssociatedEmployeeID = '4C5CD857-8DD4-4279-B017-7CF1C49B23D9'
StmtText
--------
|--Remote Query(SOURCE:(Jango), QUERY:(SELECT Tbl1001."ActionItemID"
Col1004 FROM "CasinoHR"."dbo"."ActionItems1" Tbl1001 WHERE
Tbl1001."AssociatedEmployeeID"=?))
And not as expected, and opposite as documented, only the matching rows are
returned - and the filter is applied on the remote server.
But wait! Now i will try to filter by a uniqueidentifer:
SELECT ActionItemID FROM ActionItems
WHERE AssociatedEmployeeID is not null
StmtText
-------
|--Filter(WHERE:([Jango].[CasinoHR].[dbo].[ActionItems1].[AssociatedEmployeeID]<>NULL))
|--Remote Query(SOURCE:(Jango), QUERY:(SELECT
Tbl1001."AssociatedEmployeeID" Col1005,Tbl1001."ActionItemID" Col1003 FROM
"CasinoHR"."dbo"."ActionItems1" Tbl1001))
And as expected and documented, all rows are returned, then a filter is
applied to get the one row.
But wait! Now i will try to filter by a uniqueidentifier:
SELECT ActionItemID FROM ActionItems
WHERE AssociatedActionItemID = 'C8A32A8F-2AF8-4B4A-9954-27274F4F6B01'
StmtText
-------
|--Remote Query(SOURCE:(Jango), QUERY:(SELECT Tbl1001."ActionItemID"
Col1004 FROM "CasinoHR"."dbo"."ActionItems1" Tbl1001 WHERE
Tbl1001."AssociatedActionItemID"=?))
And not as expected, and opposite as documented, only the matching rows are
returned - and the filter is applied on the remote server.
So what's up? Either SQL Server can pass a filter condition on a
uniqueidentifier field to the remote server, or it cannot. Which is it? The
documentation says it cannot. The documentation does not say that it cannot
except for sometimes - who's logic isn't apparent or logical.Oops, DPW should be DPV
Distributed Partitioned Views

File or assembly name Interop.DTS, or one of its dependencies, was not found.

I am trying to execute a DTS via COM according to the KB article
http://support.microsoft.com/?kbid=321525
but I am getting the exception "File or assembly name Interop.DTS, or one of
its dependencies, was not found." which is obviously a file not found
exception. I have sql server 2000 installed locally and I can run the
package from enterprise manager. Anyone got any ideas why I am getting when
I have the correct reference in the c# .net project?
--
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.Is the Interop.DTS.dll in your application bin folder? This should get
generated when you build your project.
You might also check out the examples at
http://sqldev.net/dts/ExecutePackage.htm
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
>I am trying to execute a DTS via COM according to the KB article
> http://support.microsoft.com/?kbid=321525
> but I am getting the exception "File or assembly name Interop.DTS, or one
> of
> its dependencies, was not found." which is obviously a file not found
> exception. I have sql server 2000 installed locally and I can run the
> package from enterprise manager. Anyone got any ideas why I am getting
> when
> I have the correct reference in the c# .net project?
> --
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>|||yeap it was noob error, no dll in the bin directory :)
Ollie
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:#$jJFpkJFHA.2136@.TK2MSFTNGP14.phx.gbl...
> Is the Interop.DTS.dll in your application bin folder? This should get
> generated when you build your project.
> You might also check out the examples at
> http://sqldev.net/dts/ExecutePackage.htm
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
> news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
> >I am trying to execute a DTS via COM according to the KB article
> >
> > http://support.microsoft.com/?kbid=321525
> >
> > but I am getting the exception "File or assembly name Interop.DTS, or
one
> > of
> > its dependencies, was not found." which is obviously a file not found
> > exception. I have sql server 2000 installed locally and I can run the
> > package from enterprise manager. Anyone got any ideas why I am getting
> > when
> > I have the correct reference in the c# .net project?
> >
> > --
> > Cheers
> >
> > Ollie Riches
> > http://www.phoneanalyser.net
> >
> > Disclaimer: Opinions expressed in this forum are my own, and not
> > representative of my employer.
> > I do not answer questions on behalf of my employer. I'm just a
programmer
> > helping programmers.
> >
> >
>

File or assembly name Interop.DTS, or one of its dependencies, was not found.

I am trying to execute a DTS via COM according to the KB article
http://support.microsoft.com/?kbid=321525
but I am getting the exception "File or assembly name Interop.DTS, or one of
its dependencies, was not found." which is obviously a file not found
exception. I have sql server 2000 installed locally and I can run the
package from enterprise manager. Anyone got any ideas why I am getting when
I have the correct reference in the c# .net project?
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.Is the Interop.DTS.dll in your application bin folder? This should get
generated when you build your project.
You might also check out the examples at
http://sqldev.net/dts/ExecutePackage.htm
Hope this helps.
Dan Guzman
SQL Server MVP
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
>I am trying to execute a DTS via COM according to the KB article
> http://support.microsoft.com/?kbid=321525
> but I am getting the exception "File or assembly name Interop.DTS, or one
> of
> its dependencies, was not found." which is obviously a file not found
> exception. I have sql server 2000 installed locally and I can run the
> package from enterprise manager. Anyone got any ideas why I am getting
> when
> I have the correct reference in the c# .net project?
> --
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>|||yeap it was noob error, no dll in the bin directory
Ollie
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:#$jJFpkJFHA.2136@.TK2MSFTNGP14.phx.gbl...
> Is the Interop.DTS.dll in your application bin folder? This should get
> generated when you build your project.
> You might also check out the examples at
> http://sqldev.net/dts/ExecutePackage.htm
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
> news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
one[vbcol=seagreen]
programmer[vbcol=seagreen]
>

File or assembly name Interop.DTS, or one of its dependencies, was not found.

I am trying to execute a DTS via COM according to the KB article
http://support.microsoft.com/?kbid=321525
but I am getting the exception "File or assembly name Interop.DTS, or one of
its dependencies, was not found." which is obviously a file not found
exception. I have sql server 2000 installed locally and I can run the
package from enterprise manager. Anyone got any ideas why I am getting when
I have the correct reference in the c# .net project?
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.Is the Interop.DTS.dll in your application bin folder? This should get
generated when you build your project.
You might also check out the examples at
http://sqldev.net/dts/ExecutePackage.htm
Hope this helps.
Dan Guzman
SQL Server MVP
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
>I am trying to execute a DTS via COM according to the KB article
> http://support.microsoft.com/?kbid=321525
> but I am getting the exception "File or assembly name Interop.DTS, or one
> of
> its dependencies, was not found." which is obviously a file not found
> exception. I have sql server 2000 installed locally and I can run the
> package from enterprise manager. Anyone got any ideas why I am getting
> when
> I have the correct reference in the c# .net project?
> --
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>|||yeap it was noob error, no dll in the bin directory :)
Ollie
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:#$jJFpkJFHA.2136@.TK2MSFTNGP14.phx.gbl...
> Is the Interop.DTS.dll in your application bin folder? This should get
> generated when you build your project.
> You might also check out the examples at
> http://sqldev.net/dts/ExecutePackage.htm
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
> news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
one
programmer
>

File or assembly name Interop.DTS, or one of its dependencies, was not found.

I am trying to execute a DTS via COM according to the KB article
http://support.microsoft.com/?kbid=321525
but I am getting the exception "File or assembly name Interop.DTS, or one of
its dependencies, was not found." which is obviously a file not found
exception. I have sql server 2000 installed locally and I can run the
package from enterprise manager. Anyone got any ideas why I am getting when
I have the correct reference in the c# .net project?
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.
Is the Interop.DTS.dll in your application bin folder? This should get
generated when you build your project.
You might also check out the examples at
http://sqldev.net/dts/ExecutePackage.htm
Hope this helps.
Dan Guzman
SQL Server MVP
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
>I am trying to execute a DTS via COM according to the KB article
> http://support.microsoft.com/?kbid=321525
> but I am getting the exception "File or assembly name Interop.DTS, or one
> of
> its dependencies, was not found." which is obviously a file not found
> exception. I have sql server 2000 installed locally and I can run the
> package from enterprise manager. Anyone got any ideas why I am getting
> when
> I have the correct reference in the c# .net project?
> --
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>
|||yeap it was noob error, no dll in the bin directory
Ollie
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:#$jJFpkJFHA.2136@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Is the Interop.DTS.dll in your application bin folder? This should get
> generated when you build your project.
> You might also check out the examples at
> http://sqldev.net/dts/ExecutePackage.htm
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
> news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
one[vbcol=seagreen]
programmer
>