RE: SSIS - can SSIS pkg recognize a drive letter within SMS job?
- From: changliw@xxxxxxxxxxxxxxxxxxxx (Charles Wang[MSFT])
- Date: Wed, 11 Jul 2007 04:06:00 GMT
Hi Barry,
To let me better understand your issue, could you please describe your
process more detailed so that I can reproduce your issue?
I performed a test at my side, however I could not reproduce your issue. My
test process was as following:
1. Create a mapped drive Y: which mapped to drive D: on another machine.
2. Create a Execute SQL Task with the following SQL statement:
INSERT INTO item VALUES('A7',4,20)
3. Save the package to the mapped drive path Y:\Share\test.dtsx
4. Connect to SQL Server Integration Services from SSMS
5. Expand Stored Packages, right click File System, select Import package;
6. Select Pckage location as File System, select package path as
Y:\Share\test.dtsx and input Pakcage name as test;
7. Connect to SQL Server instance from SSMS, expand SQL Server Agent, right
click Jobs, click New Job...., input the job name, select Steps, click
New..., input Step name, select Type as SQL Server Integration Services
package, select Package source as SSIS Package Store, select Server, select
Package as Test and click OK.
8. Start the job and it worked fine.
The SQL Server Agent service account is a domain user which has full
control on the remote share folder.
Please check my steps and compare with yours to see if there are some
hints. If you have any other questions or concerns, please feel free to let
me know.
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
.
- Follow-Ups:
- References:
- Prev by Date: Re: Loading a table (from text file)
- Next by Date: RE: how to migrate all DTS packages from SQL2000 to SQL2005 in one go
- Previous by thread: SSIS - can SSIS pkg recognize a drive letter within SMS job?
- Next by thread: Re: SSIS - can SSIS pkg recognize a drive letter within SMS job?
- Index(es):
Relevant Pages
|
