How To Get Files name in SSIS script task

Question

0.00/5 (No votes)

See more:

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[^]

Posted 11-Jan-13 5:56am

Raju9959

Updated 11-Jan-13 6:32am

v3

Add a Solution

Comments

Wendelius 11-Jan-13 11:59am

Can you post the content of the script task.

Raju9959 11-Jan-13 12:03pm

i have idea how to get file names but the thing is in script task it not showing REVERSE string function except that it shows Substring,Replace,Find and all other functions..

2 solutions

Solution 2

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

Posted 12-Jan-13 19:23pm

cocis48

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2013-01-11T06:13:00

Solution 1

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[^]

Posted 11-Jan-13 6:13am

Wendelius

Comments

Raju9959 11-Jan-13 12:36pm

i also checked that it shows error which is in screen shot..that simple thing make me headache...

Wendelius 11-Jan-13 13:06pm

If you're using SSIS that way, could you simply try:
string rev = string.Concat(text.Reverse().ToArray());

Don't forget to define

using System.Linq;

Raju9959 11-Jan-13 14:47pm

yes yes thanks allot for the solution...
Is any other methods to get that reverse function result. If there just teach me..another question
eg
string name="sql-rocks-in-db";
string output="sql"---i want this as o/p
in this case i wanna use first - symbol to get its position to use in substring(function)

Wendelius 11-Jan-13 15:08pm

I would say this can be done in multiple ways...

To get the first occurrence of a character like -, have a look at IndexOf[^]