Using SSIS to Capture the File Name

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by J.D. Gonzalez » Using SSIS to Capture the File Name

15 posts, Page 2 of 2

««1 2

Using SSIS to Capture the File Name

Rate Topic

Display Mode

Topic Options

Author

Message

pittsburghcodemonkey

Posted Tuesday, January 05, 2010 2:58 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:54 AM
Points: 2, Visits: 51

I was able to get this to execute locally through business intelligence development studio but when I was scheduling this on our SQL server the job kept on failing.

After looking at the script provided in the article where it states:

"Dts.Variables("fileName").Value = System.IO.Path.GetFileName(Dts.Variables("fileName").Value.ToString())"

In order to get this to work on the server I simply had to remove the "System.IO.Path.GetFileName" leaving me with:

"Dts.Variables("fileName").Value = (Dts.Variables("fileName").Value.ToString())"

After making that change I was able to sucessfully use this SSIS package from the server.

Post #842447

lk-681111

Posted Friday, June 11, 2010 2:30 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 03, 2011 7:31 AM
Points: 91, Visits: 423

I know this is months late, but I just wanted to say how incredibly helpful this was to me. It's really hard to find actual step-by-step instructions for this sort of thing rather than bits and pieces here and there. Thanks!

Post #936303

SSIS Crazy

Posted Friday, March 18, 2011 12:04 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 01, 2013 8:19 PM
Points: 48, Visits: 87

Has anyone tried the sample project in Sql server 2008? It seems I have too many issues getting it to work. Just wondering if the file system task has to be connected or just have to be left in the foreach loop container?

Any kind of help is appreciated.

Thanks

Post #1080611

Debra True

Posted Monday, March 05, 2012 8:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, August 20, 2012 3:30 PM
Points: 2, Visits: 13

I followed these instructions to a T and as long as I specify a specific file name for the flat file connection, it will succesfully go through all of the remaining files. My problem is that this needs to be an automated task to pick up all files under the specified subdirectory with *.csv extensions. When I try to run this loop again with differently named *.csv files, it fails and says that it cannot find the filename xxxxx.csv which was originally specified in the flat file connection. I am not totally new to SSIS, but haven't used this type of structure before. Also, my scripting skills are next to zero. Please help.

Post #1261611

ahz

Posted Wednesday, April 25, 2012 2:58 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 16, 2012 8:39 AM
Points: 1, Visits: 15

OK SO i GOT THE @[User::fileName] but in the Derviced column transformation editor I want it to change it to only grab the name of the file and NOT include the '.txt'.. so each file is only 5 characters long from position one... how to cut it only pick up first 5 characters from fileName

Post #1290280

« Prev Topic | Next Topic »

15 posts, Page 2 of 2

««1 2

Permissions