Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







SSIS Package Cannot Access Remote UNC File Via The Admin Share


I am developing a package to restore a database from backup file on a remote server. I am having problems accessing the remote backup file when it is addressed via the admin share, in this case N$. It runs okay if a specific share is created but for some unknown reason fails via the adminshare.

I am executing the package job with a proxy account that is a member of the local administrators group on the remote server.

It appears that access via aremote admin share isn't possible from within a SSIS package. Is this the case?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Do I Need Admin Access On My Computer To Run Or Maintain An SSIS Package?
Do I need admin access on my computer to Run ormanage an SSIS Package?

if i dont have admin access on my computer, what functionality of SSIS i cannot use?

View Replies !   View Related
SSIS Package, Remote Server Access, Proxy Agent: The Steps
I created an SSIS package that runs fine when invoked manually on a Source server but fails whenrun viaSQL Agent scheduler. The package accesses resouces on a remote server. Are these the steps, in the right order, that I need to do?

1. Create a Credential on the Source Server

(BTW , when I do this, it asks for a Windows login and anaccount password. I wanted to use a Domain

account but the dialog box does not seem to accept Windows authentication. I'm confused.)



2. Create a Proxy

( I need to use the credential created in 1 above to crate the Proxy)

(What is the Principals page about? I'm creating a Proxy account which I expect to act as the account used

when this step is invoked. I defined the Identity of that account when I created the credential in 1)



3. Schedule the package and create the job stepthat copies databetween remote servers.

(In the "Run As" list, select the proxy created in 1)



TIA,

Barkingdog

View Replies !   View Related
SSIS Package Storage In A UNC Network Share?
Somehow I have an impression this can be done.
Somehow I tried myself by modifying MsDtsSrvr.ini.xml to point it to network UNC share, but it didn't work for me. It gave me an error

"Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)
Additional Information: The storage localtion for the folder 'File System' cannot be accessed. (MsDtsSrvr)"

I checked my UNC permission, and I even allow full access from "everyone", but it still does not work.

I paste my MsDtsSrvr.ini.xml here too, and any help is greatly appreciated!



<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>.</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>\test01mytest</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>

View Replies !   View Related
Trying To Access A DBase III File With A SSIS Package
I am trying to get a handle on the new SQL Server Integration Services in SQL Server 2005. There is a legacy DTS package that I need to get working on our new server (using SQL Server 2005) but I can't seem to get it to work.First, I migrated it and attempted to run the package. It gave me many errors. So, I thought I would just rebuild it in integrated services. Everything was going smooth until I got to the real data transformation part.I added a data flow task and it took me to the Data Flow tab. Then I added a DataReader Source. I am trying to read from a dBase III file and I assumed I would be using an ODBC driver for that. Well... it has been hell trying to get it to see the dBase III file and access it.I have tried two solutions from the internet.This one and this one (by Wenyang) with no positive results.No matter what I do I still get an error in the bottom of the Advanced Editor for DataReader Source that reads: "Error at Sales Transformation [DataReader Source [81]]: Cannot acquire a managed connection from the run-time connection manager."Has anyone attempted anything like this before? Are there any SSIS experts around here that can drop me a few pearls of wisdom?Thanks in advance... I'm dying here.

View Replies !   View Related
SSIS Package Can't Access File System
Hi,

I have an SSIS package that has an "execute processtask" that executes a batch file. The package has been deployed to the msdb database, and is called from a stored procedure using xp_cmdshell dtexec ...

I can execute the package just fine if I'm logged onto the server as a system administrator, by running the stored procedure from a query window.

However, if I log on to the serveras a non-admin user, the package attempts to run, but breaks at the file system task, with "Access Denied". It can't run the batch file. It seems to be a permissions issue at the file system level.

How do I resolve this?? Please help.

Thanks

View Replies !   View Related
SQL 2005 Maintenance Cleanup Task Is Not Deleting Files On Remote File Share
I have the following issue with Maintenance planbackups that work for BAK DIF and TRN to a remote server share.
When I try and remove the old files with a clean up task I get an error and the files don't get deleted.


The version is as follows
Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)

The error result is as follows,

Failed-1073548784) Executing the query "EXECUTE master.dbo.xp_delete_file
0,N'\\EXECUTE master.dbo.xp_delete_file 0,N'\ABCD-A1\BACKUPS\ABCD_BACKUP\ABC_DAILY\ABCD',N'trn',N'2008-01-13T12:52:49'" failed with the following error: "xp_delete_file() returned error 2, 'The
system cannot find the file specified.'". Possible failure reasons: Problems
with the query, "ResultSet" property not set correctly, parameters not set
correctly, or connection not established correctly.

The maintenance plan seems to be adding extra "" though when i enter the
code directly in a query i get same error.

Query:

EXECUTE master.dbo.xp_delete_file 0,N'\ABCD-A1BACKUPSABCD_BACKUPABC_DAILYABCD',N'trn',N'2008-01-13T12:52:49'

Error:

xp_delete_file() returned error 2, 'The system cannot find the file specified.'

The servers belong to the same domain and are using the same Service account which has all the necessary rights to the share and the file directory location. The backups work but i get the error on the cleanup task.

Trying to figure out how to get the Cleanup task to delete old files. The same happens for all file extensions and I have tried other locations with simpler file paths same error.


Regards,
Scott




View Replies !   View Related
Using SSIS To Access Network Share From Different Domain
Hey All,

This is my first time using the forums here nor am I a SQL programmer. I'm trying to help a coworker figure out how to access files from a network share (using a UNC path) from a different domain. Right now we have three domains - Production, Development, and the Local. There is a one-way trust setup with the development and local domains, so using cross domain accounts is easy. Unfortunately, we cannot setup one right now with our production domain to any of the other two domains. Is there a way to pass production credentials from our local or development domain servers to a production server share? Am I even approaching this in the right way? Maybe there is a different method, any help would be GREATLY appreciated!
-Andrew
Network Administrator

View Replies !   View Related
Help Again Please! Unable To Connect To The ADMIN$ Share
OK, I can get to the admin$ share, see all the files contained within, but I still get this message. Help! I really need to upgrade this 6.5 db and i keep running into these damn errors!


Stefanie

View Replies !   View Related
6.5 To 7.0 Upgrade Wizard, ADMIN$ Share
I'm trying to run a two-computer upgrade from 6.5 to 7.0. In the Upgrade Wizard I receive the message "The Wizard was unable to connect to the ADMIN$ share on your remote 6.x SQL Server. Please verify that this share exists and that you have sufficient permissions to access it." The share does exist and the login should have sufficient permissions. To which login is this message referring? Is it the NT domain login on the import machine or is it one of the services on the export machine?

View Replies !   View Related
Admin Access To SQL Without Server/domain Admin Access
We are using Win2k3 R2 with SQL 2000 in a domain environment.

Is it possible to create a domain group to grant admin level and user level access to SQL2000/2005 without giving users server admin or domain adminaccess?

It has always been my impression that to have admin access to SQL that you had to at least had admin level access on the server.

Any clarification would be greatly appreciated.

Thanks!

View Replies !   View Related
Access To Datareader Destination On A Remote Package
I'm fairly new to SSIS, and I'm looking for some general guidance on the best approach to take to a particular issue. Essentially, I've built a web application, running on a remote server, andI'm looking to take the contents of an Excel spreadsheet, load it into memory, run a whole mess of calculations against it, and then load the results into a table on MS-SQL 2005. The calculations are in a class library, written in C#, so my sense was that the best approach would be to a) load the data into a datareader, b) run the calculations against the data andc) load it to SQL. Of these steps, a) seems like the place where SSIS would come into play.

My question is, once I've got the data into a datareader, how can it be accessed from my code? I'd been playing around with DtsClient until having the realization that it was intended to be used locally. Is there a similar method for doing this sort of thing remotely?

View Replies !   View Related
Running Ssis Package With A Remote Sql Agent?
hi all,

thanks for the valuable information all the time!!! saved me a lot of time...

our team developes a system for text data improvement using ssis .

we have a few heavy packages that we want to execute ontwo separate "SSIS servers" that will be dedicated to runnung these packages only, and repeatedly. the main sql server will be placed on a different server machine .

my question is:

what is the best way to do this?

if we schedule these packages as a job of the Sql Ajent- does that mean that the packages will be executed on the sql server machine (which is not what we want) ? or could we define a remote machine to run the package on, and specifyour "SSIS servers"?

or- should we use a simple scedualer on the "SSIS servers"usinga dtexec command? but then i loose the benefits in using the sql agent- such as logging, notifications, etc.

do we needto installsqlserver on these "ssis servers"?

thanks for your replies!

View Replies !   View Related
.net: Call SSIS-Package From Remote Computer
Hello,

is there any way to execute a SSIS package at the SQL Server programatically from a remote computer? (I use .net 2)

I don't need variables or return values, I only want to start the package. I know that it is easier to do that job with a webservice etc on the SQL Server but I cannot use such.

A method to call a package from a stored procedure would also help me a lot

Kind regards, _Rodney_

View Replies !   View Related
SSIS Package With FTP Task That Preserves Remote Timestamp?
In my SSIS package, I want to use an FTP Task to transfer a remote file locally for processing. Part of this processing involves looking at the file's timestamp to determine the date range of records within the file that I'm interested in.

When I did the FTP steps manually using coreFTP, I had no problems because that FTP client preserves remote timestamps... I'm finding that the SSIS FTP Task doesn't do this.I tried using shell ftp too and ended up again withthe current time instead of actual timestamp. Is there any way to get what I'm after using no third party clients?

Maybe MS can add an extra boolean field to the FTP Task Editor for preserving timestamps? :)

View Replies !   View Related
ASP.NET Reading Package List From Remote SSIS Server
Hi everyone!

I have a question regarding ASP.NET 2.0reading available packages (calling "GetDtsServerPackageInfos" on the "Application"-Object which returns "Microsoft.SqlServer.Dts.Runtime.PackageInfos") from a remote SSIS server (not running them). It seems to me that I am experiencing either a security/delegation issue or that I am trying to do something that is not possible...

The setup is the following.

I have two machines, A and B. A runs IIS 6/ASP.NET 2.0 and B runs SQL Server and SSIS. They belong to the same domain. IIS runs the application pool with the webapplication in question under the "Network Service" account andA is trusted for delegation to B. At the moment its trusted when using Kerberos and for MSSQLSrvc and rpcss; but I tried "all" and many moreas well.

I configured IE to use Windows Authentication and set the URL to belog to the Intranet (to enablekerberos authentication).

My ASP.NET webapplication now tries to read (in the sense explained above) the available packages on the SSIS machine (B). The packages are stored on the filesystem, not in mdsb. But I feel that this does not matter, since ASP.NET is accessing them through "the SSIS service" which can access packages in msdb or/and on the filesystem?

What happens now is that

a) everything works, when I fire up IE on A and access the webapplication. The user I have on A is a local admin.
b) I get "E_ACCESSDENIED" when I start IE as regular User on A
c) I get "E_ACCESSDENIED" when I access the webapplication from any other machine than A (IE6 or IE7)

My main question is: is it possible to do what I want to do? The other question is, why does everything work when I access the webapplication from A, but not from any other machine? The second thing makes me think it could be a delegation issue (double hop and SSIS don't seem to go togethe too well). But still, I could not find any resource telling me that this is impossible And frankly, I do not fully understand delegation and/or Kerberos.


I would greatly appreciate if anybody had a pointer or something for me.
Regards
scherand

Btw: Thanks to Caddre for his (her?)first help andpointing me to this forum.

View Replies !   View Related
Problem Running SSIS Package As Job On Remote Machine
Hi,

I have created a SSIS package on my local machine.
I need to deploy this package on a Test Server and it should execute as a scheduled job.

I am not sure of the steps I need to follow and things I need to be careful about.

I have the following doubts:
1) While developing the package, I have referred to the local SQL Server withWindows credentials.
2) The package, once deployed on the Test Server needs to point to the test server database with SQL Server credentials.
3) I know how to create a deployment utility. However, I am not sure if the deployment manifest will run without errors on the remote machine.
4) Even if the deployment manifest executes successfully and deploys the packages, how do I generate a script to create a Job and schedule the package?
5) I am using a File DSN to connect to IBM DB2 database in one of my Data Flow Tasks in this package. How do I configure it automatically on the remote machine? Won't there be any issues with it?

Please help me...

Thanks and Regards,
B@ns




View Replies !   View Related
Execute SSIS Package At Remote Server Across Domain
Hi,



Is that possible to execute SSIS packages from a remote SQL Server 2005 in another domain at local computer (Windows XP)?



Can I useSQL authentication to connect to the remote SSIS? My problem is, the user who execute the SSIS is not allow to access to SQL server directly. Is that possible to code everything in a batch file instead?



I triedto use web services to execute the remote SSIS but it always return "authentication error"?



Can someone help?



Many thanks!



Regards,

Mashmallow

View Replies !   View Related
Access Denied - Remote Connection To SSIS
We have 2 SQL2005 servers currently. 1 is a dev box, the other production. To grant remote access to SSIS, I added my developers to the local Distributed COM Users group and also gave them remote Access and remote Activation on the MsDtsServer component.



This worked just fine. Recently we applied SP1 and the follow-on hotfixes to all SQL components. I followed the install order prescribed in the Q article and applied all component fixes. My developers are now unable to access SSIS remotely unless I add them to the local administrator's group. I don't see anywhere that a log gets generated to help me track down what's going on. Nothing shows up in my Windows security log, despite enabling audit logging on: Accout Logon Events, Logon Event, Object Access, and Privilege Use.



Is this a know issue in SP1 or the hotfixes? I'm hesitant to apply the patches to my production box until I can resolve this issue.



Thanks
Steve

View Replies !   View Related
Access Denied Error Message Using Xp_cmdshell To Access Network Share
When running the following statement in SQL 2005, I get the error message "Access is denied":

exec master.dbo.xp_cmdshell 'TYPE \SERVER-BSHAREFILE.TXT'



The following are true about the network:

The SQL Server is installed on SERVER-A.
SERVER-A and SERVER-B are Windows 2003 servers on the same Windows 2003 domain.
The SQL Server and SQL Server Agent services are running under thedomain account SQLSERVICE.
SQLSERVICE is a member of the Domain Admins group.
The Domain Admins group is part of the local Administrators group on SERVER-B.
The SQLSERVICE account has also explicitly been given Full Control to the folder referenced by \SERVER-BSHARE
xp_cmdshell use has been enabled on the SQL Server.


If I run the following command in SQL:

exec master.dbo.xp_cmdshell 'whoami'the following is returned: DOMAINSQLSERVICE
If I change the command to access the c: drive instead of a network drive, it executes successfully.

Can anyone shed some light on why I still cannot access any of the files in this folder using xp_cmdshell?

Tim

View Replies !   View Related
Hosting An SQL Database On Remote Share
Hi,
I would really appreciate help with this query.

I have an SQL 2000 server setup with 2 databases. My boss would like to setup another database but wants the actual database to reside on a different server share.

Is is possible for one database on an SQL server to be hosted on a remote share ?

appreicate any info
thanks

View Replies !   View Related
Remote Connection To Access DB File
hi ,all
what should i do to connect db file on the server ,

at first i putted the file in shared folder and i connected from server explorer .
iam not satisfied with this solution i want more professional one (ODBC,......,ect)
what is the best way .


My Tools are ;Vista OS,VS2008,SQlServer2005.

Thanx.

View Replies !   View Related
Using SSIS Package To Connect A Remote Sql Server--login Failed.
Hi,

i created a SSIS package to import data to a remote sql server, using the following connection string:

"Data Source=My-SQL;User ID=PortalUser;Password=Password;Initial Catalog=TestOMIWarehouse;Provider=SQLNCLI.1;Auto Translate=True;";

and got an error "Login failed".

When i give PortalUser a sysadmin server role, it works. But i don't want to give PortalUser a sysadmin role. Any suggestions? Is sysadmin role required to access a remote server using Sql server authentication?

thanks! Any help would be appreciated.

alea





View Replies !   View Related
Remote Connection To SSIS Fails With Access Is Denied
I'm new to SSIS and I'm having problems getting a remote connection to the SSIS service using Management Studio on my workstation. If I terminal Service onto the Server I have no problems connecting to SSIS, but if I try to connect remotely I get the "Access is denied" error message. I have completed the following steps:


To configure rights for remote users on Windows Server 2003 or Windows XP
1. If the user is not a member of the local Administrators group, add the user to the Distributed COM Users group. You can do this in the Computer Management MMC snap-in accessed from the Administrative Tools menu.
2. Open Control Panel, double-click Administrative Tools, and then double-click Component Services to start the Component Services MMC snap-in.
3. Expand the Component Services node in the left pane of the console. Expand the Computers node, expand My Computer, and then click the DCOM Config node.
4. Select the DCOM Config node, and then select MsDtsServer in the list of applications that can be configured.
5. Right-click on MsDtsServer and select Properties.
6. In the MsDtsServer Properties dialog box, select the Security tab.
7. Under Launch and Activation Permissions, select Customize, then click Edit to open the Launch Permission dialog box.
8. In the Launch Permission dialog box, add or delete users, and assign the appropriate permissions to the appropriate users and groups. The available permissions are Local Launch, Remote Launch, Local Activation, and Remote Activation. The Launch rights grant or deny permission to start and stop the service; the Activation rights grant or deny permission to connect to the service.
9. Click OK to close the dialog box. Close the MMC snap-in.
10. Restart the Integration Services service.


But I still get the Access is denied error from my workstation??



I have Power User rights on the server and I'm a sysadmin in the database instance. The SSIS packages I am trying to access are stored in the database. If I add myself to the local administrators group on the server I CAN get remote access, but this is not an acceptable solution in our production environment.



Thanks for any help





View Replies !   View Related
Remote SSIS Vs DomainUser: Access Is Denied (0x80070005)
What OS permissions do I need to give a domain user to effectively connect to a remote instance of Integration Services?

I keep getting the following message:

Cannot connect to SQLDEV01
    Failed to retreive data for this request.
       Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (Microsoft.SqlServer.ManagedDTS)




I have already performed the Windows 2003 steps outlined in the "Eliminating the Access is Denied" error located at http://msdn2.microsoft.com/en-us/library/aa337083.aspx

I have no problem if the user is a local Administrator (go figure).

View Replies !   View Related
Access To Remote Server For Developers Works ,but They Can't Create Folder Or Add New Package To Msdb
Hi ,

on test serverI added developers domain group and DBA group to dcomusing article

http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx

and made developers domain group dbo of msdb on test server

developers can connect to remote test server ,see SSIS ,browse between folders

but

when they trying to create new folder in msdb they get error saying

...folder already exist



when they trying to import new SSIS to msdb they get get error saying

...access to package denied



Remote access (import/export ,new folders creation)fully work only for DBA group



View Replies !   View Related
Sending Isql Output To Remote Share
I have a query I`d like to run using the isql command utility. The query works correctly and the output can be sent to a local file with no problem. When I try to designate a network location as an output file (e.g. abcdefgfile.txt), though, I get an error message "No such file or directory."

Is it possible to send SQL output to a remote location?

TIA!

View Replies !   View Related
Execute SSIS Package Stored In Remote SQL Server From A Client Machine.
I have written a VB component to execute a SSIS package stored in SQL server.

I am using the Microsoft.sqlserver.dts.dtsclient, dtsconnection/dtscommand

and executereader and everything works perfect on the local machine. This is descibed in a msdn site .

But my customer have a remote SQL server and want no extra BI clients/SQL server clients etc on the client machine, only an ordinary windows client and network connection to the SQL server.

My question is: Can you still use dtsclient or do you have to do in some other way?

rose-marie

View Replies !   View Related
SQL Remote Admin
Dear Friends,
Please tell me what you would need to administer SQL Server hosted in the
USA. My client need to delete some incorrect information. This is what I
think that you would need. You correct it and email this back to me
immediately. I believe that you will connect using Enterprise Service
Manager.

1. Version of SQL Server
2. IP address or the name of the server.
3. Win NT Level Security, user name and password at the admin level
4. SQL Server Secutiy, username and password with admin privileges (only
need this if it has been activited)
5. Database Level Security, username and password
6. Name of the database and table (what would you do if the user does
not know the name of database and the table from where the information is to
be deleted, can you query and find out all the databases on the server and
similarly search all the tables)
7. The information to be deleted.

View Replies !   View Related
Remote Admin
Are there any tools for administering SQL2000 remotely over the TCP/IP? And if this is possible what are the main hurdles on setting it up. Emulation is an option.

View Replies !   View Related
Remote SQL Admin Across The Internet
Hi,

What is a secure way or accepted method to make database changes,IE: edit tables, add sprocs. ect. on a server being ran by an ASP.NET hosting service across the internet?

Thank you
-heywade

View Replies !   View Related
Non Admin Remote Restore
We have an sql server on our internet connection that we are allowing a charity to use. Unfortunately, during this development period, they are constantly modifying their db, requiring the new version to be placed on the server.
At the moment, we (the admin) are manually restoring the backup they send us which is fast becoming a big problem.
Is there a 'clever' way of doing this so that we don't have to be involved manually?

Thanks

View Replies !   View Related
Pulling A DB Via Remote Admin
using remote admin program and i need to pul the entire DB onto my local maachine to do some trial runs. I have a static IP so i thought I could just DTS the how system to my computer. Can any one verify that this is the best way of suggest another?
Thanks
Matt

View Replies !   View Related
Remote Admin Using MMC On NT Workstation
Hello,

I would like to know if one can adminiter SQL server remotely using MMC on NT workstation? If so, how do you install the MMC and SQL Enterprise Manager Add-in on NT workstation?

Thanks for the help

Kevin

View Replies !   View Related
Using Access And SSIS Package
Hello,

I am somewhat new to SSIS, so please forgive my confusion.

I have a situation and I have two possible scenarios that will work, but I'm not sure if either of them are feasible. I have a database that is updated using about 8 text files extracted from the company's main software package. I have set up a SSIS package that takes these 8 files and updates the appropriate tables. This package works pretty well. My question surrounds the automation of the extraction of the files from our software. I am able to do the extraction in one of two ways - a) manually opening up an instance of the tenet program used to run the program with a script built into it or b) using VBA in an Access application to open up the program to run the built in script. In the past, when the platform for the database was Access, I ran the extraction and database update from the same VBA module, but now I'm not sure how to do it.

Is it possible to either:

A) Intiate the run of a SSIS package from Microsoft Access or

B) Somehow open up the program that run's the company's software using SSIS. And this brings another question, if this is a step in an SSIS package, will the package wait to move to the next step until the entire extraction process is complete?

Thanks so much!

Christine

View Replies !   View Related
SSIS - Get ServerName From A XML Or TXT File Into SSIS Package
Dear Friends,
I store several configurations in the main database of my SSIS packages. I need to get the servername from a xml or txt file in order to get those configurations stored in my database.
How you think is the better way to do that?
Using a FlatFileSource to read the file and a script to save the value into a SSIS variable?
Using the package configuration I cant do that... maybe I dont know, but I can save the SSIS variale in the configuration file, but what I need is to do the inverse, read the configuration file and save the value in the SSIS variable.
How the best way you suggest?!
Regards!!
Thanks.

View Replies !   View Related
Execute A SSIS Package From Access
I have some applications in Access and I execute a DTS from there, Can I execute a SSIS package fron access?



Regards



View Replies !   View Related
Unable To Access SSIS Package
I (actually my DBA did it)have created an SSIS package in MS SQL Server 2005. It can be found under Integration Services under:



Stored Packages


MSDB


VisBridges


ExportTime
Using the Execute Package Utility, it runs perfectly.

I used the article at http://msdn2.microsoft.com/en-us/library/ms403355.aspx to build an application to run it.


My code includes the following (written in VB.Net):

a Web Service Function called LaunchPackage:


Public Function LaunchPackage(ByVal sourceType As String, _


ByVal sourceLocation As String, _

ByVal packageName As String) As Integer ' DTSExecResult



Dim packagePath As String


Dim myPackage As New Package()

Dim integrationServices As New Application



' combine path and file name


packagePath = Path.Combine(sourceLocation, packageName)



Select Case sourceType



Case "file"


' package is stored as a file.

' add extension if not present.

If String.IsNullOrEmpty(Path.GetExtension(packageName)) Then


packagePath = String.Concat(packagePath, ".dtsx")

End If





If File.Exists(packagePath) Then





myPackage = integrationServices.LoadPackage(packagePath, Nothing)

Else


Throw New ApplicationException("Invalid file location: " & packagePath)

End If

Case "sql"

' Package stored in MSDB.


' Combine logical path and package name.

If integrationServices.ExistsOnSqlServer(packagePath, <servername>, <UserID>, <password>) Then



myPackage = integrationServices.LoadFromSqlServer(packageName, <servername>, <UserID>, <password>, Nothing)

Else


Throw New ApplicationException("Invalid package name or location: " & packagePath)

End If

Case "dts"


' package is managed by SSIS Package Store.

' Default logical paths are File System and MSDB.






If integrationServices.FolderExistsOnDtsServer(packagePath, <servername>) Then


myPackage = integrationServices.LoadFromDtsServer(packagePath, <servername>, Nothing)

Else


Throw New ApplicationException("Invalid package name or location: " & packagePath)

End If

Case Else


Throw New ApplicationException("Invalid sourceType argument: valid values are 'file', 'sql', and 'dts'.")

End Select


Return myPackage.Execute()

End Function

My TestPage includes the following:


Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click


Dim launchPackageService As New LaunchSSISPackageService

Dim packageResult As Integer

Dim sourceType As String = "dts"

'Dim sourceLocation As String = "M:mssqlssiconfig" ' for "file"

'Dim sourceLocation As String = "MSDBVisBridges" ' for "sql"

Dim sourceLocation As String = "VisBridges" ' for "sql & dts"

'Dim sourceLocation As String = "MSDB"



If rdoCreateTimeTrans.Checked Then



Try


packageResult = launchPackageService.LaunchPackage(sourceType, sourceLocation, "ExportTime")

Catch ex As Exception


Response.Write("The following exception occurred: " & ex.Message)

End Try


End If

End Sub

I've tried both "sql" and "dts" with all the various permutations that are listed (and commented out) above. I either get an error that says:
The top level folder "VisBridges" is not found. ("dts" "VisBridges") -- or --
Invalid package name or location: MSDBVisBridgesExportTime ("dts" "MSDBVisBridges") -- or --
Cannot find folder "MSDBVisBridgesExportTime" ("sql" "MSDBVisBridges") -- or --
The specified package could not be loaded from the SQL Server database ("sql" "VisBridges")

Any assistance would be greatly appreciated.

Many thanks,
Michell

View Replies !   View Related
Report Server File Share Failure Writing File
Hi,



I have set up Reporting Services on a server withSql Server 2005 and Windows 2003. I have set up a Report Server File Sharebased subscription to deliver a report to a file share on a different domain.

Under the execution account for the Reporting Services, I have the account set up as the domain administrator for the domain that theSql Server is on. Under the option (for the subscription) -Credentials used to access the file share, I have this account as the domain administrator for the domain the report is publised to.

However, I am getting the following error : Failure writing fileReport.xls : A logon error occurred when attempting to access the file share. The user account or password is not valid.



I have tried multiple combinations to get the report publised to the File share, but it is still failing to write the report. Any help would be appreciated.



Thanks,

J.

View Replies !   View Related
How To: Variable File Names When Exporting A Report To A File Share
I'm exporting reports daily to a file share and I need to rename the reports with a pseudo time stamp.

Example: I have a report named "Disk Usage" and when I export (using a data-driven subscription) I want to rename it "Disk Usage - (Jan07)" - or something to that effect.

Can anybody tell me how to accomplish this.

View Replies !   View Related
Is Enterprize Manager Secure For Remote Admin?
Hello all,

An ASP.NET website hosting service allows the use of Enterprize Manager to manage the backend database of a hosted asp.net website. This is not done across a VPN and I don't think it could be done on SSL so the question is : How Secure is that? would this be ok for learning but not Ecommerce? Or is it an encrypted session and I paranoid?

-Thanks
Heywade

View Replies !   View Related
Pocket Pc Mssql Remote Database Admin
Hi,I am working on an Open Source pocket pc remote databaseadministration utility using C# (i.e. the native .Net CompactFramework, not the opennetc).Anyway, i wanted to ask that does this application has some potentialor i am putting my free time to waste ;)BTW the application has started to take shape and you can have a lookat http://www.pocketsqlman.com for a brief outline of what the wholeidea is.Regards,Dheeraj Juneja

View Replies !   View Related
How To Refresh Access Table From SSIS Package?
Hi all,
I have created an SSIS package to export rows of data from SQL to Access using SSIS package. The package is executed from asp.net web application. Below is what i want to achieve:
-User enters a date range
-SSIS package will export data between the date range from SQL to Access database.
-When user enter another date range, I want to clear the contents of the Access database. (Im using Execute Sql Task--- Delete tablename)
The problem is that when I look at the table after the second user request, the fields will show #deleted. Only after i click refresh will the new data appear. How can I make the data appear without manually refreshing the Access table.
 Thks alot.

View Replies !   View Related
Creating A Table In Access From An SSIS Package
I need to run a make-table query against an Access database out of an SSIS package. I tried to do this with an OLE DB Command Task but it fails to create the table even though the task execution comes back successful. Any thoughts???

View Replies !   View Related
Access Denied Running SSIS Package As A Job
I having a wierd problem.

Environment: SQL Server 2005 (64-bit)

If I create a job with an OS step with the text below

"c:Program Files (x86)Microsoft SQL Server90DTSBinn"dtexec /DTS "MSDBew Import" /SERVER HAYDN /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V

I keep getting the following error:

Message
Executed as user: XYZAdministrator. The process could not be created for step 1 of job 0x2161C39C2C34C54AA850602A482E82DF (reason: Access is denied). The step failed.

HOWEVER...

If I take put the above text within in a batch file (foo.cmd); and chanage the step to execute "c:foo.cmd" it works fine.

What am I missing here? It's seems wierd that it works one way, and not the other.

Thanks in adavance

Brian

View Replies !   View Related
Renaming An Access Table In An SSIS Package
My current project requires me to both rename the MDB file for an Access database and rename the table it contains. The Access files comes in withrandom names, eachcontaining one table with a specific name. Based on the table name it contains, I rename both the file and the interior table to a standard name which a later package in the process references.

A foreach container loops through all the mdb files in the applicable directory, containing a script task and a file system task. Thescript task usesGetOleDbSchemaTable to extract the table name, then loops through an array of table names from the client's configuration, comparing it to a similar array of constant names and getting the matching one. The file system task then uses that found name (or the original table name if a conversion is not found) to rename the file to match that standard name. So far, so good.

Now I have to rename the table within the file as well. All of the examples of code I'm finding on the 'net refernce ADOX, but I haven't been able to figure out how to use that in a script task, assuming that's what I want to do in the first place.

Anyone have any experience with doing things like this?

View Replies !   View Related
Execute Access 2003 Macros In SSIS Package
Hi

Does any one know how to execute Macros in SSIS Package.

I have an Access 2003 Macro which has to be executed in a SSIS package...

I need to pass some runtime parameter also .

How to go about it....



Thanks & Regards

Deepu M.I

View Replies !   View Related
Data Flow Source For MS Access In SSIS Package
Hi all...

I'm creating a SSIS in the designer view of SQL Server BI Dev. Studio (SQL Server 2005)

I need to import a whole table from MS Access into my local SQL Server.(this task will be performed weekly, so once working I'll schedule a job for it)

I've created a 'FILE' connection to MS Access in the 'Connection Managers'.

When I'm on the 'Data Flow' tab I can't find a Data FlowItem to use as a MS Access connection.
(available on the 'Data Flow Sources' are only: DataReader, Excel, Flat File, OLE DB, Raw File and XML Sources)

What am I doing wrong/missing?

Thanks for your help.

View Replies !   View Related
An Attempt To Attach An Auto-named Database For File (file Location).../Database.mdf Failed. A Database With The Same Name Exists, Or Specified File Cannot Be Opened, Or It Is Located On UNC Share.
Greetings, I have just arrived back into the country (NZ) and back into ASP.NET.
 I am having trouble with the following:An attempt to attach an auto-named database for file (file location).../Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
It has only begun since i decided i wanted to use IIS, I realise VWD comes with its own localhost, but since it is only temporary, i wanted a permanent shortcut on my desktop to link to my intranet page.
 Anyone have any ideas why i am getting the above error? have searched many places on the internet and not getting any closer.
Cheers ~ J
 

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved