DTS Across Network Errors

I have a database and web server (physically different boxes) and I am
trying to get DTS to read in a file from the web server and insert the
data into the database. I get permissions errors when I try to execute
the job, so I am thinking if I could some how get the file over from
the web server on to the database server, then it would run fine.
This is a job, and it will happen every day.
Any suggestions would be very appreciated.
Check your security on that folder
If anything write a batch file that brings the file to you server
Schedule to run before DTS
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"michael.esposito@.gmail.com" wrote:

> I have a database and web server (physically different boxes) and I am
> trying to get DTS to read in a file from the web server and insert the
> data into the database. I get permissions errors when I try to execute
> the job, so I am thinking if I could some how get the file over from
> the web server on to the database server, then it would run fine.
> This is a job, and it will happen every day.
> Any suggestions would be very appreciated.
>
|||Mr. Sanbaka,
Here is the exact error I am getting...maybe this can help. I gave
Everyone full rights to the folder and it still doesnt work right.
Should I try creating a batch file to copy it to the DB server?
Error string: The Microsoft Jet database engine cannot open the file
'\\abc123\d$\mdb\WVL2000Mike.mdb'. It is already opened exclusively by
another user, or you need permission to view its data. Error
source: Microsoft JET Database Engine Help file:... Process Exit
Code 7. The step failed.
|||Michael
Make sure the databsae is not open by a user at the time DTS is trying to
access it.
If you were to use a batch file yes copy it to the server
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"michael.esposito@.gmail.com" wrote:

> Mr. Sanbaka,
> Here is the exact error I am getting...maybe this can help. I gave
> Everyone full rights to the folder and it still doesnt work right.
> Should I try creating a batch file to copy it to the DB server?
> Error string: The Microsoft Jet database engine cannot open the file
> '\\abc123\d$\mdb\WVL2000Mike.mdb'. It is already opened exclusively by
> another user, or you need permission to view its data. Error
> source: Microsoft JET Database Engine Help file:... Process Exit
> Code 7. The step failed.
>
|||Thats the problem I am having, I get permissions errors when I try to
use a batch file to move it over

DTS Across Network Errors

I have a database and web server (physically different boxes) and I am
trying to get DTS to read in a file from the web server and insert the
data into the database. I get permissions errors when I try to execute
the job, so I am thinking if I could some how get the file over from
the web server on to the database server, then it would run fine.
This is a job, and it will happen every day.
Any suggestions would be very appreciated.Check your security on that folder
If anything write a batch file that brings the file to you server
Schedule to run before DTS
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"michael.esposito@.gmail.com" wrote:
> I have a database and web server (physically different boxes) and I am
> trying to get DTS to read in a file from the web server and insert the
> data into the database. I get permissions errors when I try to execute
> the job, so I am thinking if I could some how get the file over from
> the web server on to the database server, then it would run fine.
> This is a job, and it will happen every day.
> Any suggestions would be very appreciated.
>|||Mr. Sanbaka,
Here is the exact error I am getting...maybe this can help. I gave
Everyone full rights to the folder and it still doesnt work right.
Should I try creating a batch file to copy it to the DB server?
Error string: The Microsoft Jet database engine cannot open the file
'\\abc123\d$\mdb\WVL2000Mike.mdb'. It is already opened exclusively by
another user, or you need permission to view its data. Error
source: Microsoft JET Database Engine Help file:... Process Exit
Code 7. The step failed.|||Michael
Make sure the databsae is not open by a user at the time DTS is trying to
access it.
If you were to use a batch file yes copy it to the server
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"michael.esposito@.gmail.com" wrote:
> Mr. Sanbaka,
> Here is the exact error I am getting...maybe this can help. I gave
> Everyone full rights to the folder and it still doesnt work right.
> Should I try creating a batch file to copy it to the DB server?
> Error string: The Microsoft Jet database engine cannot open the file
> '\\abc123\d$\mdb\WVL2000Mike.mdb'. It is already opened exclusively by
> another user, or you need permission to view its data. Error
> source: Microsoft JET Database Engine Help file:... Process Exit
> Code 7. The step failed.
>|||Thats the problem I am having, I get permissions errors when I try to
use a batch file to move it over

DTS Across Network Errors

I have a database and web server (physically different boxes) and I am
trying to get DTS to read in a file from the web server and insert the
data into the database. I get permissions errors when I try to execute
the job, so I am thinking if I could some how get the file over from
the web server on to the database server, then it would run fine.
This is a job, and it will happen every day.
Any suggestions would be very appreciated.Check your security on that folder
If anything write a batch file that brings the file to you server
Schedule to run before DTS
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"michael.esposito@.gmail.com" wrote:

> I have a database and web server (physically different boxes) and I am
> trying to get DTS to read in a file from the web server and insert the
> data into the database. I get permissions errors when I try to execute
> the job, so I am thinking if I could some how get the file over from
> the web server on to the database server, then it would run fine.
> This is a job, and it will happen every day.
> Any suggestions would be very appreciated.
>|||Mr. Sanbaka,
Here is the exact error I am getting...maybe this can help. I gave
Everyone full rights to the folder and it still doesnt work right.
Should I try creating a batch file to copy it to the DB server?
Error string: The Microsoft Jet database engine cannot open the file
'\\abc123\d$\mdb\WVL2000Mike.mdb'. It is already opened exclusively by
another user, or you need permission to view its data. Error
source: Microsoft JET Database Engine Help file:... Process Exit
Code 7. The step failed.|||Michael
Make sure the databsae is not open by a user at the time DTS is trying to
access it.
If you were to use a batch file yes copy it to the server
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"michael.esposito@.gmail.com" wrote:

> Mr. Sanbaka,
> Here is the exact error I am getting...maybe this can help. I gave
> Everyone full rights to the folder and it still doesnt work right.
> Should I try creating a batch file to copy it to the DB server?
> Error string: The Microsoft Jet database engine cannot open the file
> '\\abc123\d$\mdb\WVL2000Mike.mdb'. It is already opened exclusively by
> another user, or you need permission to view its data. Error
> source: Microsoft JET Database Engine Help file:... Process Exit
> Code 7. The step failed.
>|||Thats the problem I am having, I get permissions errors when I try to
use a batch file to move it over

dtexec over the network

Hi All,

I'm trying to execute DTExec from a workstation and I got some help from a different group without luck maybe someone here can help me.

This is what I try so far.

1. My package run in command line from my sql box using dtexec with
parameters.
2. Set the package with DontSaveSensitive and import into IS under MSDB with
the same option setup.
3. Set package role to public.
4. Share DTS folder with everyone permission just for testing.
5. Execute the package from a workstation using
//sqlServerbox/DTS/BINN/dtexec /dts "msdb/mypackage" /SER "MySQLServer" /set
\package.variables[myvariable].Value;"myvalue1,myvalue2"
(myvariable is string and I can pass multiple values separate by commas)
6. Still getting error:
Error: 2007-02-09 10:31:34.31
Code: 0xC0010018
Source: Execute DTS 2000 Package Task
Description: Error loading a task. The contact information for the task
is "E
xecute DTS 2000 Package Task;Microsoft Corporation; Microsoft SQL Server v9;
? 2
004 Microsoft Corporation; All Rights
Reserved;http://www.microsoft.com/sql/supp
ort/default.asp;1". This happens when loading a task fails.
End Error

Anyone has any ideas?

Any help will be appreciate it. Tks in advance...

Rgds

Johnny

You can't just run DTEXEC without installing it. You need to install SSIS locally.|||

That is not true... I can run a package from a workstation without installing IS, I share the dts folder and it's working...

Anybody else try this?

Tks

JFB

|||

I don't understand. You start a thread by asking why it does not work. Now you claim it is working.

Do you have Client Components installed on the workstation? If you do, you can simply run your own DTEXEC from Program Files instead of running it from network share.

|||Tks for you reply. If you read my first post with careful you will see that the package run without installing IS on the workstation. I have and error and thats my problem, I can't figure out the error ... I believe is a security issue but I don't know how to fix this.
I will keep trying to get more info about it or if anybody try this or know how to solve this problem.
Rgds

JFB|||

DTSuser wrote:

Tks for you reply. If you read my first post with careful you will see that the package run without installing IS on the workstation. I have and error and thats my problem, I can't figure out the error ... I believe is a security issue but I don't know how to fix this.
I will keep trying to get more info about it or if anybody try this or know how to solve this problem.
Rgds

JFB

Right, but I think what Michael is saying is that even though dtexec executes, you are still missing libraries and such that will be required to execute that. You aren't executing dtexec on the remote box, you are executing a remote copy of dtexec on your box. Hence, you will need to install the SSIS client tools.

DTC error

Hi,
I have two MS SQL2000 servers in local network . Let's
say A and B. Server B is linked server for A.
When I'm starting following select on server A :
========================================= BEGIN TRAN
SELECT *
FROM OPENQUERY(DW_SERVER, 'SELECT p.AP_ID,
p.AP_NAME, p.PT_NAME,
p.AP_DEBIT_SOURCE, dbo.UF_GET_FULL_SOURCE
(p.AP_DEBIT_SOURCE, p.PT_NAME) AS AP_FULL_SOURCE,
p.AP_VOL_FACE, p.AP_TIME_FACE,
p.AP_EXPIRED_PERIOD
FROM dbo.AAA_DW_PROFILE_DIM p ')
ROLLBACK TRAN
============================================
I'm getting following error:
========================================= Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB
provider 'SQLOLEDB' was unable to begin a distributed
transaction.
[OLE/DB provider returned message: New transaction cannot
enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
==========================================
DTC is started on both servers.
During investigation of this issue I've started
DTCPing utilite. After this, in DTCPing's log file
I have found only following problem string:
================================================= 07-14, 19:55:100-->WARNING:the CID values for both test
machines are the same
while this problem won't stop DTCping test, MSDTC
will fail for this
====================================================
Am I right? The error was connected with this issue?
What should I do next?What is dbo.UF_GET_FULL_SOURCE in your SQL? and has no comma after
"andy" <akorotaev@.estylesoft.com> wrote in message
news:07dd01c34ab1$8b611c90$a601280a@.phx.gbl...
> Hi,
> I have two MS SQL2000 servers in local network . Let's
> say A and B. Server B is linked server for A.
> When I'm starting following select on server A :
> =========================================> BEGIN TRAN
> SELECT *
> FROM OPENQUERY(DW_SERVER, 'SELECT p.AP_ID,
> p.AP_NAME, p.PT_NAME,
> p.AP_DEBIT_SOURCE, dbo.UF_GET_FULL_SOURCE
> (p.AP_DEBIT_SOURCE, p.PT_NAME) AS AP_FULL_SOURCE,
> p.AP_VOL_FACE, p.AP_TIME_FACE,
> p.AP_EXPIRED_PERIOD
> FROM dbo.AAA_DW_PROFILE_DIM p ')
> ROLLBACK TRAN
> ============================================> I'm getting following error:
> =========================================> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB
> provider 'SQLOLEDB' was unable to begin a distributed
> transaction.
> [OLE/DB provider returned message: New transaction cannot
> enlist in the specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a].
> ==========================================> DTC is started on both servers.
> During investigation of this issue I've started
> DTCPing utilite. After this, in DTCPing's log file
> I have found only following problem string:
> =================================================> 07-14, 19:55:100-->WARNING:the CID values for both test
> machines are the same
> while this problem won't stop DTCping test, MSDTC
> will fail for this
> ====================================================> Am I right? The error was connected with this issue?
> What should I do next?
>
>
>
>
>|||dbo.UF_GET_FULL_SOURCE is function.
No any comma needed here.
>--Original Message--
>What is dbo.UF_GET_FULL_SOURCE in your SQL? and has no
comma after
>"andy" <akorotaev@.estylesoft.com> wrote in message
>news:07dd01c34ab1$8b611c90$a601280a@.phx.gbl...
>> Hi,
>> I have two MS SQL2000 servers in local network . Let's
>> say A and B. Server B is linked server for A.
>> When I'm starting following select on server A :
>> =========================================>> BEGIN TRAN
>> SELECT *
>> FROM OPENQUERY(DW_SERVER, 'SELECT p.AP_ID,
>> p.AP_NAME, p.PT_NAME,
>> p.AP_DEBIT_SOURCE, dbo.UF_GET_FULL_SOURCE
>> (p.AP_DEBIT_SOURCE, p.PT_NAME) AS AP_FULL_SOURCE,
>> p.AP_VOL_FACE, p.AP_TIME_FACE,
>> p.AP_EXPIRED_PERIOD
>> FROM dbo.AAA_DW_PROFILE_DIM p ')
>> ROLLBACK TRAN
>> ============================================>> I'm getting following error:
>> =========================================>> Server: Msg 7391, Level 16, State 1, Line 2
>> The operation could not be performed because the OLE DB
>> provider 'SQLOLEDB' was unable to begin a distributed
>> transaction.
>> [OLE/DB provider returned message: New transaction
cannot
>> enlist in the specified transaction coordinator. ]
>> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
>> ITransactionJoin::JoinTransaction returned 0x8004d00a].
>> ==========================================>> DTC is started on both servers.
>> During investigation of this issue I've started
>> DTCPing utilite. After this, in DTCPing's log file
>> I have found only following problem string:
>> =================================================>> 07-14, 19:55:100-->WARNING:the CID values for both test
>> machines are the same
>> while this problem won't stop DTCping test, MSDTC
>> will fail for this
>> ====================================================>> Am I right? The error was connected with this issue?
>> What should I do next?
>>
>>
>>
>>
>
>.
>|||Andy,
take a look at technet article Q306843.
Section 11 refers to duplicate CIDs and using GUIDGEN to
fix this...
You might also want to look at the following article :
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;162001
I am guessing this is on a ghosted or cloned server ?
Hope this helps.
Steve.
>--Original Message--
>
>dbo.UF_GET_FULL_SOURCE is function.
>No any comma needed here.
>
>>--Original Message--
>>What is dbo.UF_GET_FULL_SOURCE in your SQL? and has no
>comma after
>>"andy" <akorotaev@.estylesoft.com> wrote in message
>>news:07dd01c34ab1$8b611c90$a601280a@.phx.gbl...
>> Hi,
>> I have two MS SQL2000 servers in local network . Let's
>> say A and B. Server B is linked server for A.
>> When I'm starting following select on server A :
>> =========================================>> BEGIN TRAN
>> SELECT *
>> FROM OPENQUERY(DW_SERVER, 'SELECT p.AP_ID,
>> p.AP_NAME, p.PT_NAME,
>> p.AP_DEBIT_SOURCE, dbo.UF_GET_FULL_SOURCE
>> (p.AP_DEBIT_SOURCE, p.PT_NAME) AS AP_FULL_SOURCE,
>> p.AP_VOL_FACE, p.AP_TIME_FACE,
>> p.AP_EXPIRED_PERIOD
>> FROM dbo.AAA_DW_PROFILE_DIM p ')
>> ROLLBACK TRAN
>> ============================================>> I'm getting following error:
>> =========================================>> Server: Msg 7391, Level 16, State 1, Line 2
>> The operation could not be performed because the OLE DB
>> provider 'SQLOLEDB' was unable to begin a distributed
>> transaction.
>> [OLE/DB provider returned message: New transaction
>cannot
>> enlist in the specified transaction coordinator. ]
>> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
>> ITransactionJoin::JoinTransaction returned 0x8004d00a].
>> ==========================================>> DTC is started on both servers.
>> During investigation of this issue I've started
>> DTCPing utilite. After this, in DTCPing's log file
>> I have found only following problem string:
>> =================================================>> 07-14, 19:55:100-->WARNING:the CID values for both test
>> machines are the same
>> while this problem won't stop DTCping test, MSDTC
>> will fail for this
>> ====================================================>> Am I right? The error was connected with this issue?
>> What should I do next?
>>
>>
>>
>>
>>
>>.
>.
>

DSN-less connection to SQL Server with sql 7 and sql 2k

Hi,
I have commercial asp webspace hosting an application that connects to
an SQL machine on my local network. THe machine has both SQL 7 and SQL
2k running on it. Webspace and SQL are both running on Win2k.
The connection string I am using is as follows:
Application("Application_ConnectionString") = "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=aaa.bbb.ccc.ddd,1433;" & _
"Initial Catalog=DBName;" & _
"User ID=xxx;" & _
"Password=yyy;"
It works fine when pointing to a database in the sql 7 instance. But
what I want to achieve is to connect to a database in the sql 2k
instance. Running locally, I can achieve this by substituting
aaa.bbb.ccc.ddd\servername_sql2k. But I cannot get it to connect to
the sql 2k instance from the commercial webspace. I get the following
message in this case:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBMSSOCN]General network error. Check your network documentation.
SO, my question is, how do you address a database in the sql 2k
instance via a dsn-less connection? Do you have to set SQL 7 and SQL
2k to listen on different ports? I have tried this but have not met
with success.
Any help gratefully received...
Thanks in advanceCan you make a connection from a DSN from the commercial webspace using
aaa.bbb.ccc.ddd\servername_sql2k as the server name?
Also can you connect via Query Analyzer form the commercial webspace using
that servername?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Hi Rand
Thanks for your reply. Restricted access to the commercial web space
means that I DSN cannot be established, hence the DSN less connection.
For that reason I cannot try your suggestion of connecting Query
Analyser from that server. However, I have ascertained that both
instances of SQL Server can be reached from an external server by
connecting from a server where where I do have SQL and OS level
access.
rboyd@.onlinemicrosoft.com (Rand Boyd [MSFT]) wrote in message news:<A1F7CV6gEHA.480@.cpms
ftngxa06.phx.gbl>...
> Can you make a connection from a DSN from the commercial webspace using
> aaa.bbb.ccc.ddd\servername_sql2k as the server name?
> Also can you connect via Query Analyzer form the commercial webspace using
> that servername?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.

DSN-less connection to SQL Server with sql 7 and sql 2k

Hi,
I have commercial asp webspace hosting an application that connects to
an SQL machine on my local network. THe machine has both SQL 7 and SQL
2k running on it. Webspace and SQL are both running on Win2k.
The connection string I am using is as follows:
Application("Application_ConnectionString") = "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=aaa.bbb.ccc.ddd,1433;" & _
"Initial Catalog=DBName;" & _
"User ID=xxx;" & _
"Password=yyy;"
It works fine when pointing to a database in the sql 7 instance. But
what I want to achieve is to connect to a database in the sql 2k
instance. Running locally, I can achieve this by substituting
aaa.bbb.ccc.ddd\servername_sql2k. But I cannot get it to connect to
the sql 2k instance from the commercial webspace. I get the following
message in this case:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBMSSOCN]General network error. Check your network documentation.
SO, my question is, how do you address a database in the sql 2k
instance via a dsn-less connection? Do you have to set SQL 7 and SQL
2k to listen on different ports? I have tried this but have not met
with success.
Any help gratefully received...
Thanks in advance
Can you make a connection from a DSN from the commercial webspace using
aaa.bbb.ccc.ddd\servername_sql2k as the server name?
Also can you connect via Query Analyzer form the commercial webspace using
that servername?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Hi Rand
Thanks for your reply. Restricted access to the commercial web space
means that I DSN cannot be established, hence the DSN less connection.
For that reason I cannot try your suggestion of connecting Query
Analyser from that server. However, I have ascertained that both
instances of SQL Server can be reached from an external server by
connecting from a server where where I do have SQL and OS level
access.
rboyd@.onlinemicrosoft.com (Rand Boyd [MSFT]) wrote in message news:<A1F7CV6gEHA.480@.cpmsftngxa06.phx.gbl>...
> Can you make a connection from a DSN from the commercial webspace using
> aaa.bbb.ccc.ddd\servername_sql2k as the server name?
> Also can you connect via Query Analyzer form the commercial webspace using
> that servername?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.