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 |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2008-12-26 : 12:19:28
|
| sir i have creted one SSIS Package in which my source is sqlserver and Destibation is Flat file .my issue is i want to save my destination FLAT file on another server .How can i do this .pls help me out .Yaman |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-26 : 16:51:24
|
| You can use UNC path (\\Servername\drive$\Folder\Flatfile.txt) in Destination Location. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-27 : 11:35:35
|
| and make sure folder exists and you or account running package has access to it. |
|
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-12-31 : 07:52:56
|
quote:
Originally posted by sodeep
You can use UNC path (\\Servername\drive$\Folder\Flatfile.txt) in Destination Location.
If server have a username & Passwordhow set user name & password before set UNC PathYaman |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-31 : 08:03:23
|
quote:
Originally posted by yaman
quote:
Originally posted by sodeep
You can use UNC path (\\Servername\drive$\Folder\Flatfile.txt) in Destination Location.
If server have a username & Passwordhow set user name & password before set UNC PathYaman
does that mean account running ssis does not have access to server? |
|
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-12-31 : 08:45:58
|
quote:
Originally posted by visakh16
quote:
Originally posted by yaman
quote:
Originally posted by sodeep
You can use UNC path (\\Servername\drive$\Folder\Flatfile.txt) in Destination Location.
If server have a username & Passwordhow set user name & password before set UNC PathYaman
does that mean account running ssis does not have access to server?
I have USername & password But I want to set dynamically user name password & username with Flat file pathYaman |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-31 : 08:49:08
|
| why do you want an extra authentication? by default, isn't it enough to give account running package permission to folder path? |
|
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-12-31 : 10:41:59
|
quote:
Originally posted by visakh16
why do you want an extra authentication? by default, isn't it enough to give account running package permission to folder path?
Actually I want to store My OutPut Flat File in Dynamically On Another Location of another server.& every server have USername & password .My flat File is saved if i already logged in .when i am restart my computer then SSIS Package create problemPath of flat file :- set at run time ( read from XML file ) .Yaman |
|
|
|
|
|
|
how to Save SSIS FLAT FILE