From SQL Server 2005, I n开发者_C百科eed to do an export for a client to an xml-like format shown below. Why they are not using XML, I don\'t know. Any ideas on how to do this quickly without exportin
Is it possible to log the events of ssis package execution called from c# Application ap开发者_如何转开发p = new Application();
I am in process of creating an ssis package that need to do following in specified order: process some data
Hi I am trying to connect Oracle 10g(Source/Target) from ssis using connection string as Data Source=Qrgo;User ID=sy;password=sa;Provider=MSDAORA.1;
I have written a task script using vb.net that have thre开发者_高级运维ad used in the code, the problem is how i can know when will be finished all the threads so i can return the success result.
I\'m trying to execute a SSIS package on a SQL Server 2008R2. The script retrieve data on a remote server and copy them to its local database.
I am using SSIS to grab the results from 2 Views in a SQL Server database, union them (with appropriate mapping), filter them and place them into an Access database.
I have a job created to run a SSIS package.I had problems with package security for a while, but managed to set the package password correctly and that error disappeared.This next error was not occurr
I have 700k-1M rows coming in with a comma delimited field (among others). I need to keep this column intact, but sort the rows so that I can determine duplicates. In this business case, a,3,null,40 i
The debugging experience in SSIS is not what I am expecting. I have a script Task that I have added a Imports System.Diagnostics at the header of the class, and in the code I have various debug.write