Galina Besselyanova
asked on
Running SSIS package problems
Good morning,
I am having a problem running SSIS package in SQL 2016. I can create and run it in separate Import/Export Data utilities, but when I execute it in SQL itself I am getting an error message "Parser NULL". I also can not run the Import/Export wizard withing the SQL database engine. I am getting an error: "The SSIS Data Flow Task could not be created. Verify that DTSPipeline.dll is available and registered."
Please advise. THanks
I am having a problem running SSIS package in SQL 2016. I can create and run it in separate Import/Export Data utilities, but when I execute it in SQL itself I am getting an error message "Parser NULL". I also can not run the Import/Export wizard withing the SQL database engine. I am getting an error: "The SSIS Data Flow Task could not be created. Verify that DTSPipeline.dll is available and registered."
Please advise. THanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If I understand correctly, when you run a task yourself you are running using your local computer resources (DLL files, etc.). When you run it in SQL you are using the server's resources (DLL files, etc.). It sounds like maybe your local computer has the properly registered DLL while the SQL server does not. I am assuming that the SQL instance you are connecting to is a separate machine. It could also be the difference between a 32-bit vs a 64-bit program.
ASKER
Applying SP2 solved the problem.
Thank You
Thank You
Welcome, glad to help..