Tag: ssis

Sql Server 2005 SSIS/Agent – Query status of a job

Is there a way to query the current status (executing, idle, etc) and the last result (successfull, failed, etc), and the last run time for a specific job name? The end result I am looking for is being able to display this information in an internal web application for various SSIS packages.

get ssis package output from SP

I have a SP that runs a SSIS package. xp_cmdshell ‘dtexec /f “F:\SSIS Package\test.dtsx” /Rep E’ When I run the SP in VS I get an Output window where I can see if it was successful. Is there a way to get the output from this into my asp.net application ?

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 […]

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