Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cfry813
Starting Member
2 Posts |
 Posted - 2009-05-08 : 11:18:50
|
| I am new to SSIS but have used DTS. The NT guys will not give us permissions on the server to create the SSIS directly on our test server. When I create a package on my machine I need to be able to 'move' it to the test server and schedule as a sql server agent job. Then I need to move it to the prod server and schedule. What is the best way to achieve this? My file paths are the same for the test server and the prod server, but the oledb connection will change.I have read the microsoft solution of using system variables but I am not able to create these variables on the test server.Help please! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
SSIS package deployment