Advertisement

09.22.2008 at 08:55PM PDT, ID: 23753805
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
9.3

xp_cmdshell to store the file name into a temp table when reading from  a partticular directory

Asked by countrymeister in MySQL Server, SQL Server 2005

Tags: ,

I am using the xp_cmdshell to execute a script to read the file name from a particular directory

If I browse the directory I see the file, but when I execute the following script, It does not insert the file name, it inserts null.

I have logged in as a SA, when executing the script
Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:

use dbtrades
go
Declare
	@sql         		VarChar(2000)
,	@File         		VarChar(30)
,	@FullFile    		VarChar(255)
,	@FileArchiveName	VarChar(100)
,	@DateInq    		Char(8)
,	@strCmd    		nVarChar(300)
,	@msg         		VarChar(300)
,	@strSourceDir    	VarChar(100)
,	@fTradeDate		DateTime
,	@fBroker		VarChar(3)
,	@fTradingArea		Char(4)
,	@fDataSource		VarChar(50)
,	@fFX			Char(3)
,   @TradeDate	DateTime	
,	@FileDir	VarChar(255)	
,	@ArchiveDir	VarChar(255)	
 
/*
drop table #tmpFiles
drop table #tmpCusip
drop table #checkfile
drop table #tmpRecords
*/
 
Create	Table #tmpFiles
	(	FileNames	VarChar(30)
	)
 
 
Create	Table #tmpCusip
	(	Cusip		VarChar(8)
	)
 
 
If @TradeDate Is Null
	Set @TradeDate = Convert(VarChar, GetDate(), 101)
 
 
If @FileDir Is Null
	
    Set @FileDir    = '\\Test\Data\Users\trades\'    
 
 
If @ArchiveDir Is Null
	Set @ArchiveDir	= '\\Test\Data\Users\trades\Archive\'
 
 
Set @DateInq	= Convert(Char(8), @TradeDate, 112)
 
 
 
 
  --* Obtain all of the file names for each type of Initialization file. *--
Set @strCmd = '@echo off & for %I in (' + @FileDir + @DateInq + '*.txt) do echo %~nxI '
--print @strCmd
Insert Into #tmpFiles Exec master.dbo.xp_cmdshell @strCmd
 
 
select * from #tmpFiles
 
Keywords: xp_cmdshell to store the file name into…
Title
1 xp_cmdshell with variable
2 xp_cmdshell returns NULL
3 exec DTS within a SP:  xp_cmdshell …
4 Running SSIS package/XP_CMDSHELL
5 xp_cmdshell returns null
6 Trigger and xp_cmdshell
 
Loading Advertisement...
 
[+][-]09.22.2008 at 09:40PM PDT, ID: 22546463

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.23.2008 at 04:01AM PDT, ID: 22548026

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.23.2008 at 06:18AM PDT, ID: 22548896

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MySQL Server, SQL Server 2005
Tags: Microsoft, T-SQL xp_cmdshell
Sign Up Now!
Solution Provided By: BrandonGalderisi
Participating Experts: 1
Solution Grade: A
 
 
[+][-]09.24.2008 at 07:38AM PDT, ID: 22560161

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.24.2008 at 07:50AM PDT, ID: 22560302

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628