[ssis] Forum Topics

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 …

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 …

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 …

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 …

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 …

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 …