This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later.
I am creating an extract SSIS package intended to take a text file as its source and to populate a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match.
I've adapted my real working product with an example. As my work was for a Personnel/HR project, and data confidentiality is somewhat important, some of the images will be censored or data changed in the example below.
I started getting this error:
- The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer
We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages and VS2010 for database solutions running against SQL Server 2008 R2. We can use VS2012 for both but this requires upgrading all the packages and then making them suitable for our new SQL Server 2012 instances.
This applies to a workstation (hopefully you're not doing development directly on the server). I re-installed sql server setup, re-ran the repair to no avail. A clue came from the MS site for an older version of the pipeline in that you access the SQL Server Configuration Manager. This may not be the fix for you but it was for me:
- Open Start > All Programs > SQL Server 2012 (or your latest)
- Expand "Configuration Tools" and open "Sql Server Configuration Mnaager".
- Right-click on "SQL Server Integration Services 10.0" and select "STOP".
- Right-click on "SQL Server (SQLEXPRESS)" and select "STOP".
This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component.
This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their documentation include it?
- Microsoft SQL Server Reporting Services 2012
- Microsoft Visual Studio 2012 Premium
- Microsoft Windows 7 Enterprise
So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if there is no date to populate the field.
At the moment, the expression in there is something like this:
- =Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy HH:mm:ss")
- -- yields 11/02/2014 11:21:32
This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day.
Take any SSRS report, if one of us was the first to run it on that day, it would take an additional 60 seconds to get with it and display the report. Any subsequent running of the report loaded it almost immediately.