To | Do This |
---|---|
Set FastParse on a flat file source | Right-click the Flat File Source adapter and choose Show Advanced Editor. Use the Input and Output Properties tab to set properties for each of the compatible Output Columns. |
Enable FastLoad for an OLE DB destination | Open the connection manager properties and select the Advanced properties page. Set the AccessMode property to OpenRowset Using Fastload. |
Change DefaultBufferMaxRows and DefaultBufferSize | In the Control Flow pane, select a data flow that you want to set. Right-click and click Properties to open the Properties pane. In the Misc category, change DefaultBufferMaxRows and DefaultBufferSize. |
Add a log event to BufferSize Tuning | Select a package you want to log. Go to the SSIS menu in Visual Studio. Select Logging and add a new log as SSIS log provider for Windows Event Log. Select the new log you create, and then choose the package and data flow you want to log. On the Details tab, in the right window, select BufferSize Tuning. Click OK. On the View menu of Visual Studio, select Event Logs under Other Windows. |