Hi All, I have an SSIS question regarding looping through CSV files with the Foreach Loop Container. What I have: 1. A string variable named fName - Global 2. A Foreach Loop Container 2.1 User::fName mapped to the loop container with an index of 0 3. A Data Flow Task 3.1 a CSV Connection 3.2 (and this is where I'm lost) An Expression @[User::fName] but I don't know what to set the Property to for this. IF this was an Excel file I would ExcelFilePath Property but since it isn't I'm at a loss. Can anyone advise?

Member Avatar
Member Avatar
+0 forum 1

Hi All, With SSIS, upon load, I am receiving the following error: > Error 1 Error loading DownloadCSVPackage.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Projects\EconAnalysisStatsCan\EconAnalysisStatsCan\DownloadCSVPackage.dtsx 1 1 I have gone through all of my connections to find that bugger that has a "" for a connection name but cannot locate it. Can anyone suggest a way, perhaps through VB and BIDS, to find that bad connection and then delete it? I want to go live with this but cannot until I find and remove this …

Member Avatar
Member Avatar
+0 forum 3

Hi All, Something strange just happened. I just tried to open a package that I have been working on but nothing opens in Recent Projects on the Start Page in SSIS. The package title is also grey. I have no idea what happened or what I could have done to make it like that and I'm hoping to avoid calling IT to restore my pc to a backup point. See picture. ![Package](/attachments/small/3/Package.JPG "align-left") If anyone knows why this happened I would really appreciate it.

Member Avatar
Member Avatar
+0 forum 2

Hi all, With BIDS (Business Intelligence Development Studio)/SSIS, I have a process that downloads zipped CSV files. I store the files using the naming convention from the source ie 03260020-eng.csv. In a script task using BIDS, I would like to rename the file to exclude "-eng" but I'm not sure how to go about this. I have an idea to use a Right Trim but am unsure about the syntax. Can someone guide me with this?

Member Avatar
Member Avatar
+0 forum 8

Trying to import a flat file into SQL Server using SSIS. The file format is like this: [CODE] Image: C:\folder1\1234\5678.jpg ColHead1 ColHead2 ColHead3 Data1 Data2 Data3 [/CODE] I need a result that looks like this: [CODE] ColHead1|ColHead2|ColHead3|ColHead4 ----------------------------------- 5678 |Data1 |Data2 |Data3 [/CODE] So the idea is that we extract "5678" from the header portion of the flat file, and put it into the resulting SQL table. Any ideas?

Member Avatar
Member Avatar
+0 forum 17

I've created an SSIS package where I have an FTP Task inside a ForEach Loop container. I am trying to loop through each file in the particular folder and send it to the FTP site. I am sure that I got the For Each Loop working, as the error message references the first file in the folder. Here are all the error messages that came up while executing this task: <code> Error: 0xC0014054 at FTP: Failed to lock variable "C:\SCLFeed\Renamed Files\SBI-COST-FEED_04-21-2010_1019AM.sbi" for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made to …

Member Avatar
+0 forum 0

The End.