you can use a conditional split in the data flow transformation

Anything meeting your criteria can go into the database, everything else can be ignored

You need to go back a few steps and get to grips with the fundamentals

use a book or some online resources to build a simple report first:

beginning-sql-server-2005-reporting-services-part-1[/url]

You'll then have a...

put quotes round the entire path

Source="\\development5\mcd_ack\Acknowledgement Data Extract-MCD_2009-02-26-03-02-53.xls";Extended Properties=EXCEL 8.0;HDR=YES;"

is it possible to stop and start the trace using a script (BAT, VBScript, VB .NET) so that the cumulative data is dumped at when the the trace is restarted?

Hehe 🙂

I had a massive flashback to being 10 years old again and singing that in the playground

STAR TREKKIN' 😀

Well try using an OLE DB connection with the Microsoft Office 12.0 Access Database...

LucaZAV (5/12/2009)

---

You are right, but I choose the Excel 2007 provider to export it. I change the extension in the wizard, because it generate a file with the xls extension...

if it is setting the extension by default as XLS then the spreadsheet will be saved under compatibility mode as a 97-2003 spreadsheet

Changing the extension won't change the method that...

I used this data:

123435

1124015359

1234

1

2

3

4

and created a new derived column using the following:

([Column 0] == "" ? "0" : [Column 0])

and it worked fine

it could well be the empty values which are causing the error

use the data conversion to convert these to a 0(zero)

are you sure you only have numeric integer values in that column?

try running the following SQL with the column and table names changed to match your schema:

select isnumeric(replace(columnname,'.','z')), count(*)

from tablename

group...

I think that might be your problem 😎

You could use the following steps

0. create an empty raw file on the file system where the SSIS package can access it

then in the SSIS package

1. use the file system...

starting with your query (I corrected the syntax):

DELETE FROM TableA

FROM TableA INNER JOIN TableB

ON TableA.a = TableB.b

turn it into a select

Select TableA.*

FROM TableA INNER JOIN TableB

ON TableA.a = TableB.b

every row...