Showing posts with label loading. Show all posts
Showing posts with label loading. Show all posts

Wednesday, March 7, 2012

dtutil and xml configuration file

Hi,

Im loading the packages with a dutil-batch from the file-system into the sqlserver.

All the packages have xml-configuration-file.

for %%f in (*.dtsx) do dtutil /FILE %%f /COPY SQL;%%~nf /DestServer server /QUIET

When I try to run the packages in the sqlserver environment there is no configuration file found.

Is there a possibility to transfer also the link to the xml-configuration-file xml-configuration-file with dtutil?

Thanks Gerd

Moving to a better forum|||Try using the DTSDeployment utility to deploy packages that reference configuration files. The deployment utility will allow you to specify where to put the config files and will update the packages accordingly.|||

Hi

I am also in the same boat. I dont want to use deployment utility as I want to create a batch file. adminstrator will use this batch file to deploy on prod server.

I have configuration file that needs to be deployed on server along with package. please tell me if it possible or please give me work around for this.

|||You can specify the location of the configuration file when you run the package by using the /ConfigFile switch of DTEXEC.

dtutil and xml configuration file

Hi,

Im loading the packages with a dutil-batch from the file-system into the sqlserver.

All the packages have xml-configuration-file.

for %%f in (*.dtsx) do dtutil /FILE %%f /COPY SQL;%%~nf /DestServer server /QUIET

When I try to run the packages in the sqlserver environment there is no configuration file found.

Is there a possibility to transfer also the link to the xml-configuration-file xml-configuration-file with dtutil?

Thanks Gerd

Moving to a better forum|||Try using the DTSDeployment utility to deploy packages that reference configuration files. The deployment utility will allow you to specify where to put the config files and will update the packages accordingly.|||

Hi

I am also in the same boat. I dont want to use deployment utility as I want to create a batch file. adminstrator will use this batch file to deploy on prod server.

I have configuration file that needs to be deployed on server along with package. please tell me if it possible or please give me work around for this.

|||You can specify the location of the configuration file when you run the package by using the /ConfigFile switch of DTEXEC.

dtutil and xml configuration file

Hi,

Im loading the packages with a dutil-batch from the file-system into the sqlserver.

All the packages have xml-configuration-file.

for %%f in (*.dtsx) do dtutil /FILE %%f /COPY SQL;%%~nf /DestServer server /QUIET

When I try to run the packages in the sqlserver environment there is no configuration file found.

Is there a possibility to transfer also the link to the xml-configuration-file xml-configuration-file with dtutil?

Thanks Gerd

Moving to a better forum|||Try using the DTSDeployment utility to deploy packages that reference configuration files. The deployment utility will allow you to specify where to put the config files and will update the packages accordingly.|||

Hi

I am also in the same boat. I dont want to use deployment utility as I want to create a batch file. adminstrator will use this batch file to deploy on prod server.

I have configuration file that needs to be deployed on server along with package. please tell me if it possible or please give me work around for this.

|||You can specify the location of the configuration file when you run the package by using the /ConfigFile switch of DTEXEC.

Friday, February 17, 2012

dts vs. job

I have a DTS package that runs fine on a SQL 7 sp3 box. When I try and run
it as a job it fails with this error:
DTSRun: Loading...
Error: -2147287038 (80030002); Provider Error: 0 (0)
Error string: The system cannot find the file specified.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 713
Any ideas?Check out the following article:
269074 INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074
Rand
This posting is provided "as is" with no warranties and confers no rights.|||jj,
The problem is probably the context that DTS is executing under. One thing
to remember is that DTS is a client process, not a server process.
When run interactively, where is it running? If you are running it from your
machine, then access to the package would be obtained using your domain
rights. If you login to the SQL7 box, then the login that you use must have
the proper domain rights to get to the file.
Now, when you run it as a SQL Agent job, it will run either as the SQL
Server service account (e.g. MyDomain/MySQLServer) or if the job is not
owned by a sysadmin it runs as the SQL Agent proxy account (e.g.
MyDomain/MySQLAgentProxy). See:
xp_sql_agent_proxy
http://msdn.microsoft.com/library/d...-us/tsqlref/ts_
xp_aa-sz_8sdm.asp
SQL Server Agent Permissions Checks
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_automate_054p.asp
Which ever account is _actually_ in use must have the necessary rights to
access the package.
Russell Fields
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:eLsAD$eBEHA.744@.TK2MSFTNGP10.phx.gbl...
> I have a DTS package that runs fine on a SQL 7 sp3 box. When I try and run
> it as a job it fails with this error:
> DTSRun: Loading...
> Error: -2147287038 (80030002); Provider Error: 0 (0)
> Error string: The system cannot find the file specified.
> Error source: Microsoft Data Transformation Services (DTS) Package
> Help file: sqldts.hlp
> Help context: 713
> Any ideas?
>