Hi, all here,
I am having a question about the language in which external managed code written can interact with SSIS? Is it only applications wrriten in .NET-compliant language can interact with SQL Server Intergration Services packages?
Thanks a lot in advance for any guidance and advices for that.
With best regards,
Yours sincerely,
Can you put is a call withing a Data Flow that will call an External Application and pass a parameter to that application IE say a command line app and then take the output and assign it to back to the flow as a "column" or whatever for that row... IE I want to take a value push it to an external app and then the output from that app I want to insert it into another field for that row in the new table I am moving the data to.
View 4 Replies View RelatedWhen my SQL Agent job completes successfully, I'd like to send a notification to QlikView. The idea is to stop QlikView having to constantly check if the job has been run, and just get notified when it needs to update its data.
I don't know how to start. Can the job notifications push a success message to QlikView? I don't think I want to send an email, but something that indicates to QlikView to update the tables.
I have the need to restore a database to a user's laptop on a dailybasis. This has been no problem using Enterprise Manager. I found astored procedure to run the restore and tried to call it from a visualbasic program. While I can connect to the database, I get an errortelling me "exclusive access could not be obtained because thedatabase is in use".Does this mean the only way to run the restore is via EnterpriseManager?Thanks,Tom
View 1 Replies View Related
Hello,
In my database (SQL Server 2005), some data were inserted from a external application.
In order to validate the data , I want to get the SQL statment executed by the application.
Is this possible?
Thanks
Robert
I have a custom external application that executes some packages. I would like to display the execution progress as it would appear in the Progress tab of the SSIS designer. How would I do that? Any help is appreciated.
View 1 Replies View RelatedI know very little (so far) of SSIS but a co-worker suggested that it was VB.NET used to write scripts in SSIS. Is this true, or is there a selection (maybe C# as an alternative), or is it some other type of script language?
From what little I remember of DTS, I thought it was a pseudo-VBScript language used to write code for it (but I can't really recall).
I would appreciate anyone getting it straight in my head.
Thanks,
Ron
I am new to SSIS programming, so bear with me if my question seems naive to you gurus. I have a situation that needs to set the data source for a data flow from external .NET application ('external' means that the application will run on different process than the SSIS). I am trying to set the data source on which the data flow works from my C# application in a DataSet format. Ideal solution is not to save the DataSet to any file on harddisk (I know that will work, but has the overhead of writing, reading and managing the temp file). What I want to achive is that the business logic of picking data for SSIS Data Flow to process is controlled inside my C# application, the Data Flow just does what it does best - Transformation. Have any of you successfully done this before?. Thanks!
View 1 Replies View RelatedThis is how I used to create DTS in SQL SERVER 2000 and then create a job for scheduling.
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
url="http://www.pageName.com/abc.aspx"
set xmlhttp = CreateObject("MSXML2.XMLHTTP")
xmlhttp.open "post", url, false
xmlhttp.send ""
'msgbox xmlhttp.responseText
Main = DTSTaskExecResult_Success
End Function
Now how will I do the same in the SQl SERVER 2005.
Please help as it is very critical to my work.
Thanks in advance.Manpreet
Hi there,
I'm trying to come up with the best way to build some C# Unit tests for an SSIS package I've built.
My C# code does the following
1. Creates a Transaction Scope using System.Transactions
2. Puts some source data for my package into a table that the package will read
3. Kicks off the Package using System.Diagnostics.ProcessStartInfo
Im getting a Transaction TimeOut execption which I beleive is caused because the Package can't read the source data I've inserted becuase the package has not joined the transaction.
So the question is - can you call a run a package and make it participate in a transaction that you have created outside of the package?
Thanks.
good idea or bad idea?
View 2 Replies View RelatedHi,
I worked with informatica before and bit new to SSIS,
i have one simple question..
How can i achieve the same functionality as External Procedure Transformation (Informatica) in SSIS?
like..i want to use a DLL in my package which contains some set of business rules.
Please let me know.
Charles
Thanks
View 11 Replies View RelatedHello all you SQL gurus...
I am looking for a program that would allow me to have a simple GUI to interact with my MS SQL database. All I really need it to do is allow other individuals to update customer's data in a SQL table using a simple interface to interact with. They would type in the phone number of a customer and search for the record.. once the record comes up they would be able to update the name, address, or post a payment that the customer made.
can anyone point me in the right direction??
thank you in advance for your time!
joshua
Local server accounts. I'm building an instance that doesn't interact with other servers, services or resources on our network. Can I use the local service account as the project manager doesn't want to use normal AD service account that we normally use. As the instance won't interact with any other server etc would this create any security issues? The project manager would also "...prefer SQL to run under the least privileged account possible".
View 3 Replies View Relatedhow can i communicate with other clients over SQL 2005?
I mean, i change data of database from a client, how to make othere clients do some actions acording to the data change .( let other client print some report ect.)
Thanks
I'd like to replace a simply data mining model that uses the clustering algorithm to group a discrete variable with a fact dimension in the cube. The model uses K-means with a cluster count of 10. From what I've read, AS uses the same algorithm when DiscretizationMethod is set to Cluster. However, the DiscretizationBucketCount doesn't seem to behave the same as the cluster count in the model. For example, setting DiscretizationBucketCount to 10 results in 4 clusters in the dimension. Can anyone explain how these two dimension properties interact?
View 1 Replies View RelatedWhat sort of things would it interact with to justify having this ticked as the sqlserver.exe seems to be consuming all the CPU constantly and some suggestions have said that having this ticked can cause a performance issue.
View 3 Replies View RelatedHow to design at database level such a way so that when I implement a SQL query that returns one hundred thousand rows only display 25 rows at the client (Web page at a time). How can I accomplish this?
Once I display first 25 rows then how do I bring next 25 rows and so on. Can it be done via paging or there are other techniques. However I asked to design this in the database level. I am using MS SQL Server 2008. Front end Visual Studio 2010. I use C# for coding.Â
Hi,
I want to use output of SSIS package in Windows application, any suggestions?
For this I have created SSIS package and loaded data into DataReader destination, but now how to use this data in my application.
Thanks in advance.
Regards,
Omkar.
Is there anyway I can integrate the ssis in Web applications or Windows applications?
Thanks
Hi,
Is it possible to use an SSIS package in a .NET application without install sql server?
Thank you in advance
Hello, is it posssible to execute SSIS packages from ASP.NET ? Which code should I Use?
View 4 Replies View RelatedHi everybody,
I have the following method and it works well on my development workstation ;
Code Snippet
private DataTable ilaclariGetir(string dataReaderDestination) {
string dtexecArgs;
DtsConnection dtsConnection;
DtsCommand dtsCommand;
IDataReader dataReader;
DtsDataParameter dtsParameter;
DataTable dataTable = new DataTable();
dtexecArgs = @"/FILE ""C:TempEczaTakipProjessisPaketleriPackage.dtsx""";
dtsConnection = new DtsConnection();
{
dtsConnection.ConnectionString = dtexecArgs;
dtsConnection.Open();
}
dtsCommand = new DtsCommand(dtsConnection);
dtsCommand.CommandText = dataReaderDestination;
dataReader = dtsCommand.ExecuteReader(CommandBehavior.Default);
// IDataReader 'ın buradaki gerçekleştirimi diğer dataReader 'lardan farklı. Kayıtlar okunurken son kayıt okunmasına rağmen
// read() metodu bir kez daha true dönüyor ve kayıt sayısı + 1 tane okuma yapılıyor. Yapılan son okuma da istisna fırlatıyor.
try
{
dataTable.Load(dataReader);
}
catch (ApplicationException ae)
{
}
dtsCommand.Dispose();
dataReader.Close();
try
{
dtsConnection.Close();
}
catch (Exception ex)
{
}
return dataTable;
}
However it always fails after I publish the asp.net 2.0 application to our Win 2003 Server. I also copied the configuration and dtsx file to proper location on the server.
I can use dtexec to execute the package without any problem on the same location.
But when called from the application, the package fails to validate.
Is it about a user- permission problem ?
Hi..
I have Created an SSIS Package to Backup a database..
I want to execute that SSIS package from a .net application
How can i do this??
Hello
I have a SSIS-Package stored in the SQL Server. This package works fine when i execute it from the SQL Server. But if I try to execute the package from a COM+-Application, nothing happens.
Here is my code snipped:
Public Function ExecutePackage €¦
Dim myPackage As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult
'----- Execute the package from SQL Server
myPackage = app.LoadFromSqlServer("\PackageName", "ServerInstance", Nothing, Nothing, Nothing)
pkgResults = myPackage.Execute()
€¦
End Function
In a Windows Forms Application I can execute the package with this code snipped succesfully. Therefor I think that the problem is my COM+-Application.
Can anybody help me?
Thank's
Jürgen Paulus
We need to launch SSIS packages from within an application. As a DBA I am trying to come up with a solution that is easy to implement and will fit security best practices. Here are the possibilities that I see:
Launch dtexec via xp_cmdshell. This is the one all developers come up with first. It is not possiblebecause use of xp_cmdshell is restricted to DBAs only.
create a table into which application can insert the dtexec command. Create a job to check the table every minute and run the command via xp_cmdshell. Developers don't like this one because it is not instant.
Same as above but launch the job with sp_start_job. Not allowed because sp_start_job requires sysadmin rights.
Create a table as above but launch the packages via a service that runs on an application server. The service
checks the table and launches the packages. Fairly complex to put together and requires dtexec on the application server.
Install dtexec together with the front end and launch the packages from the client. Too expensive because dtexec requires a SQL Server license.
Create a CLR procedure that launches the package (don't know how difficult this would be and what the pros/cons are)
Does anyone have any other suggestions or comments on my assumptions?
hi, does anyone know if an ssis pkg can be executed from a java or .net application?
View 5 Replies View RelatedI have a SSIS package that I want users to be able to execute by clicking a button on an a web page. The package does not require any parameters to be passed to it. Previously I've executed DTS packages without any problems but after a fair bit of investigation and trawling the net I've not found a way to do this successfully with SSIS. Some code I've tried - Dim app As New Application()
'
' Load package from file system
'
Dim package As Package = app.LoadPackage("c:ssisPackage.dtsx", Nothing)
'package.ImportConfigurationFile("c:ExamplePackage.dtsConfig")
'Dim vars As Variables = package.Variables
'vars("MyVariable").Value = "value from c#"
Dim result As DTSExecResult = package.Execute()
lblResult.Text = "Package Execution results: {0} " & result.ToString()
All I get is a message 'Failure'.
Does anyone have an example of how to do this?
Hi all,
I wish to pass parameter from a dropdownlist in my web application to the SSIS package so as to export the user specified table.
Is using package configuration the right way to do this?
Any advice is appreciated!
I have an asp.net web application and a web service (both of them are created in VS 2005 - asp.net 2.0). They are located on the same web server. In both web.config files, I have set <authentication mode="Windows"/> and <identity impersonate="true"/>. Also, configured the IIS settings to use Integrated Windows Authentication and unchecked the Anonymous access (for both). The web service is called from the web app, so I have to pass credentials for authentication to the web service. The web service loads and executes a SSIS package. The package and all the other sql objects are located in the sql server 2005 (windows server 2003 - the same server as the web server).
When run the web service from develop environment (vs. 2005), I get whatever I expected. When call it from web application, however, the package failed (no error message).
In the SSIS package, there are three connection managers €“
· A: Microsoft OLE DB Provider for Analysis Services 9.0 Ã connectionType=OleDbConnection
· B: .Net Providers SqlClient Data Provider à connection type=SqlConnection
· C: Native OLE DB Microsoft OLE DB Provider for SQL Server à connectionType=OLEDB
After ran the web application and check the sql database, I can tell that the package was reached and when through the first two steps (clear some records in table_1 and extract some records from table_2 ) which relate to the connection manager B €“ ADO.Net connection. The remaining steps failed which are related to the connection managers A & C.
From SSIS package log file, found that the user credentials (domain and username) were correctly passed from web service to sql server 2005 at the first two events, but the credentials (or operator) changed from domainABCuser123 to NT AUTHORITYNETWORK SERVICE after packageStart. Then, it complains €¦ either the user, domainABCserverName$, does not have access to the database, or the database does not exist.
I think the credentials are passed ok but some setting related to the Analysis services are not correct - complaining start from there. Any clues?
Please help and thank you all!
Hello,
Hopefully someone can help. I am not new to SQL Server, but am new to SSIS packages. As one step of my package I need to open and run a windows application. No problem there right? But, my problem is that I cannot get the "focus" returned back to the SSIS package. It doesnt move on to the next step until I close the windows application. It is like the package is the parent object waiting for a "finished" message from the child object, and it doesn't receive that message until the child object is closed. I've tried using a batch file to run the app and calling the batch file from an Execute Process Task, but that doesn't move onto the next step until the dos command prompt window closes and I can find a way to automatically close it from XP. I also can't find a way to kick off this windows app from a script task using command line. Not sure if I would run into the same problem going that route or not. If anyone can help, i would appreciate it.
Thanks
JK
Hello All,
I have a SSIS package which run well when stand-alone. However
it was failed when executed from .NET web application. It just simply return Failure. Code snip below:
Dim packagekgResults As DTSExecResult
.........
packagekgResults = package.Execute()
Environment: Windows 2003 Shared Server, IIS 6.0
Any idea?
Thanks in advance!
Tina