Reading File's Path from a Variable.

Question

Reading File's Path from a Variable.

falcon00

SSC Veteran

Points: 241
More actions
December 20, 2011 at 3:08 pm

#149775

Please assist me in the following issue.
I have a package that I have deployed on a remote server. The package has a User-defined variable that stores the File Path for a file. For example: "C:\Test
When I execute the package on the server using Run Package option, it is still looking for "C:\Test" directory on my local computer and not the server itself. The server does have this directory on the C: drive.
Please explain what configurations should be adjusted so that the package will no longer point to my local machine.
Thank you!

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Do you have a package definition pointing it to your machine?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

falcon00 (12/20/2011)
Please explain what configurations should be adjusted so that the package will no longer point to my local machine.

How should we knkow which configurations to adjust, if you do not explain us which configurations you have?

Do you an XML config file, a SQL Server config table? Or why not a parent package configuration, an environment variable or a registry config?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

falcon00 SSC Veteran Points: 241 More actions · Answer 3

All I am asking is how to make the Package read the directory on a server and not my local machine when being executed. I don't know what configuration I have and where to look for it.

I was asking in general, is there any configuration that will solve that problem or is there something else that needs to be done.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

There is not unless you created the package config or created a variable for the machine name.

If you did not create that, then when you run the package on a different machine it will look in the directory you assigned in the variable. If it is still trying to connect to your machine, then you have created a config or variable for it.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

falcon00 SSC Veteran Points: 241 More actions · Answer 5

I did not create a config for it.

All the variables I have have the scope of the package that runs it.

falcon00 SSC Veteran Points: 241 More actions · Answer 6

I think I got an answer to a similar question.

Thanks for your help anyway.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

falcon00 (12/21/2011)
I think I got an answer to a similar question.
Thanks for your help anyway.

If you do not have implemented package configurations, your SSIS package will still use the values for the variables that you defined during design time. In order to change those values at runtime at the server, you need to implement package configurations:

http://msdn.microsoft.com/en-us/library/cc895212.aspx

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP