Our project uses AcuCorp\'s AcuODBC driver to access a legacy Vision database.The problem is that we only have a 32-bit driver and the installer simply won\'t run on our 64-bit servers.I need a way to
I\'m pretty familiar with SSIS parsing of regular delimited text data files, however, I\'m looking for some advice on an approach to tackle a file that looks like this test file:
I\'m starting to get involved in quite a bit of ETL work a my current job, and everyone seems to be pretty partial to SSIS.I\'m struggling trying to do the most trivial transformations through BI stud
I have an SSIS Package that needs to load data through an oledb component into a table whose name is not known until runtime. In the oledb destination editor I have selected \"Data access mode\" as \"
I\'ve hit the in开发者_开发技巧evitable state where I have to do a diff on the code within two versions of a SSIS package.
I am using this in Script Component In SSIS--> Microsoft.Office.Interop.Excel.Application objXL = new Microsoft.Office.Interop.Excel.Application();
I\'m using dtsx in data migration between t开发者_如何学JAVAwo SQL Server instance. One of the table changed the schema by adding a new text field which is not nullable. How can I add defualt value fo
I have a SSIS package which reads an Excel File (Data Flow Source) and transfer the data to SQL Server using OLEDB Destination Data Flow Item.This package is executed by .Net Application using the SSI
I am using SSIS on SQL Server 2005, VS 2005 SP2. I have created an XSLT to convert XML to CSV format. When I run this through XML Spy it works fine. I have configured an XML Task within and SSIS pack
Please read Update1 first! This is SSIS specific question. I have the following tasks: I need to periodically move data from table A in MySQL to Table B in MsSQL.
加载中,请稍侯......