Programatically Creating Dataflow Tasks Require Assembly Reference

Hi,

I am creating dataflow tasj using following

Imports Microsoft.SqlServer.Dts.Runtime

Imports Microsoft.SqlServer.Dts.Pipeline

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

These refer to Microsoft.SqlServer.DTSPipelineWrap.dll and Microsoft.SQLServer.DTSRuntimeWrap.dll. While these assemblies were already there in my dev machine I don't find these files in production enviornment for SQL server 2005. I am refering these assemblies from following path in my local machine : C:Program FilesMicrosoft SQL Server90SDKAssemblies.

How to install these assemblies in prod env, offcource one option is to copy it and then put it in GAC thru script . Why does not it gets installed while installation of SQL server 2005. Are these assemly dependent on SP1 ?

Thanks

Mohit



ADVERTISEMENT

Programatically Created DataFLow Task Fails

Hi,
 
I have a package in which i have programatically created dataflow task. It used to work fine but now it fails with series of errors out of which one is below
 
Error 30002: Type 'MainPipe' is not defined. Line 63 Columns 33-40 Line Text: Dim DataFlowTask As MainPipe = CType(DataFlowTaskHost.InnerObject, MainPipe)
 
It seems all the function and classes referd from following dlls is not working:
Microsoft.SqlServer.DTSRuntimeWrap.dll
Microsoft.SqlServer.DTSPipelineWrap.dll
 

I say so because i get the following error also:
 
Error 30652: Reference required to assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' containing the type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90'. Add one to your project. Line 86 Columns 33-64 Line Text: DtsConvert.ToConnectionManager90(ChildPackage.Connections(""Source"")) These dlls are in GAC and in C:Program FilesMicrosoft SQL Server90SDKAssemblies with same version but still it gives above error.
 
Thanks
Mohit

View Replies View Related

Creating A System.Management Assembly In Order For My Own Assembly To Work?

Hi

I am a bit paranoid about what I just did to my SQL Server 2005 with this CLR experiment.

I created a Class Lib in C# called inLineLib that has a class Queue which represents an object  with an ID field.

in another separate namespace called inLineCLRsql, I created a class called test which will hold the function to be accessed from DB,  I referenced and created an instances of the Queue class, and retrieve it's ID in a function called PrintMessage.

namespace inlineCLRsql{


public static class test{


public static void PrintMessage(){



inLineLib.Queue q = new inLineLib.Queue();

int i = q.queueId ;

Microsoft.SqlServer.Server.SqlContext.Pipe.Send(i.ToString());



}

}

}

to access this from the db, I attempted to create an assembley referencing inLineCLRsql.dll. This didn't work as it complained about inLineLib assembly not existing in the db. I then attempted to create an assembley for  inLineLib but it barfed saying  System.Management assembly not created.

so what I did is (and this is where I need to know if I just ruined sql server or not):

1- ALTER DATABASE myDB SET TRUSTWORTHY ON;.

2- CREATE ASSEMBLY SystemManagement

FROM 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727System.Management.dll'

WITH PERMISSION_SET = UNSAFE

3- CREATE ASSEMBLY inLineLibMaster

FROM 'D:inLineServerinLineLibinDebuginLineLib.dll'

WITH PERMISSION_SET = unsafe

4- and finally

CREATE ASSEMBLY inLineLib

FROM 'D:inLineServerCLRSQLinlineCLRsqlinDebuginlineCLRsql.dll'

WITH PERMISSION_SET = SAFE

 

Everything works after those steps (which took some trial and error). I can create a sproc like:

CREATE PROC sp_test AS

EXTERNAL NAME inLineLib.[inlineCLRsql.test].PrintMessage

and it returns the Queue ID

Is there anything unadvisable about the steps above?

 

Thanks for your help

 

M

 

 

View Replies View Related

BIG SSIS PACKAGE (200 DATAFLOW TASKS)

Thanks in advance in reading this thread.



I have developed a big SSIS package to extract data from flat-files ( + 200 Dataflows ).

The situation is the following, inside de SSIS package, there are a lot of validations before extracting & loading the flat-files, i'm running this validations in paralell, so that when a file arrives, it enters the "validation process" and start extracting the file.

When i run the SSIS package from BIDS it works the way i have concepted it... but when i run the ssis in the server, the tables that are loaded through the process are only "available" when the SSIS PACKAGE ends, it is imperative that trough the process, when a table receives new data, it becomes ready, and don't just be available when the SSIS package finishes...

I have attached the an lousing .jpeg.

It is importart for the tables to be available, so the stored procedures(OUTSIDE SSIS PACKAGE) that are dependent of some tables, start working before the SSIS package Ends.


Thanks in Advance.

View Replies View Related

Can We Format The Data In Dataflow Tasks?

 

hi all;
i have a doubt;
can we modify the data / format the data in a dataflow task?
Requirement

1. Excel file source
2. Convert data "Dec-07"(Mon-YY format) into "Dec-2007"(Mon-YYYY)
3. OLEDB Destination
 
how to do the second step?

View Replies View Related

Changeing Dataflow Tasks Propeties By Coding

Hi,
Is it possible to change the Dataflow tasks properties with VB coding? I've managed to change the properties  of the control  Flow tasks  with VB code! as I wan to create a generic dataflow that will change  everytime I run it.
Cheers

View Replies View Related

SSIS PACKAGE + 200 DataFlow Tasks && T-SQL Validations

Thanks in advance in reading this thread.

 

I have developed a big SSIS package to extract data from flat-files ( + 200 Dataflows ).

The situation is the following, inside de SSIS package, there are a lot of validations before extracting & loading the flat-files, i'm running this validations in paralell, so that when a file arrives, it enters the "validation process" and start extracting the file.

When i run the SSIS package from BIDS it works the way i have concepted it... but when i run the ssis in the server, the tables that are loaded through the process are only "available" when the SSIS PACKAGE ends, it is imperative that trough the process, when a table receives new data, it becomes ready, and don't just be available when the SSIS package finishes...

I have attached the an lousing .jpeg.

It is importart for the tables to be available, so the stored procedures(OUTSIDE SSIS PACKAGE) that are dependent of some tables, start working before the SSIS package Ends.


Thanks in Advance.

View Replies View Related

Setup 5 Dataflow Tasks In Series Or Parallel?

I've create a package that currently uses 5 DataFlow tasks connected in series to get data from 5 different files and place that information into 5 different temp tables.  Each Dataflow task contains only a OLE Source, a row count and a OLE destination.  My question is - Is it normal practise to keep each of these separate, or should I put them all into a single DataFlow?  The package should only continue if all five dataflow task complete successfully.

View Replies View Related

Special Error Handle In A Dataflow Transformation Tasks

Hello,
 
 
How would you do a log in a massive rows loading, I'm having problems because every row error(because of casting, format, lookup) in a transformation task is redirected to a text file as a log, this is ok when only exist one error by row, but in the case when I have two errors in the same row detected by diferents transformation tasks only the first one is reported to the text file, I have to wait to the second information load, after I correct the first error, to find the second one, I need to validate as many errors exists by row in the same load...
 
which component or which strategy can I use in a SSIS Packge to achieve this?
 
thanks 

View Replies View Related

SSIS - Need To Reference .NET Assembly Without GAC

I have a .NET assembly that I need to reference and use within my SSIS script task.
The only way I can acheive this is to strongly name my assembly and put it in the GAC.
This is not possible as my assembly is already in production and uses other 3rd party assemblies that would also need to be registered in the GAC.
As a workaround, I have created a .Net console application that references my assembly, that call from a SSIS Process Task.
Does anyone know of another way I could use my .NET assembly within my SSIS package?
Any help appreciated.
 Regards,
Paul.

View Replies View Related

Assembly Reference Issue

I have an external reference to an assembly that uses the following external references of its own:

System
System.Data
System.Xml

In BIDS everything works without any issues so I decided to deploy the package to my database server.  In doing so, I copied the DLL reference for my external assembly to obth the GAC and the v2.0.50727 folder and I even went as far as to copy the assembly folder into the Program Files folder.

Despite these efforts, I keep obtaining the following error:

The script threw an exception: Could not load file or Assembly 'MyComponent, Version-1.0.0.0,Culture=neutral,PublicKeyToken=f5bb784d481b2932' or one of its dependencies. The system cannot find the file specified.

I checked the version of my DLL in all 3 places and both the version and the token are the same.

I checked the properties within the script task and it has the exact same path to the v2.0.50727 folder (which shouldn't matter given the GAC...).

Does anybody has any ideas why this exception is occurring?

Thank you for your help!

View Replies View Related

How To Reference Dataflow Elements In A SQL Statement Embedded In A Lookup Transformation?

 

Hi guys,
 
I need to use a SQL statement to lookup a value from a SQL server database table that relates to a column in my dataflow.
 
Imagine a SQL database table called 'cars' with values of
 
Year | Description
2005 Ferrari 355
2005 Ferrari 355 Spider
2006 Ferrari 355 F1
 
In my data flow I have Year and Model eg.
 
Year | Model
2005 355
2006 355

 
In my SQL statement I want to select from the 'cars' table where the years match exactly but the 'description' is like the 'Model'. eg. %355%
 
So essentially, how do I construct the 'like' clause in the select statement to reference the 'Model' column please?
 
thanks for your help,
 
Chris
 

View Replies View Related

Reference Report Items Within A Custom Assembly?

How do I reference report items (such as textboxes, datasets, tables, etc...) from within a custom assembly?
 
Thanks!

View Replies View Related

CREATE ASSEMBLY ERROR -- An Implicit Reference Of Some Kind ???

When I run this ...

CREATE ASSEMBLY asmRANDRTCalendaringGateway FROM 'E:sqlRANDRTCalendaringGateway.dll' WITH PERMISSION_SET = UNSAFE

I get this error ...

Msg 10301, Level 16, State 1, Line 1
Assembly 'RANDRTCalendaringGateway' references assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.

Even though I do not explicity refer to system.web in the DLL's code ...

using Microsoft.Win32;
using System;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Configuration;
using System.Text;
using log4net;
using ADODB;
using MAPI;
using CDO;
using System.Runtime.InteropServices;

Is the problem just staring me in the face ?

cheers

View Replies View Related

Error Creating Mdf - Connection To SQL Server Files (*.mdf) Require SQL Express 2005 To....

Connection to SQL server files (*.mdf) require SQL express 2005 to function properly.  please verify the installation of the component or download from http://go.microsoft.com/fwlink/?linkid=49251
 
I AM GOING TO RIP MY HAIR OUT WITH THIS PROBLEM.  I have reinstalled both sql server express 2005 and VWD about 5 times with the same problem.  please, please, please someone throw me a bone here  and help me resolve this problem. 
When I create a new EMPTY website and I rightclick on my website in the solution explorer and choose add item, I chooe SQL Database, I give it a name 'database.mdf' and click add.  I get the following message:
you are attempting to add a database to an asp.net application.  for a database to be gfenerally consumable in your site, it should be placed inside the 'app_data' folder.  would you like to place the database inside the 'app_data' folder?  I click YES (I know this message is normal)
then I get the following message:
Connection to SQL server files (*.mdf) require SQL express 2005 to function properly.  please verify the installation of the component or download from http://go.microsoft.com/fwlink/?linkid=49251
I can add anything else but this damn mdf file. 
thanks for all your help in advance.
 
 

View Replies View Related

Null Reference Error When Using A Custom Assembly That Uses An App.config File

I have a custom assembly that uses a config file to obtain database connection settings. This dll is then used by my sql report. I have added refrerenced to all the required dll's in my report and added the required code groups to all the necessary files. I have also placed my app.config file in C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer and C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies
However when I actually run the report in the designer (vs2005) I am receiving Null reference exceptions when my code tries to read my config file because it is reading the machine.config file and not my app.config file. If I hard code my connection string everything works fine.

Can anyone tell me why the machine.config file would be referenced instead of my app.config file and how I can stop it from doing this?

View Replies View Related

Creating A Table Programatically!

Hi SQ Gurus,
Please help me with this issue that I am facing. I want to create a table programatically but want to pass its name as a variable. I would like to do something as follows:
CREATE PROCEDURE BS_Create
(@Name nvarchar(25))
AS
CREATE TABLE [dbo].[@Name](
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Prod_Name] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
The table name is passed in as a parameter. No matter what I pass as a parameter, the table name is '@Name', which is not what I want. Instead, if the variable contains the value 'Product', I would like to see a table with the name 'Product' to be created.

How can I solve this problem.

Any help is appreciated!
Krish Chandra

View Replies View Related

CS0246: The Type Or Namespace Name 'SqlConnection' Could Not Be Found (are You Missing A Using Directive Or An Assembly Reference?)

Hello,I just lost all my data doing a system restore and now trying to rebuild my web project.However, Am getting the error below, trying to use a class to run my Stored procedure.What is wrong herethanksEhiCompiler Error Message: CS0246: The type or namespace name 'SqlConnection' could not be found (are you missing a using directive or an assembly reference?)Source Error:Line 22: //SqlConnection con = new SqlConnection("cellulant_ConnectionString");
Line 23: //SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cellulant_ConnectionString"].ToString());
Line 24: SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["cellulant_ConnectionString"].ToString());
Line 25:
Line 26: Source File: c:inetpubwwwrootcellulant1App_Codesignup_data-entry.cs    Line: 24   using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;


public class signup_data_entry
{
public signup_data_entry(DateTime dob1)
{

//SqlConnection con = new SqlConnection("cellulant_ConnectionString");
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cellulant_ConnectionString"].ToString());
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["cellulant_ConnectionString"].ToString());


SqlCommand command = new SqlCommand("Cellulant_Users_registration", con);
command.CommandType = CommandType.StoredProcedure;

con.Open(); 

View Replies View Related

Creating An MS SQL Data Table Programatically

I use Visual Studio and VB.

If I want to create an SQL data table on the server, I go to Server
Explorer and make a small table with the corerct columns. Then I add
rows programatically as needed from the Application I'm working with.

It would suit me, for a current job, to be able to create the table itself programatically.

I don't know how to do this. Can it be done ? If so, could someone give
me a starter, please ? Four cols with a key in the first.

David Morley

View Replies View Related

Creating Calculated Members Programatically

Hi

I've read the MSDN documentation about creating calculated members and states that we can only create session scope or query scope members.

I need to create a static calculated member, one that stays there until it's deletion... That is possibel using Analysis Services, but what about with MDX or DSO?

Thanks in advance

View Replies View Related

Problem In Creating A Database Programatically....

I am crateing the database on the fly using db directory in VC++. I am able to create database. I am also able to create login. These can be easily done by logging as master using the username and password sa and "" resp. No

View Replies View Related

Problem In Creating A Database Programatically....

I am crateing the database on the fly using db directory in VC++. I am able to create database. I am also able to create login. These can be easily done by logging as master using the username and password sa and "" resp. Now I want to add a user to the database that i created. but it is being added to the master database. I know that I have to change my login from sa ,"" to the username and password that i gave during login. but i dont know how to change the login. Please help. If you have any code for that then that will be of great help.
Hoping to get a positive response as soon as possible..
Thanx
Nitin Gulati

View Replies View Related

Creating Script Task Programatically.

Hi All,
I am trying to create Script task programmatically. i am struck in one place where we will add the script code. I have given my code.
My Code:

TaskHost taskHost = package.Executables.Add("Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91") as TaskHost;

taskHost.Name = "Create SO";

taskHost.Properties["ReadWriteVariables"].SetValue(taskHost, "User:alesId");

Equvivalent XML code generated by the above code.
 


Code Block
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="0">
<DTS:Property DTS:Name="ExecutionLocation">0</< FONT>DTS:Property>
 
<DTS:Property DTS:Name="ObjectName">Create SO</< FONT>DTS:Property>
<DTS:Property DTS:Name="DTSID">{4498C2BE-58B6-433C-8F3E-0268BD267BAE}</< FONT>DTS:Property>
<DTS:Property DTS:Name="Description"></< FONT>DTS:Property>
<DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</< FONT>DTS:Property>
<DTS:Property DTS:Name="DisableEventHandlers">0</< FONT>DTS:Property>
 
 
<DTS:ObjectData>
<ScriptProject Name="ScriptTask_681442c33ab344b7bedb4492b01245a8" Language="Microsoft Visual Basic .NET" EntryPoint="ScriptMain" SaveBinaries="True" ReadOnlyVariables="" ReadWriteVariables="User::SalesId"/>
</< STRONG>DTS:ObjectData>
 
 
 
Generated XML when done thru SSIS Editor. i have given only the DTSObject..thats where i am struck.
 


Code Block
<DTS:ObjectData>
<ScriptProject Name="ScriptTask_d17b2b95a3984e37a536f2a6e017e2c9" Language="Microsoft Visual Basic .NET" EntryPoint="ScriptMain" SaveBinaries="True" ReadOnlyVariables="" ReadWriteVariables="User::SalesId">
<ProjectItem Name="dts://Scripts/ScriptTask_d17b2b95a3984e37a536f2a6e017e2c9/ScriptMain.vsaitem">
 <![CDATA[' Microsoft SQL Server Integration Services Script Task
 ' Write scripts using Microsoft Visual Basic
 ' The ScriptMain class is the entry point of the Script Task.
Imports System
Imports System.Data
Imports System.Math

 
 


In the DTSObject, i dont know how to add details thru C# code. Please help me.
Thanks.

View Replies View Related

Creating Model Based On UDM Programatically

Hi all,

 I konw of the following way to create a Model based on UDM (OLAP CUBE):

Select the shared data source in report manager

Click on Generate model button

Enter a Model Name, Description and Location Click €˜Ok€™


Is there a way to do this using code (C#, VB)?

 

Thanks,

LIran

View Replies View Related

Changing Field Property To Not Require From Require?

Hi everyone,

I have a table which have several fields. I have a field that is made required by mistake. I would like to change this field to not require. Can someone help with the syntax?

Any help is greatly appreciate.

View Replies View Related

SQL Sever 2005 - Creating Alias Names Programatically

Is there a way we can programatically create a SQL server Alias name (SQL 2005 - SQL Native client configuration) using either T-SQL, C# etc. - Manmeet

View Replies View Related

Reference To Preceeding Component From Custom Dataflow Transformation Component

I am writing a custom dataflow transformation component and I need to get the name of the preceeding component.

I have been trying to find a way to get a reference to the Package object, MainPipe object or IDTSPath90 object (connecting to the IDTSInput90 of my component) from my component because I think from there I can get to the information I want.

Does anyone have any suggestions?

TIA . . . Ed

View Replies View Related

Error While Creating Assembly

I am trying to create an assembly on a sql server 2005 machine but it gives me following error:


Msg 33009, Level 16, State 2, Line 2
The database owner SID recorded in the master database differs from the database owner SID recorded in database 'XYZ'. You should correct this situation by resetting the owner of database 'XYZ' using the ALTER AUTHORIZATION statement.



I tried using the alter authorization statement to change the owner.
It did not work.

I am able to create same assembly on another test database but can not create it on this database.

Is this because of orphan logins?

Thanks for the help.

Harshal.

View Replies View Related

Error While Creating Assembly

I am trying to create an assembly on a sql server 2005 machine but it gives me following error:


Msg 33009, Level 16, State 2, Line 2
The database owner SID recorded in the master database differs from the database owner SID recorded in database 'XYZ'. You should correct this situation by resetting the owner of database 'XYZ' using the ALTER AUTHORIZATION statement.



I tried using the alter authorization statement to change the owner.
It did not work.

The same assembly is created on another test database but can not create it on this database.

Is this because of orphan logins?

Thanks for the help.

Harshal.

View Replies View Related

Error Creating Assembly

 

I encountered something strange, deploying the following assemblies
 

CREATE ASSEMBLY [Sentry]

AUTHORIZATION [dbo]

FROM 'c:clrSentry.dll'

WITH PERMISSION_SET = EXTERNAL_ACCESS;

GO
 

CREATE ASSEMBLY [Sentry.XmlSerializers]

AUTHORIZATION [dbo]

FROM 'C:clrSentry.XmlSerializers.dll'

WITH PERMISSION_SET = SAFE;

GO

 
 
Sentry.XmlSerializers errored out with:
Msg 6218, Level 16, State 2, Line 2
CREATE ASSEMBLY for assembly 'Sentry.XmlSerializers' failed because assembly 'Sentry.XmlSerializers' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
[ : Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializerContract::CanSerialize][mdToken=0x600006e][offset 0x00000001][token  0x01000019]System.TypeLoadException: Could not load type 'Sentry.SentryDataService.SentryDataService' from assembly 'Sentry, Version=1.0.2764.18017, Culture=neutral, PublicKeyToken=null'. Type load failed.
 
 
The interesting thing is that when I deploy this locally on my machine, there are no problems whatsoever. Using sp_configure the servers appear to be set up the same way. The database also has trustworthy set on for both.
 
Anything, I could be missing? Thanks
 

View Replies View Related

Problem Creating Assembly Using Other Assemblies

Hi,I have developed a Stored procedure to output text to a text file, after doing a lot of reading here.
I want to be able to output data to a Postgres database, to be used for web mapping. I have referenced an Assembly Npgsql.dll so I can send updates to the postgres database when my ms sql database is updated. However, after building my class library, when I try to CREATE ASSEMBLY in sql server 2005 express, it sends out a message:
Msg 10301, Level 16, State 1, Line 1
Assembly 'ClassLibrary1' references assembly 'system.drawing, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(error not found)). Please load the referenced assembly into the current database and retry your request.
The error seems to be in the Npgsql.dll assembly, can anybody please shed some light on this.
I tried to load the system.drawing assembly, and can do so in Unrestricted mode. It then spits out the same problem for System.Windows.Forms.dll.
I am still very new to all of this so any help would be appreciated.
Cheers,
Jatz91.

View Replies View Related

Problem Creating A Function From An Assembly

I have compiled a dll with the following code:

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports Microsoft.SqlServer.Server
Imports System.Data.SqlTypes

Public Class SICTrans

    Public Shared Function TransSIC(ByVal inpSIC As String) As String
        'Dim conn As SqlConnection = New SqlConnection("context connection=true")
        Dim NewSIC, TempSIC, tempFSIC As String

        If Len(NZ(inpSIC)) > 0 Then
            TempSIC = NZ(inpSIC)

            If Len(TempSIC) < 5 Then TempSIC = Left("00000", 5 - Len(TempSIC))

            tempFSIC = Left(TempSIC, 2) + "." + Mid(TempSIC, 3, 2)

            If Val(Right(TempSIC, 1)) > 0 Then

                tempFSIC = tempFSIC + "/" + Right(TempSIC, 1)
            End If
        End If

        NewSIC = tempFSIC

        TransSIC = NewSIC

    End Function
    Public Shared Function NZ(ByVal input As String) As String
        If Not (input Is Nothing) Then
            Return input
            Exit Function
        End If
        Return String.Empty

    End Function
End Class

Which compiles fine...

i then use the following code to create the assembly in SQL which is fine:

USE NARD
GO
CREATE ASSEMBLY SICCodeTrans
FROM 'c:SICCodeTrans.dll'
WITH PERMISSION_SET = SAFE
GO

but when i goto create the function with the following code it wont have it!

CREATE FUNCTION TransSICCode(@inpSIC varchar)
RETURNS varchar
AS EXTERNAL NAME
SICCodeTrans.SICTrans.TransSIC
GO

It gives me the following error message

Msg 6505, Level 16, State 1, Procedure TransSICCode, Line 1
Could not find Type 'SICTrans' in assembly 'SICCodeTrans'.

Any ideas??????????

Thanks

Marek Kluczynski

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved