Question: I have just created a brand-new repository but can’t figure out how to create a transformation/package/report.
Answer: You need to create a transformation group first. Once a transformation group exists, right-click on it and select New to create a transformation.
Question: I opened an existing transformation but cannot change connection details. Server name and other details are disabled.
Answer: Locate the connection in the objects tree on the left-hand side and modify its details there.
Question: I am reading data from a blob field, but it appears empty.
Answer: Please refer to the following article for detailed guidance:
Blob Field is Empty
Question: When loading data into MS SQL Server, I get the error “Function sequence error.”
Answer: This issue is likely due to outdated SQL Server drivers. For a solution, consult this article:
Function Sequence Error
Question: I am reading data from MS SQL Server, but I get the error “Invalid Descriptor Index.”
Answer: For assistance, read the following article:
Invalid Descriptor Index
Question: I created a transformation/import and can execute it successfully, but it fails when run from a package.
Answer: Check out this article for troubleshooting tips:
Could Not Find Any Files to Read
Explore our extensive collection of YouTube videos! They’re available for you to watch and learn—designed to help you master our tools and processes. Dive in and make the most of these resources!
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum