May be this helps: http://www.sqlservercentral.com/Forums/Topic446498-148-1.aspx .

Please look for the post from Ravi

You can find the FileWatcherTask on http://www.sqlis.com

The connectionString, Servername etc is set in the ExpressionEditor of your ConnectionManager, not in the Data flow.

The except-clause requires that both parts of the sql-statement have the same structure. The exist-clause needs a subquery to work. Which is faster (or better) I don't no.

AFIFM (4/7/2009)

I was trying to find which records in table A that...

Hi

you can set the property 'HeaderRowsToSkip' in the flatfile-connection you use (SkriptTask?).

First insert the data colums in your table.

Please try an 'Execute SQL Task' with an ADONET-Connection to your database. In the SQL-statement use 'insert into yourTable (filenamecolumn) values (substring(@yourVariableContainingTheFilename,2,4))

where...

do you know the data transformation 'conditional split' ?

create an 'Execute SQL Task'. The SQL-Statement can be something like 'select filename from tablename'

Choose 'single row' for the ResultSet

In the ResultSet Tab set ResultSetName 0 and Variable Name...

a) read your flat file in a table (First column a counter, second field a row from your file)

b) create a variable

c) fill this variable with the identificator (the...

If you want to see the differences in the content of two tables, you can try this

Select * from table1

except

Select * from table2

Both tables must have the same structure

Hello

please try select cast(email as varchar(255)) from ....

What type has the variable ? String ?

Not complete. Create the CREATE Table... and the import.sql's with the Stored Procedures and run them in SSIS

Did you ever try to solve the problem with a Stored Procedure ?

Use ISO-Formated (YYYY-MM-DD) date-fields to import.