August 19, 2010 at 9:07 am
Hi everyone,
I am new to SSIS systems. Can any one please give me step by step how to deploy a newly created package in to a project existing in the production server already.
The packages are stored in the filesystem.
Please..
August 19, 2010 at 9:47 am
sql_freak (8/19/2010)
I am new to SSIS systems. Can any one please give me step by step how to deploy a newly created package in to a project existing in the production server already.
As a rule of thumbs nothing beats the vendor's documentation, in this particular case Microsoft documentation.
Did you check http://msdn.microsoft.com/en-us/library/ms140117.aspx?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 21, 2011 at 1:23 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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply