Scheduling a ssis package to run

I have an SSIS package that is in the file system. I want to schedule it to run daily. It will b accessing data that is on another server. When I try to set it up, I browse to the package location to get the path, but when I try to run it, it says it does not find it. Itried entering the path as unc but it still got the same error. I have never used the sql server agent before.
qbjgqbjgConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

qbjgqbjgConsultantAuthor Commented:
The package is located in the file system, but is not on the server where I am trying to set it up. Is that the issue?
qbjgqbjgConsultantAuthor Commented:
I moved the package to the c drive of the server I have the job on it found it. HOWEVER, it is getting an error that it cannot open the destination flat file. That flat file is  on a drive on another server. It retrieves data from the database (also on another server just fine). I am running it as myself as the owner. I have read/write permissions to the file that it can't open. Any suggestions.
qbjgqbjgConsultantAuthor Commented:
I got past that problem by specifying a UNC path for my destination file. I have one more error now. In another step I have a source file that uses an ODBC connection. The odbc connection is setup on the server, but the package does not appear to find it. This is the error message: Error Code 0xC0208449 Source Transform Data to CSV(Data Flow Task) Description ADO.NET Source has failed to acquire the connection with the following error message “ERROR [IM002] [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified”
Active Protection takes the fight to cryptojacking

While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.

Jim HornMicrosoft SQL Server Data DudeCommented:
>The package is located in the file system, but is not on the server where I am trying to set it up. Is that the issue?
Yes, as you discovered the paths are the server where SQL Agent/whatever is running, and not your dev box's file paths.

>That flat file is  on a drive on another server.
Same answer.

>Description ADO.NET Source has failed to acquire the connection
Might be a driver issue on that server, and the next step is to search for what versions of the ADO.NET drivers are on the server, what's needed, and possibliy download an update.   Have you tried it ODBC to see if that works?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
qbjgqbjgConsultantAuthor Commented:
The ODBC connection is fine. This package will run fine when executed manually from the server where it is now.
qbjgqbjgConsultantAuthor Commented:
I actually found the solution. The Odbc connection was defined as a User DSN, It needed to be a System DSN.
qbjgqbjgConsultantAuthor Commented:
I am accepting as solution since it was the only respose I got. I am not sure if that is what I am supposed to do. I pretty much figured it out myself.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.