April 10, 2010 at 8:31 am
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
April 11, 2010 at 1:02 am
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
April 11, 2010 at 11:41 pm
thank u so much
April 21, 2011 at 1:26 am
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?
April 21, 2011 at 1:39 am
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://www.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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply