Question : There are several blogs which claim to categorize SSIS Transforms into blocking (asynchronous), non-blocking(synchronous) and partially blocking(asynchronous). When […]
Tag: ssis-2012
SSIS and Excel import
Question : I am using VS2012 and creating a package on a 64bit machine to import some data from a […]
How to identify where a package execution has spent most of the time?
Question : Team BI has a package deployed as a project on SQL Server 2012. How can I find how […]
SQL Server Integration Services 2012 – Legacy deployment
Question : I’m currently reading a lot about SSIS and I have read that there are now two models for […]
VARCHAR2 should perhaps be DT_WSTR when working with SSIS against a Oracle Database?
Question : When using SSIS with Oracle database, it seems to always assume that a VARCHAR2 maps to a DT_STR. […]
Problem creating a transaction in an SSIS package
Question : I’m working on a package that needs to use a transaction but I’m currently getting the following error: […]
Verify if user has read access to a table
Question : I’m developing an ETL, whose extract step must read data from a table. There are times that my […]
SSIS Package fails to “Transform File and create output file”
Question : I have an SSIS (2012) package which was written by one of the developers. I’ve been tasked to […]
dtexec returns immediately without any messages
Question : I’m trying to setup a command-line call to dtexec to validate packages, using the project model. I’m calling […]
VS 2012 SSIS Data Flow Designer Source Assistant Error: [SSIS.Pipeline]: Component “, clsid {4CAC … Could not be created
Question : I am creating my first SSIS package to support the E of our ETL from an external Oracle […]