4 Solved Topics
Remove Filter
|
|
|
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, 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 …
|
The End.