Showing posts with label package1. Show all posts
Showing posts with label package1. Show all posts

Tuesday, March 27, 2012

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

Wednesday, March 21, 2012

DTS Package Scheduled Job Result Issue

I am using SQL Server 2000. I created Package1, Package2, and Package3. If I ran from scheduled job Package2 and it failed, the result in Job History is Failed. If I ran from scheduled job Package1 that runs Package2 and then Package3 and Package2 failed, the result in Job History on Package1 is Successful. Why? How can I have the result Failed so I can get the failure notification.

Thanks,

DanYeung

look at DTS Package Properties at Logging tab; there is a check box "Fail package on first error", see if it is on or off.|||

I couldn't find the Logging tab on the DTS Package itself (atually there is no properties when I right clicked) and the schedule job under SQL Server Agent - Jobs. The tabs on the schedule job are General, Steps, Schedules, and Notifications. I am using SQL 2000. Can you please advise? Thanks

DanYeung

|||

in "locale packages" of DTS in Enterprise open yor package, right click on window surface and then "Package Properties"

|||

It works. I have to check it in all 3 pacakges. Thank you.

DanYeung

DTS Package Scheduled Job Result Issue

I am using SQL Server 2000. I created Package1, Package2, and Package3. If I ran from scheduled job Package2 and it failed, the result in Job History is Failed. If I ran from scheduled job Package1 that runs Package2 and then Package3 and Package2 failed, the result in Job History on Package1 is Successful. Why? How can I have the result Failed so I can get the failure notification.

Thanks,

DanYeung

look at DTS Package Properties at Logging tab; there is a check box "Fail package on first error", see if it is on or off.|||

I couldn't find the Logging tab on the DTS Package itself (atually there is no properties when I right clicked) and the schedule job under SQL Server Agent - Jobs. The tabs on the schedule job are General, Steps, Schedules, and Notifications. I am using SQL 2000. Can you please advise? Thanks

DanYeung

|||

in "locale packages" of DTS in Enterprise open yor package, right click on window surface and then "Package Properties"

|||

It works. I have to check it in all 3 pacakges. Thank you.

DanYeung