Schedule SSIS Package that place file to outside of Network Domain

Question

Schedule SSIS Package that place file to outside of Network Domain

yogi123

SSCrazy

Points: 2932
More actions
May 5, 2016 at 8:44 am

#326899

Hello
I have one task where i need to source data from database server which is on XXX network domain, and need to place Flat file on share directory which on YYY network domain. I worked with Network Administrator and assign me and Service user Account a Administrator level access to the share directory on YYY Network domain. I created SSIS Package on BIDS and ran successfully from BIDS but when i try to automate the SSIS Package through SQL Jobs, it failed. The SQL jobs runs under service account and i check the service account has same privileges as i do. but i got error as below,
Package Connection manager "Flat File Connection Manager" Description: The file name property is not valid. The file name is a device or contains invalid characters. End Error DTExec: The package execution returned DTSER_FAILURE (1).

i don't know why its happening, when i run through BIDS runs well but failled through SQL Jobs.
Please help / advice me how to troubleshoot this.
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

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

Thom A SSC Guru Points: 99128 More actions · Answer 1

Seeing as it's pointing to the filename value, what is it's value? Feel free to amend it slightly if required to hide anything you might not want to be public. if it's generated by an expression, what is the expression?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

yogi123 SSCrazy Points: 2932 More actions · Answer 2

Thom A (5/5/2016)
Seeing as it's pointing to the filename value, what is it's value? Feel free to amend it slightly if required to hide anything you might not want to be public. if it's generated by an expression, what is the expression?

I don't know the filename value what it mean? its just simple Flate File Connection with .csv file name.

John Rowan SSC Guru Points: 56440 More actions · Answer 3

Is the connection manager parameterized? It may be that it works in BIDS because your parameters are filled out, but the package may not have the parameters configured on the SQL Agent job.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

yogi123 SSCrazy Points: 2932 More actions · Answer 4

John Rowan (5/5/2016)
Is the connection manager parameterized? It may be that it works in BIDS because your parameters are filled out, but the package may not have the parameters configured on the SQL Agent job.

No the Connection Manager is not Parametrized.

The Network Administrator gave me saparate Credentail for Domain YYY, that i used when i created File Connection manager meaning when i try to map the directory, small window pops up and ask about username and password to access the directory on domain YYY. i put in the Credential and thats how the connection established and run through the BIDS, same package i try to schedule through SQL Agent and it errored out.