unfortunetly it is sql2000

Yes we have to lock them down due to a process/program that runs against them everyday.

These databases are more like reporting databases and is only used for this program and...

group by isnull(field1,'') + isnull(field2,'')

What is happening is I am getting a hard error such as the database does not exist...but the job just stops.

I want to catch that error so I can...

replace(convert(varchar(8000),sv_inq_txt.inquiry_txt),char(13)+char(10),'

')

In the above, I replaced CR/LF with

....change '

' to ''

Actually I found the problem.

When I ran select * from sysdatabases

I was getting and arithmetic overflow...

The number of rows returned was 39, it should have been 80.

Then when I...

My Execute SQL Task General Tab has a ResultSet of SingleRow, Connection Type OLE DB, Connection of CCXXSDDB010.ietenterprise, SQL SourceType of Direct Input,

and just to test I have a SQL...

It is defined on the left side of the screen as a "Package" variable.

I have an "Execute Sql Task" that populates the variable.

My Execute SQL Task General Tab has a...

i have vadb15\vabiv... this is a sql instance on the vadb15 server.

yeah the case and spelling are correct...

am i right and the SourceDatabaseName property should be blank since I have an expression set up pointing to my variable?

ok, that worked.

it has my database name in the msgbox

still saying i need a sourcedatabasename

when i edit the task, sourcedatabasename is empty

expressions has SourceDatabaseName with @[User::Indatabase]

I am missing something. It is throwing an exception when i added the msgbox.

THe code has the following files included:

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

This is the error....

at Microsoft.SqlServer.Dts.Runtime.Variables.get_Item(Object...

ok. i did that, i entered @[User::InDatabase]

but it is still aborting on me. how can a debug it to see what my sqltask is popluating the variable with?

Thanks Flo. I always love your posts as they are very informative and easy to understand.

I am assuming I can read the system tables to find the constraints, indexes and...

The problem is that the network is crap. But I have no control over that and I still need to get my work done.

We need a duplicate of the production...