I\'m trying to execute a remote (Driver package) that in turn executes an SSIS package. I am using the using Microsoft.SqlServer.Dts.Runtime namespace for this and the below code.
I am trying to create a f开发者_开发知识库ixed width flat file import spec in SSIS.When I set up all of the columns with the correct widths and preview them, the first row is correct but all of the ot
I have a DTS package with a XML configuration (.dtsconfig) file where i have some information that开发者_StackOverflow needs to be updated every time the package runs.
Hi Could you please let me give an idea how to read .OPC data: example for data in the file looks like: f1=1 | f2=2 | f3=3 | f4=4
I don\'t have too many experience with SSIS, and I would like some suggestions / advices. I need to implement a SSIS package for ETL, for migrationg firebird database to Sql Server.
I need to create a SSIS package and I would li开发者_开发知识库ke to know if I can use a WCF service as data source for it.
Could anyone please suggest how to achieve the following开发者_JAVA技巧? i.e. convert columns in to rows using either TSQL or SSIS:
I have a csv file.The format of csv file is something like this: [Asrcdt] [col1 col2 col3 col4 col5] [12345]
I\'m working with SSIS 2008 and am having a problem calling an Oracle stored procedure that has an output parameter.
I have an Excel sheet that has data with column headers (names).These column names that are in Excel exist as rows in one of my tables in the DB.What I need to do is to do a lookup on these Excel colu
加载中,请稍侯......