August 20, 2008 at 5:11 am
I have created SSIS package and now I want to deploy it at client site what should be the steps.
What are the supporting files needed .
Note : Client don' have full BIDS envrn. but only sql server
Please help
August 20, 2008 at 5:16 am
You need to configure your package.
You can use Package Configuration Organizer for this.
Later on, you can use config file to change your connection variables.
August 20, 2008 at 6:04 am
Thanks Dear
Can u describe a procedure in short plz....
August 20, 2008 at 11:41 am
On the SSIS (BIDS top Menu item), you can find 'Package Configuration'. You can add config files here. Personally i go with XML files for configuration, there are other options too that you can use. The following article gives you complete step by step demo of how to do this
http://www.mssqltips.com/tip.asp?tip=1434
This is also a good overview of how to create deployment utility http://msdn.microsoft.com/en-us/library/ms137900.aspx
HTH
Mukti
April 21, 2011 at 1:11 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:38 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#bm1096796
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