How To
How to know if a column is missing in my excel file when using Excel Source Plus component?
If a column is missing in your excel file when using the Excel Source Plus component, your SSIS+ package will execute successfully, but we generate generate a warning message in the package event log. Please look at the screenshot below:After modifying the default Data Types in an ETL source, my modifications are lost the next time I open the Source component
If you need to modify the data types or lengths for any source columns or fields, use the Advanced editor for the component and only make changes to the Output columns. Do not make changes to the External columns. If you make changes to both the ...How can I dynamically modify the Excel source filename and worksheet name at runtime?
Watch this video showing how to dynamically modify the Excel source filename and worksheet name at runtime. The same technique can be used for the Excel destination filename and worksheet name.Excel Source Plus: How to modify the source region dynamically at runtime
The source region is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired region. The variable should be a string and the order should be: start column, start ...Excel Source Plus: How to modify the worksheet name dynamically at runtime
The source worksheet name is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired worksheet name. Right-click on the data flow canvas and select ...
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Popular Articles
How To verify Microsoft Integration Services is installed on SQL Server
SQL Server Integration Services (SSIS) is a component of SQL Server and can be installed with or without SQL Server. The same SQL Server setup can be used to install Integration Services on the server that SQL Server is installed on. SSIS is a ...FLEE Expressions for filtering
FLEE expressions are used to define criteria for filter parameters in several COZYROC tasks and components. FLEE is a “Fast, Lightweight Expression Evaluator.” Finding documentation to help you configure a valid expression can be challenging. The ...I see a response returned from the web service, but the preview in REST Source does not show any data.
CozyRoc Rest Source Component allow you to Read data from REST API. Developer can quickly extract response data from desire endpoint using HTTP Method (GET, POST) and Output into column data. In this article we will walk through some examples that ...How long is the grace period after the subscription has expired?
We noticed that our license is going to expire soon and we are in the process of renewing the license and it might take couple of days. We are wondering if you can provide a solution to use your product in our production system temporarily without ...How to resolve File Transfer Task failing when no files exist.
This KB article is not relevant if you are using "Get Remote Files List" action on File Transfer Task. Instead, you can use this COZYROC prepared Javascript: https://www.cozyroc.com/ssis/script-ftp-file-exists-task If you are not sure there will be ...