SSIS access permissions are managed via Component Service under DCOM Config
1. Run –> dcomcnfg.exe or Component Services -> Computers -> My Computer -> DCOM Config -> MSDTSServer… 78 more words
I had to implement this today…
I have a script component in SSIS that could have exceptions that need to be handled gracefully, row-by-row, and logged as such. 7 more words
I recently had to migrate all my data migration infrastructure from SQL DMO to SSIS and ran into a peculiar issue.
My question and answer to the problem is detailed in this stack overflow post.
TimeXtender has been an integral tool for rapid ETL development and data warehouse automation. TimeXtender is a user friendly “point and click” tool that provides the basis for a BI solution, including data extraction, data validation, data transformation, and the building of data warehouses and OLAP cubes without the need for hard coding the SQL code. 848 more words
Before couple of days our BI team was facing an issue. One SSIS package was schedule to run every 1 minute but somehow it was taking more than a minute sometimes. 265 more words