Essentially, this can be done using the file system IO libraries using script task either using VB.NET or C#.NET. Using the library (System.File.IO) this library exposes set of API's for...

Elizabeth.Block (6/30/2015)

---

Ah, that's it. I'm having trouble getting the syntax right for this. I created a temp table for the catalog names and then tried to get the last processed...

Please read about:

1. Degenerate dimensions

2. Junk dimensions

3. MDX Subcube (or sub query)

Quick and dirty way

Create a new computed calculated column in your fact table based on the condition you have specified. Now create any new measure based on the newly created...

In such cases, you will have to create a set of connection manager's (one for each type of source file).

You can automate the different OLAP processing tasks using SSIS which is the answer to your question on what tool can be used.

If the content that you are writing in the text file does not require tabular representation or any indentation, you can use a SSIS variable to store the final resultset...

Hope this answer's your question:

Click Here[/url]

Hi Gajendra,

What kind of process do you wish to run with JSON (JSON like) files. The file system watcher will trigger the workflow when there is a file available at...

Hi Gajendra,

You can setup a script task to watch the source directory for new files. This is a common use case for a FileSystemWatcher which can be programmed to poll...

Use a script task. Iterate over the variables and write the relevant information in a file.

What happens to the files which are already downloaded and processed? Can you describe the workflow? This will enable the folks to answer the problem

There are several methods to achieve this:

Most basic:

have a file archive mechanism in place, once you have processed the file, move the file to an alternate location so that...

unnati.patel513 (4/10/2014)

---

Hi,

I need help in checking the file name before i load it to staging tables.

I have all the file stored in C:\Database\SourceFiles\ABCSourceFiles

and file name like ABC_YYYYMMDDHHMMSS

Example

SourceFile1_20140803073209.txt

SourceFile2_20130904071210.txt

SourceFile3_20120703041530.txt

For i took foreach...

Why not use a staging area to load 4 tables and later use a union to create one table