Using SSIS Class Library
Oct 18, 2007
Hi,
I´m wondering if is it possible to use the SSIS Class Library without SQLServer installed in the machine or if is it necessary to install SLQ Server in order to use SSIS objects?
thaks.
Hi,
I´m wondering if is it possible to use the SSIS Class Library without SQLServer installed in the machine or if is it necessary to install SLQ Server in order to use SSIS objects?
thaks.
I have a requirement in which i have to create a custom .net class library for Ex:-I retrieve password(s) from a thrid party component. Below is what i am doing.
(1) Created a custom class library which reads a custom .xml file from a drive Ex:- "D:MyAppMYAppCofig.xml" and sets to my properties of my custom class library and inside it i created an instance of third party component's class and passed these values. Since i need to use this .net custom class library both in web and ssis/database side i am using this custom .xml file.
(2) After validating passed data (properties set in custom .net class library) the thrid party component instance object created in my custom .net class libraty returs a password to me own custom .net class libray.
(3) This password I use in my web app for connecting to database. This code is working fine.
(4) My question is how to execute a custom .net class library code through ssis and to use the my same custom .net class library and pass the password to my SSIS component / taks so that that code block also uses the returned password to connect and do any needed tasks? In other words how to use custom .net class library from SSIS.
My Environment is as follows:-
SQL Server is : 2008 R2
VS.NET 2013
Hi All,
Now I am creating .Net CF2.0 class library project, and I have some public method which take parameters. And I commented those method using following tag.
/// <summary>
///
/// </summary>
/// <returns></returns>
But when I add to other project where I wanted use that dll , when I create instance and call the method it€™s not giving me the description which I gave. But when I refer in the same class library project itself it€™s giving outside that it€™s not giving the details.
Could you please anyone to solve this problem ??
Thanks ,
Jayakumar a
I'm trying to use the Data Access Application block, and am having some issues with configuration. I am using it in a class library, and it seems that with v 3 you need to configure the DAAB first, making changes to the configuration file. However, in a class library, I do not seem to have the web.config or app.config file to change. So where do I need to store the configuration settings?
Thanks,
Paul
Hi There!I have a big application which has two parts. A back-end developed in Deplhi 7 for desktop and a front-end developed in ASP.net C#. The problem I am facing is to integrate the login between both applications. I have a database that has the USER table with the PASSWORD encrypted and I've been already developed a Class Library with all the needs of Cryptography that has been used by the ASP.net application to authenticate users. The thing is, the desktop application has to authenticate the users too with the very same cryptography method, but Dephi cannot use dotNet assemblies (?). The client of the application ask to not use a web service and I'm trying to do this cryptography on the data base.The question is: Is there any way to invoke a dotNet Class Library through a SQL Server 2000 Stored Procedure?Consider that the Dephi developers had researched some ways to use dotNet assembly inside their application with no success. They had tried to develop their own cryptography method based on the algorithm that I had said them, but the encrypted string is different. Whenever the application try to match the strings, it doesn't work.Do you have some idea guys?Thanks in Advance! Ramon Silva
View 1 Replies View RelatedGood Morning..
We're having a heck of a good time trying to implement our first CDE project in SSRS 2005.
In our SDE class library we have included an App.Config file where we want to store configuration settings..
Trouble is that when we view the configuration settings or connection string settings in debug mode, they're not being read for some reason..
Here's our app.config file:
-------------------------------------------------------------
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<appSettings>
<add key="eventLogName" value="FocusDPEEventLog" />
</appSettings>
<connectionStrings>
<add name="PassConnString" connectionString="Data Source=SOMEDATASOURSE;Persist Security Info=True;User ID=SOMEUSERNAME;Password=SOMEPASSWORD;Unicode=True"
providerName="System.Data.OracleClient" />
</connectionStrings>
</configuration>
-------------------------------------------------------------
Here's what our Immediate window Debugger is tellin' us about our configuration settings:
-------------------------------------------------------------
ConfigurationManager.AppSettings
{System.Configuration.KeyValueInternalCollection}
[System.Configuration.KeyValueInternalCollection]: {System.Configuration.KeyValueInternalCollection}
base {System.Collections.Specialized.NameObjectCollectionBase}: {System.Configuration.KeyValueInternalCollection}
AllKeys: {Dimensions:[0]}<----incorrect should be 1
ConfigurationManager.ConnectionStrings
Count = 1 <----ok, is one, but the wrong 1, see 3 lines down...
base {System.Configuration.ConfigurationElementCollection}: Count = 1
ConfigurationManager.ConnectionStrings[0]
{data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true}<--Should be PassConnString
base {System.Configuration.ConfigurationElement}: {data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true}
ConnectionString: "data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
Name: "LocalSqlServer"
ProviderName: "System.Data.SqlClient"
Now notice the stuff in bold...I have NO IDEA where this gosh-danged thing is reading, but it doesn't seem like it's the app.config file in our class library...
thanks..
Doug
Good day everyone,
I have a package that loads data from a flat file, performs some transformations and then inserts the final data into a DB destination. The keys for the different DB records are generated in Script components in the Data Flow Tasks.
My question is concerning the Key Generation and I'll try to explain it on a simple example.
Package Structure:
The Control Flow contains two Data Flow tasks.
Each of the Data Flow Tasks contains a Script Component responsible for generating the keys of the records to be loaded during this data flow.
The code of the Script component is the following:
Code Block
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Public Class KeyGenerator
' Field Definitions '
Private seed1 As Integer
Private seed2 As Integer
' Constructor '
Public Sub New(ByVal dbSeed1 As Integer, ByVal dbSeed2 As Integer)
.....
End Sub
' Generates the keys according to the seeds retrieved from the DB '
Public Function getNextKey() As Int64
...
...
Return generatedKey
End Function
End Class
Public Class ScriptMain
Inherits UserComponent
Private generator As New KeyGenerator(7, 5)
Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
....
Row.NewKey = generator.getNextKey()
End Sub
End Class
Questions:
As you can see the KeyGenerator class code gets duplicated in each Script Component, which is definitely a bad practise. What I wish to do is to create the KeyGenerator class and deploy it as a library "somewhere". Then, in each Script Component, I should only import the KeyGenerator class.
1. Is that possible?
2. If yes, how can I do this?
3. If not, what is a best practise you would recommend which allows me to avoid this code duplication of the KeyGenerator class?
Thanks in adavance,
Samar
In SSIS can one create €œuser defined functions€? €œsubroutines€? and put them in the SSIS designer for other developers to use?
TIA,
Bill
HI,
I'm trying to get data from AS400. using OLEDB source as my connection. i'm using IBM OLEDB provider for iSeries. and working on standard edition of SQL Server 2005.
While using OLEDB source task when i set my access mode to 'table or view' and try to see list of available libraryname.tablenames, i do not get and tables
where as when i use Data access mode as 'SQL Command' i can get data (can only see preview of data) from AS400 but not able to insert that into my destination table. At run time task Fails with the error mentioned below.
I have configured Data links tab inside the OLEDB connection manager also, but when tried to set a default library it gives me error. : "Error code :CWBZZ5042" - ( catalog is invalid ) but it does exist.
Is there some settings that needs to be done from AS400 side or SQL Server side to view the available libray and its tables ?
Can some one help me on the same.
thanks in advance
Shah
Error Message received when executed with SQL command:
Error: 0xC0202009 at Data Flow Task, OLE DB Source [1]: An OLE DB error has occurred. Error code: 0x80040E00.
Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.
Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.
Task failed: Data Flow Task
hello all
i need to execute a ssis(sql 2005 integration service) on a document document library . can you people help me out how i can do it
i want to make a work flow which initiate when new document upload in a moss document library and this work flow pass the document to a ssis package and initiate that ssis package
note: the database and moss servers are on different machine
please reply ASAP if there any way to do it.
thnaks
I am working to develop an application using dotnet framework 2.0 that requires loading tab delimited text file (generated on each user action) in to table of SQL Express database. I am thinking to use SSIS library (Managed DTS) to call my SSIS package from within my application to load this data on each user transaction. This should be noted that I am not hosting my packages in to SQL Express.
Microsoft allows redistribution of SQL Express for free. Do I need any SQL Server or any other type of license for using SSIS library from my application?
-Faisal
Hai Guys,
I have a doubt Regarding SqlDataReader
i can able to create object to Sqlconnection,Sqlcomand etc...
but i am unable to create object for SqlDataReader ?
Logically i understand that SqldataReader a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.
sqlDatareader belongs to which class is it sealed or static class?
can we create own class like SqldataReader .......
Reply Me ...... if any one know the answer..............
I am using SSIS 2008 R2 & SQL Server 2008 R2. When I run the package in bids it runs fine but when I try to execute this package from agent job I get the below error message. In the job execution options I tried using 32-bit runtime that didn't work either.
Connection String for Ole db source"Data Source=Test;Initial Catalog=DB_SSIS;Provider=SQLNCLI10.1;Integrated Security=SSPI;Application Name=SSISDataLoad;"
Error Message:
Executed as user: Domainusername. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4033.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved.  Â
Error:     Code: 0xC0209302    Source: SSISDataLoad Connection manager "DB_SSIS"    Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider
SQLNCLI.1 is not registered. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Code: 0xC020F42A . Source: SSISDataLoad Connection manager "DB_SSIS"    Description: Consider changing the PROVIDER in the connection string to SQLNCLI10 or visit
Hi,
Anyone who can tell me why I get this error !
I can connect to Integration services on the server from another client.
Pls help
//T
Got above error on clustered sql2k5 x86 when connect to SSIS, any solution?
View 2 Replies View RelatedMy proxy class returns web service responses well if I use it in a C# code.
I compile it with CSC and put it in GAC to use it with SSIS.
Then I get web service response with some field values populated with "Exception of type :{System.InvalidOperationException "' occured.
Here is the part of web service response received by the C# program:
Name
Value
Type
mainAddress
{Address}
Address
city
Metuchen
string
cityField
Metuchen
string
country
USA
Country
countryField
USA
Country
state
NEW_JERSEY
State
stateField
NEW_JERSEY
State
Here is the same object returned by compiled dll used in SSIS:
mainAddress
{BrokerConnectServiceV1.Address}
BrokerConnectServiceV1.Address
city
Metuchen
String
country
{System.Nullable(Of BrokerConnectServiceV1.Country)}
System.Nullable(Of BrokerConnectServiceV1.Country)
HasValue
FALSE
Boolean
Value
Exception of type: '{System.InvalidOperationException}' occurred.
BrokerConnectServiceV1.Country
Data
{System.Collections.ListDictionaryInternal}
HelpLink
Nothing
InnerException
Nothing
Message
Nullable object must have a value.
Source
mscorlib
StackTrace
at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
at System.Nullable`1.get_Value()
TargetSite
{System.Reflection.RuntimeMethodInfo}
state
{System.Nullable(Of BrokerConnectServiceV1.State)}
System.Nullable(Of BrokerConnectServiceV1.State)
HasValue
FALSE
Boolean
Value
Exception of type: '{System.InvalidOperationException}' occurred.
BrokerConnectServiceV1.State
Below is another posting by my associate on the same issue :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=536615&SiteID=1
Any help is appreciated....
Hi,
Can anyone tell me where I might find the Class and Sequence Diagrams for the SSIS framework (for Custom Components)?
I've just started trying to create some Custom Transform Components and
I'm really struggling to get my head around the component lifecycle
(i.e what methods are called when, with what arguments, and why) with
just the BOL documentation to guide me.
Thanks in advance,
Lawrie
Does any one inherit SqlDatasource class?
I treid it as :
public class MYDataSource : System.Web.UI.WebControls.SqlDataSource
{public MYDataSource(){
}
}
Debugger dont give any error or warning when i buld project. But when i use it in a page Visual studio is crashed.
Can any one help me ?
Historically I've always written a VB script to copy a file from a sharepoint library. I don't like this method because I have to input a username & password in the script and maintain a config file.
Yesterday I was playing around with using a file system task. The sharepoint file has a UNC path so why not? I created a simple test package with a single file system task that copies the sharepoint file (addressed via UNC) to another network location. Package runs fine locally.
I try running on our utility server but am getting a "The file name [SHAREPOINT UNC PATH] specified in the connection was not valid" error. Package is running with a proxy on the server and the proxy account has the same permissions to the sharepoint site (so far as I can tell) as me.
Hello,
I recently joined a company that is having an issue connecting to SQL Server Integration Services on one of their production servers. When trying to connect via management studio, both locally and remotely, they receive the error below. The server is a 64 bit server and is using third party replication (Veritas).
It sort of sounds like the issue described in this knowledge base article: http://support.microsoft.com/kb/919224. However, we do not have a problem creating maintenance plans. I'd just give it a shot but its a production server and getting approval to do anything that modifies the registry with the registry replication setup is a pain, so I'd like to determine if there could be another cause first.
TITLE: Connect to Server
------------------------------
Cannot connect to ***************.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)) (Microsoft.SqlServer.DTSRuntimeWrap)
------------------------------
Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)) (Microsoft.SqlServer.DTSRuntimeWrap)
------------------------------
BUTTONS:
OK
------------------------------
Hello Chaps,
I am using vb.net 2005 and SQL Server 2005.. I have deployed some of my packages on the server.. Now if i am trying execute packages with SSIS object model from any of developement PC they are executing perfectly. But as soon as i am trying to execute them from client pc - where no any component except (.netframwork) -- i am getting the follwoing error:
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E}
Can any one help me out..? i have gone through some of the article stating that SQL client componet must be installed on the computer from where app runs...
Is there any other solution to use SSIS object model...
Let me know if any one you have...!
Thanks,
Tarang Pandya
Hi!
When I use dbrpcparam to add empty string as a parameter to a stored
prosedure, as a result I have NULL, but I need to get an empty string.
It seems to me the DB library for C does not allow to pass an empty
string as a parameter of a stored procedure. It gets converted to NULL. ??
Do you know how I can avoid the problem?
Thank you.
Anny.
I am porting the proC programs from Oracle to C on windows. Does anybody know that If I am using DB library for C, does it support the dynamic binding of the table and conditions like Oracle`s embedded sql ( 4th method?)
ex: select unknown columns from unknown tables
where unknown colum= unknown value
Thanks.
We are looking for an ETL library or callable application that wouldallow us to transfer and transform data between platforms but mainlyinto a SQL server database. We would be calling this tool fromjavascript programs. Is there something out there in the midrangeprice-wise? So far I am finding just high-end ETL tools that are alittle over kill for us.Thanks.
View 4 Replies View RelatedThis is not an actual question but more of a topic that I cannot find any information on and that may be because there is nothing about it.Basicly is there any SQL Database Table Libraries out there?......For instance I am creating a tedious database table right now which includes the names of all the countires (around 200 ) its simply used for a registration process where a users country information gets saved in the database...Since the worlds country names do not get changed very much is there a sql database table out there thats pre-made so I dont have to sit here and enter in all 200 or so countries by hand?....this is what I mean by database table libraries, it can basicly include all common things a website may use like a province/state dropdown list (pre-made database table), the worlds countries (again pre-made database table) and so on....If someone can come to my rescue and help me find some information on this it would be great cause well It's probably going to take a bit to enter in every country name, then the same for all the provinces/states, then bind them somewhat so when a user clicks on canada the provinces/states for canada are only avalible in the next list.Thank You All.Adam
View 2 Replies View RelatedI have been receiving the following error when I look into the NT error log
and I am not sure what it is referring to. First thing that happens is that I receive
an error that my Open Objects may be too low and then the following error:
DB-LIBRARY error - SQL Server connection timed out.
The source listed is SQLCTR60.
Can anyone help with this error???
Hi,
I have the following problem:
Anytime I`m starting the PC, the following message appears:
"SQLDUMPER library failed to initialize.....TRY TO RE-INSTALL THE FILE"
Could anyone help me deal with this? What should I do?
thank you, Enno
email: ebozdo@yahoo.com
Does anyone know if this SQL is part of MS Office or is it XP... I haven't figured that out. It says reinstall the program but doesn't say what program. I know I never intentionally installed an SQL program.
At this time I get the same message as everyone seems to be getting - SQL Dumper Library failed... reinstall ....
The problem for me started when I added Office 2007 and added the business contacts program.
Any ideas are appreciated!
when i start up my computer it displays the message sqldumper library failed initialization. your installation is either corrupt or has been tampered with. uninstall then rerun setup. what do i do?
View 5 Replies View RelatedHI all,i want to log different activities of my application like (order approved, order rejected etc) to a sql database using Enterprise Library 2.0.can anyone help me by giving a link(step by step procedure for this).or explain how to create my own sample application to log some event to DB(by creating a new database and tables for this).Thanks in advance.regards,Jon.
View 1 Replies View RelatedI have an application running on win 95/98 m/c which connects to SQl Server 6.5 Server on NT 4.0. From some of the client m/c i get an error message - 'DB-Library network Communications layer not loaded'. But from this client i am able to log on and use the enterprise manager. What could be the problem and how to resolve it ?
Thanks.
hi, I ran a query on a test database and got this error , does anyone tell me whatdoes it mean and how can I fix it
thanks
Ali
This command did not return data, and it did not return any rows
DB-Library Process Dead - Connection Brokenh
Hi All,
Would really like insights in determining how to fix the following problem.
( i did search the archives -- got nothing)
When I try to run query against the SQL server i get following message; Process 13 error "DB -library process dead", terminating connection.
Thanks a lot
Prasad