Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SSIS Problem

  
   Database Forums (Home) -> Tools RSS
Next:  Unsigned Data Types  
Author Message
j0hnj0hn

External


Since: Feb 11, 2009
Posts: 2



(Msg. 1) Posted: Wed Feb 11, 2009 11:29 am
Post subject: SSIS Problem
Archived from groups: microsoft>public>sqlserver>tools (more info?)
I think this is due to my lack of understanding, but I need help. I have
created an SSIS package that will export the rows from a view to a text file
across the network. When I execute the package in the Execute Package
Utility the package runs as expected exporting the file to the network file.
However, when I run this package under the SQL Server agent (the step
executes the SSIS package saved on the local file system) I get the error
cannot write to DestinationConnectionFlatFile [file name]. I set my account
to the Server Agent service and restarted it with the same luck. Am I
missing something the SQL Server Agent needs to execute this package?

 >> Stay informed about: SSIS Problem 
Back to top
Login to vote
Marcelo Vollbrecht

External


Since: Feb 12, 2009
Posts: 1



(Msg. 2) Posted: Thu Feb 12, 2009 7:19 pm
Post subject: RE: SSIS Problem [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"j0hnj0hn" wrote:

> I think this is due to my lack of understanding, but I need help. I have
> created an SSIS package that will export the rows from a view to a text file
> across the network. When I execute the package in the Execute Package
> Utility the package runs as expected exporting the file to the network file.
> However, when I run this package under the SQL Server agent (the step
> executes the SSIS package saved on the local file system) I get the error
> cannot write to DestinationConnectionFlatFile [file name]. I set my account
> to the Server Agent service and restarted it with the same luck. Am I
> missing something the SQL Server Agent needs to execute this package?

 >> Stay informed about: SSIS Problem 
Back to top
Login to vote
Marcelo Vollbrecht

External


Since: Feb 12, 2009
Posts: 1



(Msg. 3) Posted: Thu Feb 12, 2009 7:22 pm
Post subject: RE: SSIS Problem [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi There.

Just check if you are trying to save this file in a location that your
server can actually see.

if your file destination is : c:\ExportFiles\File002003.txt for example,
this folder c:\exportfiles needs to be there.

if so, please let us know.
 >> Stay informed about: SSIS Problem 
Back to top
Login to vote
John

External


Since: Oct 08, 2008
Posts: 2



(Msg. 4) Posted: Mon Feb 16, 2009 9:23 am
Post subject: Re: SSIS Problem [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Feb 12, 8:22 pm, Marcelo Vollbrecht
wrote:
> Hi There.
>
> Just check if you are trying to save this file in a location that your
> server can actually see.
>
> if your file destination is :  c:\ExportFiles\File002003.txt for example,
> this folder c:\exportfiles needs to be there.
>
> if so, please let us know.

The file exists and SSIS will export if I run it from the Execution
Package Utility without a problem. It is not an error that it can't
find the file, it can't open the file to write to it, so the file is
there.

John
 >> Stay informed about: SSIS Problem 
Back to top
Login to vote
Pat M - City of Reno

External


Since: Feb 24, 2009
Posts: 1



(Msg. 5) Posted: Tue Feb 24, 2009 4:25 pm
Post subject: RE: SSIS Problem [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I had the same problem except doing backups to a different server. You have
to run the SQL Server Agent under a Domain Admin account so you have access
to the drives under the service. If SQL Agent is running under Local Account
it won't work. Hope this helps.
Pat


"j0hnj0hn" wrote:

> I think this is due to my lack of understanding, but I need help. I have
> created an SSIS package that will export the rows from a view to a text file
> across the network. When I execute the package in the Execute Package
> Utility the package runs as expected exporting the file to the network file.
> However, when I run this package under the SQL Server agent (the step
> executes the SSIS package saved on the local file system) I get the error
> cannot write to DestinationConnectionFlatFile [file name]. I set my account
> to the Server Agent service and restarted it with the same luck. Am I
> missing something the SQL Server Agent needs to execute this package?
 >> Stay informed about: SSIS Problem 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SSIS Designer Slow - I am desigining an SSIS package and the designer is painfully slow does anyone else have this issue?

SSIS Designer Location - Hello... Where can I find the SSIS Designer? I need to create a DTS... Thanks..!

SSIS connecting to SQL Server 7 - Is there any reason why an SSIS package can't be used to connect to an SQL Server 7 database and extract data from it? Phil Hibbs.

BCP Problem - Please Help !! - When I try to bcp out data from a table with text columns, the following error prompted : Starting copy... SQLState = S1001, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Memory allocation failure Most grateful if anyone can provide help...

bcp accent problem - Hello, I'm importing data from formatted text files with accent (Latin1). My database is set to French_CI_AS. I use bcp with -C"Latin1" or -C"French_CI_AS" but bcp seems to ignore the flag and every single accent is left behind. ...
   Database Forums (Home) -> Tools All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]