August 8, 2011 at 9:21 am
Hello All,
I have a package. It works fine when i run package itself. But when i run it as a job it does not work. It says ran successfully but does not import anything.
Based on other people's experience i have checked permissions issue too and thats not my issue.
My package imports data from csv file to a sql server table. I have used look container and variable name to pickup any files of csv format. When i truned on logging it seems like it is not doing anything with that loop container.
Any suggestions?
August 8, 2011 at 9:25 am
Look at your path to the CSV file. It may be correct when you run from your computer, but incorrect on the server.
August 8, 2011 at 9:30 am
Thanks.
I have given path like this \\file servername\foldername
It works from server too but when i run ssis package not the job.
August 8, 2011 at 12:24 pm
You say you already checked this. But I would go back and check permissions again. Does the account that the SQL Server Agent uses have permissions to the folder where the CSV files are stored?
August 8, 2011 at 12:44 pm
Yes it has permissions to that folder. I am not sure what is the problem... going crazy now..
It works when i connect to SSIS in sql server and execute a package..
August 8, 2011 at 2:18 pm
Does the package have any logging set up? That can sometimes he helpful for identifying issues.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply