Thanks for all the help, I wrote a simple c# script task to pull the shared directories from the computer in question then looped through each directory and added to a collection object if it contained the criteria in its name.
I am attempting to loop through files in folders with the root of the name as tndlogs for example tndlogs, tndlogs0,
tndlogs1. The problem that I run into is that the SSIS expression language does not support wild card characters so
simply
using tndlogs* looks for a specific folder named...
Thanks Geoff,
Now my only road block is converting the text file below to show the columns as rows. I've been agonizing over pivot & unpivot but can't seem to get any data into my destination table is the column names. Any ideas suggestions?
"Metric 1", "Metric 2", "Metric 3", "Metric 4"
1, 2...
I am working on a package to simplify a task that has been running for several years. The current setup is one table that lists the database local to a division in our corporation, within these individual db's there is a table that lists the path for each flat file to be processed which relates...
Hello,
I am looking for an asp.net control to perform the following tasks
•wrap text when too long for the current cell
•auto size cell to wrapped contents
•display a popup comment similar to what is found in excel
•comments are user editable
•allow all comments to display when loading the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.