如何在SSIS脚本任务中获取文件名称 [英] How To Get Files name in SSIS script task

问题描述

SQLSERVER 2012

我想将多个图像文件从指定目录加载到SQL表。在一列中，我可以保存图像，而在另一列中，我想保存目录中的相应名称。我使用的任务

SQLSERVER 2012

1.Foreach循环容器 - 读取文件

2.Script任务---获取文件名但我不能。

我可以在DB中成功加载文件，但我没有得到它各自的名字......

也在我的脚本任务中它没有显示： -

REVERSE（字符串）功能

屏幕截图 http：// oi49.tinypic.com/2uhlufc.jpg [ ^ ]

http://tinypic.com/view.php?pic=sor7lu& ; s = 6 [ ^ ]

解决方案

如果问题仅在于intellisense没有在脚本任务中显示反向函数，为什么不尝试编写它。有关语法，请参阅 REVERSE（SSIS Expression） [ ^ ]



此外，由于您在查找文件时遇到问题，以下示例可能会帮助您转发：使用以下方法检测空平面文件脚本任务 [ ^ ]

以下是您的请求的完美示例。

http： //www.sqldts.com/304-2.aspx [ ^ ]

SQLSERVER 2012
I want to load multiple image files from a specified directory to SQL Table. In one column I can save the image whereas in another I want to save its respective name which is in the directory. The Tasks I used
SQLSERVER 2012
1.Foreach loop container -- To read the files
2.Script task --- to get the filename but I can''t.
I can successfully load the file in DB but I not getting its respective name...
also in my script task it not showing:-
REVERSE(String) Function
screen shot http://oi49.tinypic.com/2uhlufc.jpg[^]
http://tinypic.com/view.php?pic=sor7lu&s=6[^]

解决方案

If the problem is only that the intellisense does not show the reverse function in a script task, why not just try to write it. For the syntax, see REVERSE (SSIS Expression)[^]

Also since you have problems in finding the file, perhaps the following example would help you forward: Detecting an Empty Flat File with the Script Task[^]

Here is the perfect example for your request.
http://www.sqldts.com/304-2.aspx[^]

这篇关于如何在SSIS脚本任务中获取文件名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！