ssis

Question

ssis

srik780

Mr or Mrs. 500

Points: 585
More actions
April 10, 2010 at 8:31 am

#213635

1)how to deployee a package other than deployment utility in ssis
2)can we deployee a package using SSMS
April 10, 2010 at 9:04 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

JDixon-385826 SSCrazy Points: 2723 More actions · Answer 1

looks like a duplicate post from 2005 - but same applies - I would save the packages to the file system and just copy them for deployment. You can easily still schedule and call the package. Just make sure you back it up or script to a source server

srik780 Mr or Mrs. 500 Points: 585 More actions · Answer 2

srik780

Mr or Mrs. 500

Points: 585

April 11, 2010 at 11:41 pm

#1149815

thank u so much

mgbp SSC Enthusiast Points: 177 More actions · Answer 3

Hi,

Please help me with the scenarios below:

A-Server contains:

1. SSIS Package (dtsx)

2. textfiles to be imported in Database (of B-Server).

3. SSIS Component installed ONLY (no BIDS, no SQLServer-engine)

B-Server

1. SQL Server -engine (with target database).

2. WITHOUT SSIS Component installed.

--------------------------------------

I need to manually execute the .dtsx in A-Server using DTEXEC.exe in the command line.

This dtsx will import/convert the textfile to the database located in B-Server.

Both servers are in 64-bit.

Is it possible with the given situation above? What are the other requirements/components needed?

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 4

mgbp (4/21/2011)
Hi,
Please help me with the scenarios below:
A-Server contains:
1. SSIS Package (dtsx)
2. textfiles to be imported in Database (of B-Server).
3. SSIS Component installed ONLY (no BIDS, no SQLServer-engine)
B-Server
1. SQL Server -engine (with target database).
2. WITHOUT SSIS Component installed.
--------------------------------------
I need to manually execute the .dtsx in A-Server using DTEXEC.exe in the command line.
This dtsx will import/convert the textfile to the database located in B-Server.
Both servers are in 64-bit.
Is it possible with the given situation above? What are the other requirements/components needed?

Same remark as in this topic:

http://qa.sqlservercentral.com/Forums/Topic865414-148-2.aspx

Crossposting shatters replies and wastes peoples time.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP