The package you're running does more thasn the stored proc you've shown. Looks like a full DB restore was doen, then something ran that caused this error, then the...

As Sean said, you can't return 20 numbers in an int. You could string them together in a single return value like so:

create function fn_fibo(@end int)

returns varchar(255)

as

begin

declare @a int,...

Sorry, I mis-read that. What command in the job is actually issuing the error? Do you have the complete error log from the package execution?

The first question would be: What's the purpose of the NOLOCK? Can you just take it out?

How did you generate the format file? First thing I see is that the format file describes the input as being tab delimited, but the input is comma delimited...

A very efficient character splitting function can be found here:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

The link to the discussion in the article is also worth a read. Lots of great information to be gleaned...

Not really sure what you're trying to do here, but the query that has the column d_created is a different query than the second one. The c alias in...

Could you post the definition of the target table, the format file, and a few rows of data for us to test with? Pretty sure you'd get a qucik...

Hmmmmm... This return 1 for me:

create table box (

shape geometry null)

insert box(shape) values(geometry::STGeomFromText('POLYGON((-125.37123023799995 60.111279971000044,

-125.37123023799995 40.361753622000037, -50.418208553999932 39.647915321000028,

-50.418208553999932 60.349226071000032, -125.37123023799995 60.111279971000044))', 0))

DECLARE @x float;

DECLARE @y float;

DECLARE @h geometry;

SET...

Wouldn't it be the normal:

SELECT @h = Shape FROM GIS_VECTOR.GIS.Box

Is the default database for the user you are loging in as set up correctly? Does that user have an id in that database?

The server is set to use SQL Server authentication?

Did you run a maintenance plan over the weekend that updated statistics or rebuilt indexes?

Can you print both variables before and after the 'select'. How does the date variable get set? What are the data types for the variables?

As far as I know, there is no way to do a backward restore, even if the database was in a compatibility mode that matched the lower version. The...