How to run an Import/Export package on computer

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to run an Import/Export package on computer

Author

Topic

GaryNull
Starting Member

14 Posts

Posted - 2014-05-08 : 19:34:11

I created a package from the SQL Server Import and Export Wizard.

I can run this .dtsx file " Import_Table.dtsx " on my local machine no problem,
which then executes the package on the remote server of my hosting company.

But I need someone else to run this on their computer.

Do they need to install SQL Server on their machine for it to work?
Is there some files they can download to make it work?
Thank you

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-08 : 19:43:24

Try this: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/97ee7a9e-47d3-4894-ba0f-d978ff22fe5c/installation-requirements-to-run-ssis-package-on-a-server?forum=sqlintegrationservices

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-05-09 : 05:17:10

They would need Integration services service for running the package so they would have to install sql server in their computer for that

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

GaryNull
Starting Member

14 Posts

Posted - 2014-05-28 : 14:22:05

Import/Export wizard was used to create an SSIS package. I click on this file to run it : Import_Table.dtsx
It runs on my machine (Win7 64 bit) no problem.

SQL Server was installed on someone else's machine because I needed someone else to run the Import_Table.dtsx file.
When the file is run on that machine, it returns this error :

"The AcquireConnection method call to the connection manager failed"

After searching for solutions, I found a few that sound like this :
"This can be solved by changing the prorperty of the project in the solution explorer then give "false" to 64bit runtime option"

But I created the file "Import_Table.dtsx" using the Export Wizard and did not "directly" create a "package" or project.
I don't know how to access the package or project. Any ideas on how to fix this problem? thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources