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

Hi Barry,
Thanks for your response.

What is the result if you modify the FullPath value?
Also, I find that your SQL Server 2005 version is 9.0.0.1399 which
indicates that your SQL Server 2005 has no service packs installed. I
recommend that you install SQL Server 2005 SP2 first and then recreate your
SSIS package to see if this issue persists.

You can download the SP2 from:
http://www.microsoft.com/downloads/details.aspx?familyid=d07219b2-1e23-49c8-
8f0c-63fa18f26d3a&displaylang=en
http://support.microsoft.com/kb/933508

Please feel free to let me know if you have any other questions or concerns.

Best regards,
Charles Wang
Microsoft Online Community Support



Charles,

I don't know if this has any relevance to this issue or not. However ...
this observation may be worth mentioning.

I was fighting with trying to rename one of my SSIS projects and had a
terrible time getting the renaming to 'take', finally ended
up deleting the .database, .dtproj, etc files totally and simpy readded
all the projects to a new correctly named project. Durning this > process
I noticed that the package descriptions within the .dtproj file have a
<FullPath> xml tag. But in my SSIS projects the
<FullPath> value contains only the package name and no path information
at all. Implying that, to run, the directory containing the
package must be selected ... could this be the issue that is causing the
SMS job to fail to find the package ??

Probably a 'red herring' but one never knows ...


<DtsPackage>
<Name>aim_employee_responsible_to_delimited_txt.dtsx</Name>

<FullPath>aim_employee_responsible_to_delimited_txt.dtsx</FullPath>
<References />
</DtsPackage>
<DtsPackage>
<Name>aim_hardware_attributes_to_delimited_txt.dtsx</Name>

<FullPath>aim_hardware_attributes_to_delimited_txt.dtsx</FullPath>
<References />
</DtsPackage>
<DtsPackage>
<Name>aim_inventory_item_to_delimited_txt.dtsx</Name>
<FullPath>aim_inventory_item_to_delimited_txt.dtsx</FullPath>
<References />
</DtsPackage>

Barry
in Oregon

.

Relevant Pages

  • Re: SSIS - can SSIS pkg recognize a drive letter within SMS job?
    ... The one alternative I've been wondering about is setting the default package ... set a starting path from within an SSIS package script. ... What is the result if you modify the FullPath value? ... indicates that your SQL Server 2005 has no service packs installed. ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.programming)
  • Re: Migrating DTS Local Package from test to production environments v7.0
    ... The version of SQL Server on which the package was create is SQL Server ... DTS runs at the client so manually will be on the invoker's PC which in this ...
    (microsoft.public.sqlserver.dts)
  • RE: Migrating DTS to Integration Services
    ... let me answer your Encryption issue when you expand your MSDB ... used to connect to your SQL Server, ... Open services.msc and restart your SQL Server Integration Service. ... Migrate DTS 2000 packages or Add Existing package (since you have migrated ...
    (microsoft.public.sqlserver.dts)