x

SSIS PACKAGE OUTPUT

Hi, I have SSIS package which has some out file path say "M",this SSIS package I use for production sql server.

Now I need to perform some testing on other sql test server...,I have changed output file path say "K" in the same SSIS package whic I was using in productin but when I run my test ... the output file is appearing on at path "M" and not "K". After I run my test on test server I am looking forward the output file on path "K"

Do I need to change the path anywhere else also?

rgds,
more ▼

asked Feb 10, 2011 at 08:04 AM in Default

pits gravatar image

pits
830 83 91 92

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
You should only have to change the file connection manager. If you are running the SSIS package within a job you will have to reimport the package to your SQL Server. If you are running it in BIDS then you should just have to change the file connection manager and test the package.
more ▼

answered Feb 10, 2011 at 08:14 AM

Tim gravatar image

Tim
36.4k 39 41 139

(comments are locked)
10|1200 characters needed characters left

Check for Package Configuration files. It doesn't matter what you change the file connection manager to, if there is a package config file it will revert to the saved connection on runtime.

If there are config files, you may have to tweak them for a dev and prod environment. Config files are a fantastic tool, but they can be dangerous if the are not handled properly.

more ▼

answered Feb 10, 2011 at 03:34 PM

Daniel Ross gravatar image

Daniel Ross
2.9k 11 13 14

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x946
x27
x18

asked: Feb 10, 2011 at 08:04 AM

Seen: 1767 times

Last Updated: Feb 10, 2011 at 08:05 AM