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