DTS question

I have a dts package which I built which I will call Package1. Package1
imports data from an excel spreadsheet into SQL Server 2000. The only thing
that changes about Package1 is the excel input file name. How can I call th
e
package from VB .Net and feed the new excel file name into the call from VB
.Net?
Thanks.
ArcherSee if this helps, look for "Using Connections":
Working with files and the FileSystemObject
http://www.sqldts.com/default.aspx?292
AMB
"bagman3rd" wrote:

> I have a dts package which I built which I will call Package1. Package1
> imports data from an excel spreadsheet into SQL Server 2000. The only thi
ng
> that changes about Package1 is the excel input file name. How can I call
the
> package from VB .Net and feed the new excel file name into the call from V
B
> .Net?
> Thanks.
> Archer

DTS package in 2005

Hi All ,
I have a DTS package in SQL Server 2005 , I will have to use the web service in the DTS Package, So my Biggest Doubt is

Can i Call the Web Service in the DTS Package using the Stored Procedure ? :confused:
Or
Can i call the Web Service in the DTS Package using the VB.Script ?:confused:

This is the Most Important thing for Us Right of now, and Will be happy if i could get some help.

Thankssince you are using 2005, you can call a web service in a sproc if it's a CLR sproc. a CLR sproc is implemented in managed code and can do anything you could do in C#, including calling a web service. It doesn't mean you *should* do it though...|||If you are using Sql Server 2005 then I hope that you mean Integration Services and you can easily call a Web Service from there. It is a Control Flow task specifically named Web Service Task. There are several examples of how to use the task floating around the net and a couple on Microsoft's site.|||Many people import their DTS packages (to the place under Management > Legacy) and continue using them.
(Honestly, much quicker than trying to understand the SSIS design tool IMO)

DTS Package And Schedule Job

Hi ,
I create a DTS package to run a SQL Task. This task will call a batch
file. This batch is to unzip the specified file. It works fine in the DTS
design enviroment but after I scheduled this package , it failed to run.
I try to schedule this batch is the windows scheduler , it works fine.
Any idea on it ?
Travis TanYour SQL Agent permissions are likely the culprit...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:9D9913AE-214A-4D76-9BD5-F1B5251A7993@.microsoft.com...
> Hi ,
> I create a DTS package to run a SQL Task. This task will call a batch
> file. This batch is to unzip the specified file. It works fine in the DTS
> design enviroment but after I scheduled this package , it failed to run.
> I try to schedule this batch is the windows scheduler , it works fine.
> Any idea on it ?
> --
> Travis Tan

DTS Package And Schedule Job

Hi ,
I create a DTS package to run a SQL Task. This task will call a batch
file. This batch is to unzip the specified file. It works fine in the DTS
design enviroment but after I scheduled this package , it failed to run.
I try to schedule this batch is the windows scheduler , it works fine.
Any idea on it ?
--
Travis TanYour SQL Agent permissions are likely the culprit...
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:9D9913AE-214A-4D76-9BD5-F1B5251A7993@.microsoft.com...
> Hi ,
> I create a DTS package to run a SQL Task. This task will call a batch
> file. This batch is to unzip the specified file. It works fine in the DTS
> design enviroment but after I scheduled this package , it failed to run.
> I try to schedule this batch is the windows scheduler , it works fine.
> Any idea on it ?
> --
> Travis Tan

DTS in SP Error

I have a DTS package already created on the server. I want to call it
in a sp using the xp_cmdshell 'dtsrun ...'
I'm getting "xpsql.cpp: Error 87 from GetProxyAccount on line 604"
Any ideas how to fix this?
Thanks
MikeI found the fix for this error but I have a new problem
This DTS package is supposed to drop the table if it exists then create
a new one and load data from an excel file. This works fine if I run it
manually from enterprise manager.
If I try to run it from query analyzer i get an error stating that the
directory is not a valid path. And it doesn't drop the table first.
Any ideas?|||I suppose that when you run that package from QA you are using a different
user than EM or something like that. And that user doesn't have permissions
over that folder.
--
Current location: Alicante (ES)
"Mike" wrote:

> I found the fix for this error but I have a new problem
> This DTS package is supposed to drop the table if it exists then create
> a new one and load data from an excel file. This works fine if I run it
> manually from enterprise manager.
> If I try to run it from query analyzer i get an error stating that the
> directory is not a valid path. And it doesn't drop the table first.
> Any ideas?
>