I\'m currently attemping to display the progress of an SSIS package that\'s running on the server by implementing a callback in WCF. This is working to a point; basically the OperationContext.Current
I have an ssis package that uses excel files. I am using the Run As with an admin account. when I call it from a batch file it runs fine
I am moving data into a DW using SQL Server SSIS and have the following SQL to populate one dimension
I\'ve managed to connect my SQL Server 2005 in Windows 64 bit server with ORACLE database. (Thanks to Mr.开发者_开发问答 Jeyong Park :http://knol.google.com/k/jeyong-park/accessing-oracle-data-source-
I have a server that has a SQL Agent j开发者_运维问答ob setup to run a two part datawarehouse build and Analysis Services cube build. The job ran successfully until there was a problem with Management
In SSIS 2008, the ability to reference other class libraries has been added. Is there anyway to resolve the references to a non-GAC location when deployed to a non-developer environment? For instance,
We have multi GB files coming every day to be loaded to SQL Server 2005 instance via SSIS packages. To load those large data files to SQL Server asynchronously, we built multi threaded .NET applicatio
Is there a way to map to the same input column to multiple parameters in the OLEDB Command object, or to multipl开发者_Python百科e destination columns in the OLE Destination object?
Within SSIS 2005 I used the Import/Export wizard to create a package that drops/recreates and replaces the data on some tables between my production server and developm开发者_StackOverflow社区ent mach
I\'m getting this error when running an SSIS package through SQL Agent Failed to acquire connection \"ORACLE ADO.NET\". Connection may not be configured correctly or you may not have the right permiss