We help IT Professionals succeed at work.

Running SSIS package problems

479 Views
Last Modified: 2018-07-25
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

SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
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
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Welcome, glad to help..
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.