a couple of area i would look into. first, what is the datatype of the table field that you are importing AmountRebated into? Second, what is the raw value from...

it would be helpful if you posted the script that you are using to check if the file exists.

another thought, as opposed to using a custom script woud be...

good to hear.

regarding the question, the var is declared as a float and remains that way in your procedure. so, the statement above had no real affect on the variable.

your last line would work if it read like so:

set @body1 = 'Advantage File Total'+char(9)+char(9)+char(9)+convert(char(1000),@advtotal)

+char(13)

one way to cause corruption is to create a simple access db and then open the database in notepad and delete out a value and save.

not something i would try...

Brian

The only thing I can see is the program that runs the wizard is located in the following directory (assuming a standard installation):

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

There are no XML or...

from bol:

Time on any day between active_start_date and active_end_date that job begins executing. Time is formatted HHMMSS, using a 24-hour clock.

so, to get the data to look like a HH:MM:SS...

add that criteria to your where clause by using the datediff function like the following:

WHERE

EMPLOYEE_STATUS <> 'TERMINATE'

OR (EMPLOYEE_STATUS = 'TERMINATE'

and ABS(datediff(dd, terminate_date, getdate())) < 30)

hope this helps.

for 2005, the table that replaced the packages table is sysdtspackages90. In there, you will see you list of packages with the created date and package version.

a simple approach if you want to accomplish this task in the DTS transformation and assuming that you have another column in the destination table is to walk through the...

Phillip

You just need to put in a left join. I setup two tables, tblA and tblB with a column called row_id and placed you values into the tables. With the...

use the ident_seed function for the table. for example, in the northwind database categories table:

select ident_seed('categories')

this will return 1

hope this helps

are you missing the column name in the where clause?

WHERE [myDB].[dbo].[syCountry].columnname = @CountryID

hello,

i mocked up your environment from above and changed a couple of table names and fields to get you what you want. from the simple dataset, the ending query should...

Dave

I was happy to get you this far but I cannot tell what the problem is from the original dataset you sent. The SQL I put together returned the following...