Who is online?
0
guests and
1
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: dtexec
37 results found
setting package variable at run time with
dtexec
and /SET in 2008
What is the problem that you are having? Are you trying to use variables in the stored procedure to build this statement and that is where the problem is coming in or what? If that is the issue then you are going to have to store the entire DTEXEC command
Author:
BradSchacht
Date: 10/27/2010 Section:
Forum
tags :
dtexec
,
SQL
Configuration vs Set Command
dtexec
in SSIS
I had an interesting question from a student in one of my SSIS classes. If you are calling a package from the DTexec command using the set command to pass in a variable value and the package has a configuration file setting the variable value, which one w
Author:
MikeDavis
Date: 11/12/2009 Section:
Blog
tags :
SSIS dt exec configuration files
Unable to Execute Dtexec in 64Bit Env
HI, I am trying to execute following query to execute ETL in parallel..Its giving me error as Invalid switch /F. Its on 64bit Env but my packages are 32bit. I am using Excel as source Start /Affinity 4 /Min "C:\Program Files (x86)\Microsoft SQL Server\100
Author:
guptaopus
Date: 3/12/2012 Section:
Forum
tags :
dtexec
Stored Proc: xp_cmdshell to exec
dtexec
utility
UPDATE / Solution? - You decide. Resolution: Lack of understanding as to how a SQL Agent Job functions when executed within a Stored Procedure. Brief Recap: Stored procedure executed from a sql script. Stored procedure expects 1 parameter. Within Stored P
Author:
JohnG
Date: 7/29/2010 Section:
Forum
tags :
dtexec utility
,
sql agent job
,
Stored Procedure
,
SSIS
Stored Proc: xp_cmdshell to exec
dtexec
utility
Hi all ! I hope this is the correct forum for this type of question. Here's a synap of my program. 1. C# GUI calls Stored Procedure 2. Stored Procedue Executes xp_cmdshell 3. xp_cmdshell Executes dtexec SSIS.dtsx package (Sql Server 2008, BIDS, SSMS, Win7
Author:
JohnG
Date: 7/28/2010 Section:
Forum
tags :
dtexec
,
sql agent job
,
ssis
Minimum Requirements
John, Is this in relation to your previous post regarding running a package using dtexec and xp_cmdshell? http://bidn.com/forums/microsoft-business-intelligence/sql-server/270/stored-proc-xp_cmdshell-to-exec-dtexec-utility#1132 Hopefully I was able to hel
Author:
briankmcdonald
Date: 7/31/2010 Section:
Forum
Unable to Execute Dtexec in 64Bit Env
Guru, Does "Start" accept multiple parameters for running a file? Maybe try it this way so you're quoting / enclosing the parameters along with the command: Start /Affinity 4 /Min "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTEXEC.exe /F C:\
Author:
KeithHyer
Date: 3/14/2012 Section:
Forum
tags :
32-bit
oracle data source input in SSIS
I believe the precisions is (18,2), but you can also cast it back out to float if you want to. As for the 32 bit guidance, I'm speculating that it's almost identical to your development environment, except you don't need to have BIDS there, but if you do
Author:
m3crast
Date: 3/9/2011 Section:
Forum
Stored Proc: xp_cmdshell to exec
dtexec
utility
Update: Sql Agent Job runs a T-Sql query that executes via xp_cmdshell, the SSIS package then imports data into the table. That's the theory, tested doesn't work. Question: can Sql Agent Job execute xp_cmdshell? Eliminations: -- Tested SSIS package with d
Author:
JohnG
Date: 7/29/2010 Section:
Forum
tags :
SQL Agent Job
,
Stored Procedure
,
sql agent job
Passing a filepath in SSIS
Ah, okay. From the OP I didn't realize that the path was subject to change. Operating under the assumption that the column names will never change from file to file, my first thought for solving an issue like this would be to configure your Excel Connecti
Author:
kylewalker
Date: 8/23/2010 Section:
Forum
tags :
expressions
,
Package Variables
,
ssis
Setting up an SSIS package with a dymanic Excel Source
Just the other day, we had a forum post here on BIDN that was asking how to set up an SSIS package with a dynamic Excel source. This source can be stored in a different file path or even with a different name on any given day. A solution for this scenario
Author:
kylewalker
Date: 8/24/2010 Section:
Blog
tags :
Excel Source
,
Package Variables
,
SSIS
Eight ways of executing SSIS package and passing parameters (T-SQL, VB.net, C#, SQLAgent, DTExec)
This article will explain how to execute SSIS package using different methods and make package dynamic by passing parameters via commandline or using VB.net/C# API
Author:
NayanPatel
Date: 12/15/2009 Section:
Article
tags :
SQL Agent Proxy SSIS Scheduling Parameter
setting package variable at run time with
dtexec
and /SET in 2008
I understand that in 2008 that the design time configurations over-ride the run time /SET variables when you run dtexec. However, I am also having the same behavior for non-package configured Package-level varaibles that I want to change at run time with
Author:
olapdba
Date: 10/27/2010 Section:
Forum
setting package variable at run time with
dtexec
and /SET in 2008
I'm running it with the dtexec in a string like declare @ssisstr varchar(8000) declare @params varchar(8000) set @params =' /SET \package.variables[User::StartDate].Value;"' + @StartDate +'" /SET \package.variables[User::EndDate].Value;"' + @EndDate +'"'
Author:
olapdba
Date: 10/28/2010 Section:
Forum
Passing a filepath in SSIS
Hi Kylewalker, Could you please provide me the screenshots on how to configure Excel Connection Manager with an expression that uses a package variable ? and this is the procedure that i have created by using dtexec utility. -- exec dbo.import_data 'C:\Do
Author:
nicky_river
Date: 8/24/2010 Section:
Forum
setting package variable at run time with
dtexec
and /SET in 2008
Here is the syntax: dtexec /sq "\Folder\testdtexec" /ser hostname /SET \package.variables[User::StartDate].Value;"07/01/2010 00:00:00.000" /SET \package.variables[User::EndDate].Value;"07/30/2010 00:00:00.000"
Author:
olapdba
Date: 10/27/2010 Section:
Forum
SSIS - "Microsoft.Jet.OLEDB.4.0" has not been registered." error in 64 bit machine
Hi Devin Thanks for the suggestion. I tried to run the package using 32 bit DTEXEC in command mode and still the same error, C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn>dtexec /FILE "D:\Projects\Daily_data_loader.dtsx" Microsoft (R) SQL Se
Author:
meganathank
Date: 2/25/2011 Section:
Forum
Minimum Requirements
Situation: Test User needs to run an application that executes stored procedures, which execute SSIS packages. Test User's PC is not installed with the FULL version of Sql Server 2008 R2 Resolution: In order for Test User to execute dtexec for package exe
Author:
JohnG
Date: 7/30/2010 Section:
Forum
tags :
installation requirements
,
SQL Agent Job
Security issue with SSIS called from proc
I am writing a stored proc that calls a SSIS package, that works on its own, but gives me the following error when I run it from a stored proc: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified s
Author:
EZPikins
Date: 12/3/2011 Section:
Forum
Security issue with SSIS called from proc
I think it has to do with the account I am running on the server, it has admin sql permissions and therefore trusts me to run this. When I run it from a stored proc, sql server tells me "bad login for user". I can force the issue by editing the .dtsx file
Author:
EZPikins
Date: 12/6/2011 Section:
Forum
Stored Proc: xp_cmdshell to exec
dtexec
utility
Brian, Okay. Yes. Thank you for your advice. We have a SQL Agent job and I'm in the process of figuring this app out. I noticed the tabs in the steps look familiar to the tabs in dtexec util. I'm sure I'll get it. Just takes time to figure out.
Author:
JohnG
Date: 7/28/2010 Section:
Forum
SSIS - "Microsoft.Jet.OLEDB.4.0" has not been registered." error in 64 bit machine
I would try next to run it from the command line dtexec. You'll need to run the 32 - bit version though. http://msdn.microsoft.com/en-us/library/ms162810.aspx
Author:
DevinKnight
Date: 2/25/2011 Section:
Forum
oracle data source input in SSIS
am35 said: 1.So, I can go ahead and use the "microsoft oledb provider for oracle" to connect to the oracle datasource? I would use the OraOledb provider for 64 bit. If you use the MSDORA.1 provider, I think you need to run the package in 32 bit mode, see
Author:
m3crast
Date: 3/9/2011 Section:
Forum
Passing values from Parent package to Child package on specific case
Gotcha what you could do then is make it either run the packages from a command line using DTEXEC, which will allow you to pass in values to variables, or you could create a SQL Agent job that runs the packages and under the Set Values tab it will allow y
Author:
DevinKnight
Date: 3/11/2011 Section:
Forum
How can you pass the parameters to the package at runtime in SSIS?
You'll want to create variables in you package and then you can pass values into those variables by running the package using DTEXEC, a sql agent job, or config files. Let me know if you need more details on how this is done. There should be a lot of docu
Author:
DevinKnight
Date: 3/14/2011 Section:
Forum
Page 1 of 2 (37 items)
<< Prev
1
2
Next >>
Go to page:
[Go]