Am in process of building my custom component.Am trying to read values 开发者_运维技巧of PipleBuffer by
Am a newbie to to SSIS Custom Component.Just started to code a component where the input row count will never be same as output row count.foreach input row it does some validation and generates n rows
Is it possible setting a password f开发者_如何转开发or a ssis package just like we did for dts lagacy packages?I\'ve created a new ssis package but do not know how to set a password for it?Yes you can
I would like to know which one is the best approach for migrating existing DB data to another new DB with entirely different structure. I want to copy the data from my old DB and need to insert the da
i went to: menu > tools >options > fonts and colors > business intelligence design开发者_运维知识库ers...but nothing happened when i changed the font size.i\'m using visual studio 2008
I have a flat file source as SOURCE1~SOURCE2~SOURCE3 1~2~3 1~2~3 target is 1~2~3 1~2~3 which is normal case.
I\'m writing a SSRS report that is the direct result of a SSIS package. It is my understanding that SSIS must have exclusive access to Excel files for import. Is there any way around this?
I have created a SSIS 2008 Package which imports rows from a spreadsheet. I need to start on row 4 so I have used the OpenRowset property of the Excel connection manager.
I need to migrate the DTS (SQL 2000) package into SQL 2008 SSIS. The DTS packa开发者_开发问答ge is using HTML file data source and a Transformation task to import the HTML table
I Have the c# cod开发者_如何学运维e here. using Microsoft.SqlServer.Dts.Runtime; string filedts = \"C:\\\\SSIS\\\\SQLtoFLAT\\\\PQFormTEST2.dtsx\";