Re: SSIS - can SSIS pkg recognize a drive letter within SMS job?

Charles,

Thanks for the quick response! Its very much appreciated. Unfortunately,
I've been fighting fires all day and as a result I haven't had a chance to
retest this issue. I'll let you know as soon as possible!

Thanks in advance !!

Barry
in Oregon


"Charles Wang[MSFT]" <changliw@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:K8G$QD3wHHA.4484@xxxxxxxxxxxxxxxxxxxxxxxxx
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.
======================================================







.

Relevant Pages

  • RE: Hung SSIS package is hanging my database
    ... SSIS logging and log providers let you capture details about the package ... connections, it might be some internal errors in SQL Server, To find out ... has to be done by contacting Microsoft Product Support Services. ... Microsoft Product Support Services so that a dedicated Support Professional ...
    (microsoft.public.sqlserver.dts)
  • RE: SSIS - can SSIS pkg recognize a drive letter within SMS job?
    ... Connect to SQL Server Integration Services from SSMS ... Expand Stored Packages, right click File System, select Import package; ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.dts)
  • Re: multithreaded tcp/ip server large page file
    ... Part of the processing being done by each thread is contacting a sql server and if the sql server is having problems processing by this program backs up and I've seen it with over 100 threads open before. ... It handles it fine as the sql request time out this program returns and error response to the TCP/IP client that the thread is handling and the sub/tread ends. ... 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. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: multithreaded tcp/ip server large page file
    ... Part of the processing being done by each thread is contacting a sql server and if the sql server is having problems processing by this program backs up and I've seen it with over 100 threads open before. ... It handles it fine as the sql request time out this program returns and error response to the TCP/IP client that the thread is handling and the sub/tread ends. ... 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. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: multithreaded tcp/ip server large page file
    ... Part of the processing being done by each thread is contacting a sql server and if the sql server is having problems processing by this program backs up and I've seen it with over 100 threads open before. ... It handles it fine as the sql request time out this program returns and error response to the TCP/IP client that the thread is handling and the sub/tread ends. ... 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. ...
    (microsoft.public.dotnet.languages.vb)