LoadFromSQLServer
Jan 4, 2002
I am trying to run a DTS package from a stored proc using the example within this web site. The following line is where I am receiving a problem:
EXEC @resultcode = sp_OAMethod @pkg,'LoadFromSQLServer("PASCAL", "sa", "", 0, , , , "DeleteInactiveFiles")', NULL
When I set the flag to 0 as in the example above and run the stored proc, it runs continually (I allowed it to run for over an hour) but never reaches the next line of code in the stored proc.
If I change the flag to 256 such as:
EXEC @resultcode = sp_OAMethod @pkg,'LoadFromSQLServer("PASCAL", "sa", "", 256, , , , "DeleteInactiveFiles")', NULL
I receive the error: Login failed for user 'NT AUTHORITY/SYSTEM'
What am I doing wrong?
Thanks for your help.
View 3 Replies
Jul 23, 2005
I have a VB.NEt Winform app deplyed on ServerA. I have a DTS packageon ServerB. When I try to load the package with:package.LoadFromSQLServer(serverB, uid, pwd,DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , , , , packageName)Where serverB, uid, pwd are variables set in the program and are valid,I get this errorDescription: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does notexist or access denied.Which makes no sense because I'm using SQL Authentication and I am1000000000% sure the uid and pwd are correct. Am I missing something?My VB app runs fine on the sql server but not anywhere else and I needto run it elsewhere against the db.
View 3 Replies
View Related
Aug 18, 2006
hi everyone,
I'm trying to load a dtsx from my front-end app but says the following:
pkg = app.LoadFromSqlServer(ActObject.packageName, "SRVDESASQL2005", "usrSSIS", "ninot", Nothing)
ActObject.packageName = "SSISdev"
usrSSIS is a sql user which own enough permissions over MSDB
Try returns me: "Specified package could not have been loaded in Sql Server"
Any ideas? I'm stuck.
TIA
View 1 Replies
View Related
Apr 13, 2007
Hi All,
I have created a SSIS package and deployed it on Sql server. I need to load this package from my C# code. when i am trying to execute following code it is giving error "Cannot find folder MSDBDevSAEMeyyDev1" .. whereas this is already present in side stored packages of server.
pkg = app.LoadFromSqlServer(@"MSDBDevSAEMeyyDev1", "BLRKEC36570D", "sa", "SAEuser123", error);
what could be the reason for this ?
Thanks,
Anshu
View 8 Replies
View Related
Aug 7, 2007
When I try to execute a package (in sql server) using DTEXEC I get the following error. The creator of the package is different from the executing user of the package. But I have also set EncryptionLevel FROM EncryptWithUserKey TO DontSaveSensitive (Which I assume should resolve this issue), re-imported the package to sql server, but the error remains the same. Any pointers?
The utility was unable to load the requested package. The package could not be loaded.
Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 3:18:56 PM
Could not load package " est1" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80040E14 (Only the owner of DTS Package 'test1' or a member of the sysadmin role may create new versions of it.). The SQL statement that was issued has failed.
Source:
Started: 3:18:56 PM
Finished: 3:18:56 PM
Elapsed: 0.328 seconds
View 5 Replies
View Related
Sep 1, 2006
Hi everyone,
I was wondering what kind of events fires when you do a LoadFromSqlServer method??? I've got defined a Events class but debugging with F11 never get in touch with any event (apparently or mabye the problem
is that I haven't declared that concrete one)
Let me know if possible or not. I provide you my snippet of code:
Dim pkg As New Microsoft.SqlServer.Dts.Runtime.Package 'Para que no choque con el objeto APPLICATION DE SYSTEM.WINDOWS.FORMS
Dim app As New Microsoft.SqlServer.Dts.Runtime.Application
Dim EventsSSIS As Eventos
EventsSSIS = New Eventos()
..
..
pkg = app.LoadFromSqlServer(ObjSSIS.sRutaDts & "" & ObjSSIS.sSSISName, ObjSSIS.sServer, "usrSSIS", "aaa", EventsSSIS)
..
..
Public Class Eventos
Implements IDTSEvents
OnTaskFailed(ByVal taskHost As TaskHost) Implements IDTSEvents.OnTaskFailed
OnWarning(ByVal source As DtsObj
OnPreValidate
..
..
Thanks in advance,
View 4 Replies
View Related
Dec 19, 2007
Hi all,
I need one more help!
we can select the dtsconfig file with the Environment variable(indirect configuration);
but i need to select the configuration file at runtime; i've to load the package from the server and apply local configuration file to the package and run in a web server;
Requirements;
1. i have packages with its xml configurations for connection strings alone!
2. i deployed it on the server
3. Trying to execute the packages in a web page onclick event;
We have ASP.net WebPage; in On_Click Event, i have this code;
Application ap = new Application();
Package pk = ap.LoadFromSqlServer("\PROJECT", "itsssqldb", "pmo_package_user", "password", null);
pk.ImportConfigurationFile(@"Packagesdev_staging.dtsConfig");
pk.Execute();
here PROJECT is the Package name; i'm loading the package from the Common Sequel Server 2005; and applying the configuration file to that package and trying to execute this;
but its not using the config file what i mentioned; its returning failure!!
Can you please help me to resolve this issue!,
(The intention of doing this job is to select the configuration file( prod, dev) at runtime)
View 10 Replies
View Related
