I\'m learning SSIS and this seems like an easy task but I\'m stuck. I have a CSV file Orders.csv with this data:
I\'m trying to move data from an Oracle (10g) database to SQL-Server (2008).I also want the indexes to be re-created on the SQL-Server side.However, in Oracle, there is a primary key defined on the fi
In SSIS how do I, 1) Pass a variable to the dtsx package. 2) How to us开发者_运维知识库e that variable to control branching to a particular data flow task.
I am using SQL Server 2005 SSIS and we are using the Data Flow Task to move 开发者_Go百科data from one table to another. This works well. Now we have another requirement to do data update from the sam
I went for a job interview this morning, and one of the scenarios that the IT manager (a former programmer) told me about was the following .... If anyone could give me any pointers that I can email h
I was developing a SSIS project, but accidentaly, I erased it. However I keep a copy of the SSIS package. So my question is, it is posible recover the project using the package? or is someway to re开发
I\'m getting started with building a Business Intelligence system using MS technologies. I don\'t have any experience with Integration Services or with Analysis Services, so the learning curve is pret
I am calling an SSIS package remotely using a stored procedure and a call to xp_cmdshell: declare @cmd varchar(5000)
I have this URL where there is XML data. I have to extract that data from URL and dump it into DW table. I am using SSIS Script Task for that.
I\'m working on an ssis package to fix some data from a table.The table looks something like this: CustID FieldID INT_VAL DEC_VAL VARCHAR_VAL DATE_VAL
加载中,请稍侯......