Running SSIS package problems

Galina Besselyanova
Galina Besselyanova used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> The SSIS Data Flow Task could not be created. Verify that DTSPipeline.dll is available and registered

As the error clearly mentions, DTSPipeline.dll file seems unregistered either via windows updates or some program uninstallation process.
Kindly try registering that dll file available in the below path to get it fixed..
Regsvr32.exe "C:\Program Files\Microsoft SQL Server\130\DTS\Binn\dtspipeline.dll"

Also try installing SP2 for SQL Server 2016 if not applied already..
https://www.microsoft.com/en-us/download/details.aspx?id=56836
larryhSr. Software Engineer

Commented:
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.
Galina BesselyanovaSenior Software Developer/Engineer

Author

Commented:
Applying SP2 solved the problem.
Thank You
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Welcome, glad to help..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial