> Hi Alllan,
>
> Once again, thx. for the help. I really appreciate it. I think I found
> the solution to my problem, which happens to be an error on my part.
> It turns out the dts pkg's were using winnt authentication rather than
> sql server, so the connection error. All seems to be well, now.
>
> sorry about that.
>
> jim
> "Allan Mitchell" wrote:
>> Hello Jim,
>>
>> To use DTSRun you have to have at least the runtime installed on the
>> box that does the calling of the package as the package runs from the
>> place calling it and not on its storage location.
>>
>> I will presume that the package is stored on a SQL Server somewhere.
>>
>> The error may not be from the retrieval of the package from storage
>> but from a connection internally.
>>
>> What account are things running under?
>>
>> You can trace the storage server to see if the attempt gets made to
>> retrieve from the storage there.
>>
>> --
>>
>> Allan Mitchell
>> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
>> |
>> http://www.konesans.com
>>> Hi Allan,
>>>
>>> I'm not sure I follow you about the runtine w/ MSDE 1.0. The
>>> packages are running per the dtsrun utility (command prompt). I have
>>> one pkg that does not have any global variables. The remaining do.
>>> However, I receive the following error msg:
>>>
>>> Error #: -2147467259
>>> Error Desc: [DBNETLIB][ConnectionOpen(Connect()] SQL Server does not
>>> exist
>>> or access denied
>>> Error Source: Microsoft OLE DB Provider for SQL Server.
>>> The above error is not appearing the in the vb app (removed error
>>> handling). Also, the odd thing about this error is, I'm able to run
>>> the stored procedures in the dts pkg's via osql.exe w/ no problem.
>>> That is, e.g. osql -S <username> -P <password> -d <DBName> -q "EXEC
>>> Get_MyData @parm1='something'". The data is returned w/ no
>>> Connection
>>> problem. I do the same w/ dtsrun /S <username> /P <password> -N
>>> <pkgname>.
>>> The pkg's w/ the global variables can't be executed properly because
>>> I can't the use /A switch.
>>>
>>> I've even used the "sa" login to execute the dts pkg and still
>>> receiving connection error.
>>>
>>> any help is appreciated.
>>>
>>> jim
>>> "Allan Mitchell" wrote:
>>>> Hello Jim,
>>>>
>>>> So you are using SQL Server 7?
>>>>
>>>> Only the runtime is installed with MSDE 7. How do you know the
>>>> package runs or think it runs?
>>>>
>>>> --
>>>>
>>>> Allan Mitchell
>>>> http://wiki.sqlis.com | http://www.sqlis.com |
>>>> http://www.sqldts.com
>>>> |
>>>> http://www.konesans.com
>>>>> Hello,
>>>>>
>>>>> I have vb (6.0) app that attempts to execute a couple of dts
>>>>> packages. The pkg's merely does some data retrieval and pumps the
>>>>> data into a text file (.dat). The app runs fine on the machine
>>>>> that have sql server (7.0) installed. However, on the machine w/
>>>>> MSDE the app appears to be executing the pkg but the text file is
>>>>> not being created or the data is not being stored into file.
>>>>>
>>>>> Not sure why this is happening.
>>>>>
>>>>> any help is appreciated.
>>>>>