Solved

Cannot open data files from new SSIS 2008

Posted on 2010-09-14
5
306 Views
Last Modified: 2013-11-10
I have upgraded SQL Server from 2005 to 2008(64 bit). I moved over all my ssis packages to the new server and now it will run manually in BIDS but not from a SQL job? It is telling me it cannot open .csv files or that I dont have permission to open an excel file from a connection manager, just to name a few errors???
0
Comment
Question by:johnnyaction
5 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 500 total points
ID: 33675901
read this great article about 64bit issues and how to solve them,
read it carefully,
http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html
0
 
LVL 15

Expert Comment

by:AmmarR
ID: 33715327
Dear johnnyaction

you need to check the following services
 Sql server Agent and Sql server integration services
under which account are they running
and you need to check if the account has permission to run packages

services.png
0
 
LVL 1

Author Comment

by:johnnyaction
ID: 33755392
please award 500 points to Reza Red ID: 33675901. Thanks
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 34618163
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question