home


SSIS Generic File Exporter 7 - Control Package
Author Nigel Rivett

Generic SSIS File Exporter 7 - Control Package


Objective

SSIS package to call the SP with a table name and file location and write the output to a file and run it.


Method
	Create a package DataExportControl.dtsx
	Tasks - dataflow task
		Source: Call SP s_CreateExportPackage for table SSIS_Test.dbo.ExportTest_c001c002
		Destination: Write the output to a file Export_SSIS_Test.dbo.ExportTest_c001c002
		Execute the created package


Downloads

SSIS package to call SP, create package from output then execute it

home