Tag: ssis

SSIS Redeployment

I finally got my SSIS package deployed to our SQL 2005 server, and I can run it from my ASP.NET 2.0 code. I needed to change my package after I first set it up. I double-clicked the .manifest file and deployed the package to the same server, but the job is never updated. It stays […]

DDD Value Object: How to persist entity objects without tons of SQL joins?

Obviously I am wrong in saying that DDD is similar to EAV/CR in usefulness, but the only difference I see so far is physical tables build for each entity with lots of joins rather than three tables and lots of joins. This must be due to my lack of DDD understanding. How do you physically […]

Execute SQL Server 7 DTS on SQL Server 2008

I believe its possible to run SQL 2000 DTS packages on 2008 with a compatability layer. But is it possible to do the same with DTS packages created on SQL 7? Is there any MS KB or note that points out if this is even a possibility.

SSIS package – loop through different connections for Execute SQL task

I am creating an MSSQL2008 SSIS package to generate and email reports from database tables. It works perfectly on a single database. The client is running 3 different databases used by 3 different divisions. The database structure is exactly the same. All three databases are located on the same server, same security / credentials are […]

AcquireConnection method call to the connection manager <Excel Connection Manager> failed with error code 0xC0202009

I have an SSIS package which reads an Excel File (Data Flow Source) and transfer the data to SQL Server using OLEDB Destination Data Flow Item. The OLEDB Connection Manager used for the destination is configured to use Windows Authentication. The package works fine on my development machine. But when I open the same package […]

Extracting 6-8 digit dates from alphanumeric fields

Screenshot explains it all. http://i46.tinypic.com/f3hobl.png With the current configuration, InvoiceSentDate only accepts 8-digit dates (MM-DD-YY). I want to be able to capture MM-DD-YYYY dates as well. How do I do this? For comparison, look at invoice 2106-2112 vs 2116. FURTHERMORE, to complicate things! Some records have text after the date. http://i50.tinypic.com/2r5qa88.png

Understanding Stored Packages on Integration Services

We have several SSIS packages (in a solution) saved in a directory on the server. The packages are run via a SQL Server Agent job, with ‘File system’ as the Package source. Packages are not in any way added to ‘Integration Services’ (the thing you can connect with through the “Connect” button in SSMS). This […]

SSDT-BI SSIS in x64?

I run Visual Studio 2012 and I’m new to SSIS. I attempted to install SSDT-BI (June 2013 version) in order to research SSIS, but I was unable to complete the install with my default instance because the architectures don’t match–my server is x64 while the installer is x86. There doesn’t appear to be an x64 […]

'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data) It is not the same version I think some other patching is needed

SSIS Excel Connection Manager failed to Connect to the Source

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that server. The problem happens when trying to design the package. I have added an […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.