3rd Party Components/API Support In SISS
Jun 11, 2007
Greetings,
I was just getting through the features of SSIS, i wanted to confirm a few things
can i make my own dll in .net (version 2.0 or earlier) and use them im SISS via Execute Script?
thers is one thing i saw on msn that i can make my ssis packages reusable by adding them on mt tool box and drag drop use them on other ssis packages. correct?
can i use any other 3rd party components like APIs, or some other ETL tool's package in SISS ?
regards,
adnan shamim
View 3 Replies
ADVERTISEMENT
Oct 10, 2007
hello all -- I'm an SSIS newbie who is exploring (custom) programming functionality through third party components, to be plugged into SSIS, for SMTP, FTP, PGP, TAR, WinZIP, basically for a scheduling & automation utility.
Is there such a concept of third party components (and marketplace for this?) or is VB a much better choice for this vis-a-vis components variety, $$ and robustness ?
thanks much,
Cos
View 1 Replies
View Related
Mar 29, 2007
I've been having an issue with the integration of a third-party DLL into a custom data flow component.
The company sent me a C# project that generates a simple console application. The project includes a class that calls their DLL with DllImport. The console application runs fine.
I created a stand-alone class using the C# class they sent to expose the methods of their DLL. In my custom component, I'm referencing this class to pass data to and from their DLL.
The first method from that stand-alone class that my component encounters simply gets their installation path from the registry and does not use DllImport. That path retrieval works fine. The next method calls a function that is declared with DllImport. Each time the call fails with "System.DllNotFoundException = {"Unable to load DLL AMZip.dll': Exception from HRESULT: 0xE06D7363"}".
I've copied this DLL to countless locations (e.g., the PipelineComponents directory, the project/solution bin directory) and included these paths in all manner of path variables.
What am I missing here? Their DLL is not strong named (does this matter since I'm using DllImport?), my stand-alone class is, and of course, the custom component itself is. I appreciate the help.
View 9 Replies
View Related
Sep 7, 2006
Everything I've read says that custom data flow components are built by inheriting from the Microsoft.SqlServer.Dts.Pipeline.PipelineComponent class.
But the stock components such as the Derived Column data flow transformation must each be implemented by their own class. So how do I base my custom components on those classes? The documentation for the PipelineComponent class doesn't list any such subclasses.
View 1 Replies
View Related
Jun 30, 2006
Hi,
In another thread Jamie Thomson very informatively said "The components in SSIS
are deliberately atomic (i.e. they do something very specific) so that
its easy to put them together to build something greater than the sum
of the parts". Which does make a lot of sense. However, I've been finding that I end up having to create exactly the same "pattern" of combined transform components again and again in order to solve the same problem but in different dataflows (or even within the same dataflow). Cut-and-paste-tastic! In order to obtain real re-use, it seems to me like SSIS is crying out for an easy way to create new components by using composition - i.e. the ability to take commonly-used combinations of existing components and create new "super" components (without having to write Custom Transform Components in C#/VB.Net and handle everything in code).
Does anyone know if this sort of functionality is likely to make it into SSIS in the forseeable future?
Regards,
Lawrie
View 6 Replies
View Related
Dec 5, 2005
Reader Community
I've just started hosting my newly created Microsoft Visual Web Developer 2005 Express Edition web site. Unfortunately the Login group membership functions will not function correctly. Having contacted the web service hosting provider, They replied: "We do not support SQL express2005. The only way to use the extra functions of ASP.NET2 such as group membership is if it is using an SQL 2000 database to connect to. "
Is it possible to design web sites with Microsoft Visual Web Developer 2005 Express Edition that store membership details on an SQL 2000 database?
I've just paid £88 approx. $140 for a years subscription, have I chosen the wrong web service hosting provider?
Should I have designed the web site with a better web site design software tool that also makes designing membership login functionality easy, just as Microsoft Visual Web developer 2005 express edition?
Look forward to all comments?
Regards
Philip
View 1 Replies
View Related
Apr 3, 2008
I am trying to schedule a SISS package by creating a new job but it is giving me error when the job executes.the error i find when i checked the error log it was the following error
Unable to find index entry in index ID 1, of table 2073058421, in database 'msdb'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support. [SQLSTATE HY000] (ConnExecuteCachableOp)
Any help would be appriciated
View 3 Replies
View Related
Nov 20, 2007
Hi All,
Can anyone tell me how i can do Pre Post Command in SSIS. Even If i want to Manipulate the File before running the Task with sum input values or Want to Do Post Command after Running to Task
View 1 Replies
View Related
Mar 1, 2006
Hi
Can someone please help??
I have a small package that makes an OLDB connection to my local 2005 SQL server then does some processing and places the results in a text file as XML
I have created a stored proc that uses xp_cmdshell to call the package and pass a paramter to it.
It all works fine when I call it from the command line or execute the stored proc from SQL Management Studio or if I call it as part of a SQL Agent job, but when it is called from C# from an ASP page then it fails with a timeout error.
Even stanger is the fact that when there is no data there for it to process it runs OK so I dont think it is permissions but the size of the output file only has to be a couple of k for it to fail from the ASP page.
If we comment out some of the functions in the package then it will execute OK from ASP
Help Whats going on ??
View 1 Replies
View Related
Dec 20, 2007
I need to run SISS for example every day at 5pm, I run SQL Agent and created new job for my SISS package which store in SISS Package Store on SQL Server, but when this job run I go error:
Log Job History (Test SISS)
Step ID 1
Server ADMNBK-010S
Job Name Test SISS
Step Name Run SISS Mobius
Duration 00:00:02
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: ADMNBK-010SSYSTEM. The package execution failed. The step failed.
if I run SISS package from SISS Package Store "by hands" it works...
View 5 Replies
View Related
Apr 6, 2006
Hello,
I am experiencing that my SISS packages are executing faster during development from within the Sql Business Intelligence Development Studio environment than when I execute them with dtexecui after I have deployed them as either File System Or Sql Server deployments.
After deployment the packages run about twice a long as they do from within Sql Business Intelligence Development Studio (i.e they reference the same data and are executed on the same machine).
In short the packages import data, during this import stage the data is massaged certain calculations are performed thereon where after this massaged data is used to perform further calculations.
A summary of tools used in SISS are Execute Sql Task, Flat File Source, Oledb Destination, Data Conversion, Aggregate, Conditional Split, Merge, For Each Ado Enumerators, Script Tasks, Derived Columns and Recordset Destinations.
In terms of time from within Sql Business Intelligence Development Studio when the packages are executed for 1 month's data the total combined time is about 10 minutes and when deployed as either File System Or Sql Server deployments they run for about 20 minutes. My problem is when they are executed for a years data instead of running for 120 minutes they run for at least 240 minutes or longer.
Is this normal or am I missing some settings when building the package for deployment?
Luke.
View 3 Replies
View Related
Oct 23, 2007
The system I had developed is having a data flow as following:
Source received as file, .dat file
For better performance I€™m doing little transformation between .dat file to SSIS Raw file then from Raw files doing Type2 and Type3 mappings to adhere the business rules and loading the data to destination tables.
The .dat file I receive (there are many file some where around 25 file) is dumped in a folder as €œsource€? and the Raw file are in other folder as €œSSIS files€?.
My concern is the source folder size is 6GB and the same files converted in SSIS raw files format present in SSIS FILE folder and the size of this folder is 10GB.
Why is that so? Where as there€™s no extra data and the transformations between source and SISS files are like substring for the different date format and data type conversion.
Any ideas, your help in this would be appreciated.
Thank you
View 5 Replies
View Related
May 12, 2008
Are there any draw backs to spawning additional threads inside of the script tasks for SISS packages?
View 4 Replies
View Related
Jan 8, 2008
Hi All,
I have a knowledge of SISS and CRM 3.0 but don't get any proper steps to create such Integration Service in SQL Server 2005 using CRM 3.0 as external data source.
I don't get any option of external data source for CRM.
So if anybody know about this then let me know steps to do that.
Thanx in advance.
View 5 Replies
View Related
Apr 7, 2008
I am trying to schedule a SISS package by creating a new job but it is giving me error when the job executes.the error i find when i checked the error log it was the following error
Unable to find index entry in index ID 1, of table 2073058421, in database 'msdb'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support. [SQLSTATE HY000] (ConnExecuteCachableOp)
Any help would be appriciated
View 3 Replies
View Related
Oct 8, 2007
I had created an Script Task to put data into the few variables then I created an SQL Execute Task to use the SQL query to collect data from a database. Now I want to put that data into a different database.
I noticed it can not be done because the SQL Execute Task is one object and the other object is Data Flow Task. (The Destination database is inside that object).
So, if it is possible then how? If not then what should be done instead?
Thanks...
View 1 Replies
View Related
Jun 22, 2007
can any one sugest Quering AS2005 Cube to generate CSV or Excel in SISS 2005
i have a mdx query that runs fine in SQLserver 2005 but when use OLEDN source in SSIS and connect to Flatfile source i am getting OLEDB exception is there any work arround i have SQL Server 2005 SP2 on Windows 2003
Any help is really appreciated
thanks in advance
View 4 Replies
View Related
Nov 1, 2007
Hi all,
Im currently using SQL server 2005 Management Studio. I need to export files from SQL database to Access database.
But I dun think SISS is installed. Can anyone advise where to look for the file to install? Thks in advance.
Wee
View 5 Replies
View Related
May 1, 2001
Hi All,
I have to load data from from a text file ( approx 3-5 million rows) into a table .
I can use straight bcp with the format file , but the loading of data has to follow some business logic
Let me know if there are any third party tool to load the data instead of regular bcp
I have SqlServer 7.0 on Windows NT 4.0
Thanks in advance
View 2 Replies
View Related
Oct 13, 2005
Does anyone know any software to backup single tables ? i recall one software that extracts the data into a text file called SQLinsert or something but wondering if they are others around ?
View 1 Replies
View Related
Apr 27, 2008
hello,
what are some good db managements tools that are available? I installed Toad from Quest and the Red Gate's toolbelt but I haven't play with them yet. I would like to know what is the most useful tool to invest time in.
Thanks.
View 1 Replies
View Related
Sep 12, 2007
Hey guys I really need your help.
We've outsourced our software last year, and it really a big mess for us since that company has been clashed. Then it so happened that the system failed to function well. Our batch transactions was working about 56 mins.. that is 24 records. Then it happened that this time 28 records was finished for about an hour. Our business hour is 8 hours only. That's why we have a back log now. We also failed to validate transaction since it takes a lot of effort before we update the database. It's working before but as our database becomes larger there are many errors occur in our application. Majority is runtime error. Then it happened that now we cannot move on anymore. We are using SQL server 2000 with VB6.0 application. our server memory is 1GB. Do you think adding additional memory will solve our problem?
Thanks!!
View 1 Replies
View Related
Jul 20, 2005
I prefer to write SQL code, without graphical tools.Have third party Query Analyzer that has filter and sort abilities?Also I looking for SQL editor with Completion ability (like we know forprogramming lang),for assist me write more quickly.
View 1 Replies
View Related
Oct 24, 2006
I am working on a SSIS package to move data between SQL2005 and DB2. I currently have the DB2 ADO .Net connector from DataDirect which works fine for connecting to the AS400. My question is that I am working on a script transformation and I want to be able to use the Connection already created in the package their.
I can set it up just fine using the properties for the script, but there appears to be no way to create SQLCommands and connections unless I reference the DataDirector DLL in the script, which requires adding it to the GAC and the Framework folder.
I am just wondering if this is the correct way to go about this or if there are any other recommendations. Please let me know if I need to supply more information.
Thanks,
Chris
View 1 Replies
View Related
Feb 27, 2002
Currently we are using SQL Servers Backup utility to backup our databases to disk and then the files to backup tape during a nightly backup.
The time it takes for the backups to disk to complete for the databases is becoming prohibitively long and performance problems on the DB server are manifesting.
I am interested in other solutions. However, the propaganda listed at the various companies sites are less than insightful.
I was wondering if anyone used a third party Agent like Brightstor Enterprise SQL Server backup agent, or Veritas NetBackup for SQL Server, that would be willing to give some recommendations. If you use something that isn't listed here and it works well, I would be interested in hearing about it.
Do these backup agents significantly slow down the database performance? Do they create any locking issues? Some insight into your backup hardware configuration would be helpful as well. Thanks in advance for your help.
View 1 Replies
View Related
Apr 11, 2002
I have been using the built-in tools of SQL Server (email and netsend) to monitor and alert me about some basic issues (like severity errors and job failures) with our SQL servers. We are now approaching a level and number of servers where I think we need to get a more global and more stable solution to monitoring and alerting.
So what third party tools are you are using to monitor your SQL Servers?
Thanks
SJ
shawn.johnson@kenexa.com
View 2 Replies
View Related
Sep 6, 2005
Hi All,
I am pretty new to SQL and would like a bit of friendly help, please. Am trying to set up a .Net web site that will have dynamic content supplied by a true SQL server (am using MSDE to build this first).
My issue is in building a search engine on my web site that will return hits from the content of the pages which are loaded in MSDE.
Is there a third party or open source search engine available?
Any clues for how to build (or beg, borrow or steal) a workable search engine to do this?
Many thanks,
Newbie
View 4 Replies
View Related
Oct 30, 2007
The only way I know of to debug a Sql 2005 stored proc is to create a VS2005 Database Project and step into it from there. Does anyone know of any third party tools that adds functionality to Sql Management Studio to step into stored procs?
View 5 Replies
View Related
Jul 23, 2005
Folks,I work on a system which is growing rapidly, with the number oftransactions we process growing on a daily basis. While this is goodnews or the business, maintenance is starting to become an issue as thedatabase is the backend for a website which cannot be down for alengthy period of time.While I do defrag the indexes, periodically the indexes do need to berebuilt. When this happens, the process locks pages and transactionsstart getting bounced out.Are their any third party utilities which will rebuild an indexwithout this locking occuring? Any help in pointing me in the rightdirection would be appreciated.
View 1 Replies
View Related
Jul 20, 2005
I am looking for a better way to schedule jobs in SQL Server. I foundthis tool called SQLschedule at www.idera.com and am using the 30 daytrial. This tool really has a cool GUI, and seems to work well. Doesanyone else have any experience with their tools?
View 1 Replies
View Related
Mar 19, 2007
Can SSRS be configured to use any third party .NET charting components or only ones that have been specifically designed for SSRS? I have seen a couple of third party charting software (Dundas, etc.) and while they are nice, they sell at a real premium and there are not many vendors offering SSRS charting. I was hoping for a bit better value and more of a selection to choose from.
R
View 4 Replies
View Related
Apr 24, 2008
We have a hosted SQL server with various internal applications on it. It has been decided by on high that the same server will also have a database from a third party on the server. The third party have asked for full system admin rights on the SQL server.
Obviously I am not going to grant that access level as it gives them full control on the box. From my viewpoint read and write access to the data can be tolerated but anything else will be denied. Would you consider this standard and is there any documentation with recommendations for control of external suppliers ?
I am sure that they shouldn`t be doing any work on tables structure, sp`s etc on a live database. That work should be tested, scripted etc and then run on in a controlled environment by my company.
Anyone have any advice ?
Thanks
SI
View 1 Replies
View Related
Apr 9, 2008
Hi,
I have a commercial data source 3 party one for me to extract data from , i have been provided the exe and the DLL how i can use this in SSIS as a datasource please let me know.
Thanks,
View 4 Replies
View Related
