SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Database Job fails to run when pulling data
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

miles411
Starting Member

2 Posts

Posted - 01/16/2013 :  16:20:49  Show Profile  Reply with Quote
I am using SQL 2008 and an external vendor change the particular warehouse name for the IMPORT file that I was receiving through my SQL server from them. I get an error under the SQL Server Agent stating the IMPORTFROMXXX has failed. When I open the Job that is running notice that the warehouse name under the import file script is incorrect when I change it to the new name it still fails. How do I go about correcting this?

thank you

James K
Flowing Fount of Yak Knowledge

3699 Posts

Posted - 01/16/2013 :  17:21:39  Show Profile  Reply with Quote
Possibilities I can think of are:

a) The old name is being used some other places that you have not yet found. I don't know where that might be - but it may be that the SQL Server Agent is be running an SSIS package. You may need to examine the SSIS package.

b) The vendor secretly changed the format of the IMPORT file. Strange as it may sound, I have had vendors do that to me vexing me to no end.
Go to Top of Page

miles411
Starting Member

2 Posts

Posted - 01/16/2013 :  17:30:12  Show Profile  Reply with Quote
How do I examine the SSIS package? What are the steps?

Thank you
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3699 Posts

Posted - 01/16/2013 :  17:36:44  Show Profile  Reply with Quote
I am only guessing that it might be an SSIS job - they could be using something else like bcp or bulk insert. You have to examine the job steps to figure out what they are using. If it is an SSIS package, the information on this MSDN page may be helpful: http://msdn.microsoft.com/en-us/library/ms141701.aspx#trouble
Go to Top of Page

srimami
Posting Yak Master

160 Posts

Posted - 01/17/2013 :  06:38:34  Show Profile  Reply with Quote
Copy the SSIS package and simulate the same in Dev environment and change the file name to new name being used. If the file name generated is dynamic then you have to change in variables or else change the static file name where ever it appears on the job.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000