SSIS - can SSIS pkg recognize a drive letter within SMS job?
- From: "frostbb" <frostbb@xxxxxxxxxxxxxxxxx>
- Date: Tue, 10 Jul 2007 09:52:36 -0800
Greetings SSIS gurus ...
Is there some way that SSIS projects can recognize a drive mapping when the
package(s) are executed from within a SMS job ?
The SMS job agent runs within it's own shell and I've tried using " EXECUTE
xp_cmdshell 'SUBST W:
\\network_server\shared\database\sql_server\workarea\dba\server_name\instance_name\db_name\subsystem\'
" in an [ Execute SQL Task ] prior to running a series of [ Execute Package
Tasks ] ... and other variations with no luck.
I understand the I'd have a better chance using UNC's directly however our
SSIS scripts are stored on different netowork server and the path is longer
than 128 characters. Thus the need for a mapped drive letter.
I also understand that I could move all of the target packages into the Sql
Server SSIS 'store' ... however ... this particular project is unloads every
table in our enterprise database to a delimited text file as an alternative
backup. There is a package for each table requiring a HUGE number of
packages to be imported into the DB SSIS store.
At this point I'm simply trying to place the MAIN packages in the db SSIS
'store' rather than dealing with the madness of importing hundreds of
packages into the 'store'.
If anyone knows how to get SSIS to recognize a mapped drive please provide a
pointer to one or more examples.
Thanks in advance !!!
Barry
in Oregon
.
- Follow-Ups:
- RE: SSIS - can SSIS pkg recognize a drive letter within SMS job?
- From: Charles Wang[MSFT]
- RE: SSIS - can SSIS pkg recognize a drive letter within SMS job?
- Prev by Date: Re: Copying datetime fields from FoxPro 6 tables to SQL Server 200
- Next by Date: Re: Loading a table (from text file)
- Previous by thread: RE: SSIS - Missing Source Files
- Next by thread: RE: SSIS - can SSIS pkg recognize a drive letter within SMS job?
- Index(es):
Relevant Pages
|
