Tuesday, March 27, 2012
DTS question
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
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
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