SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Executing SSIS Package in 64-bit server


Executing SSIS Package in 64-bit server

Author
Message
CoThong
CoThong
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 Visits: 49
Hi,

I got the mentioned problem since a few weeks ago when I try to deploy the SSIS package into an SQL server of 64-bit. After a few weeks googling, I still couldn't find out the right way to get it solve, so I decided to post the question here and hope to get the solution from here.

The system looks like this:

Let’s say Server A represents Web Server and Server B represents the Sql server.

Web Site (deployed in Server A) -> Web Services (deployed in Server B) -> SSIS packages (deployed in Server B) -> Database (in Server B).

Web Site: User upload an excel file, which will be processed in the SSIS package later, through this web site. The details of the upload will then be passed to the web services for further action.

Web services: Call the SSIS package here along with the package variables.

SSIS package: Process the uploaded excel file and transform into another excel file.

Database: Refer to the data in database during SSIS package execution.

In Web services, I’m using the following way to call the SSIS package:

Imports Microsoft.SqlServer.Dts.Runtime

Dim package As Package
Dim app As New Application
Dim result As DTSExecResult

app.PackagePassword = "xxx"

Package = app.LoadPackage(packagePath, Nothing)
Package.Variables("A").Value = a
Package.Variables("B").Value = b
Package.Variables("C").Value = c
Package.Variables("D").Value = d
Package.Variables("E").Value = e
Package.Variables("F").Value = f
Package.Variables("G").Value = g
Package.Variables("H").Value = h
Package.Variables("I").Value = i
Package.Variables("J").Value = j
Package.Variables("K").Value = k
Package.Variables("L").Value = l

result = Package.Execute

I call it in this way as I will need the execution result, either success or fail, to pass back to the website as a status reporting.

I understand that I will need to call dtexec.exe from Program Files (x86) in order to run the SSIS package in 64-bit server, but may I know how can I do it with the above way?

Is the Microsfot.SqlServer.Dts.Runtime only applicable to 32-bit server?

If the above way cannot be used, what’s the alternative way should I use to get the same result?

Please advice.

Thanks.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search