well, the conditional split only provides one input for data so what you can do is add a data source to the package and a merge join task and then...

for this scenario, i would probably do one or the other of the following:

the first thought would be to have a stored procedure on the server that does the...

in the data flow, you can setup a flow that will export the bad records to a flat file that fail the data validation.

for example using a conditional split...

hmm, someone might have a better answer than this but a thought could be to insert the validated records directly into a table instead of returning into a recordset object...

personally, i would walk through the import\export wizard within the database where you could setup either straight table mappings between servers or write a sql query. Both options allow for...

why would you want to use an object variable as your source as opposed to using the sql that produced the recordset as your datasource through an OLE DB Source...

i am a little unsure of what you are trying to do. a default value is in place when you insert a record into a table but do not specify...

after you download the component setup and run the install, the directory that you installed the component information to contains a readme.txt file that explains the steps you have to...

one idea would be to restructure your table to let batch id be a computed column. the computed column would reference a function you create that would decipher the rows...

do you have a date table in your db where you could join to that table to get the date and then do a count from order

the sql would look...

the redirect should come from the OLE DB Destination to the Flat File Destination that will contain the error rows.

put that in place, delete the redirect from the Flat File...

another thought on the error record, if you right click on the Flat File source and select Show Advanced Editor, go to the Component Properties tab and look at the...

the approach i would do for that is to redirect the rows that fail to an error file, which would be the result of the OLE DB Destination Error Output....

ok, when you get to the third record, if you subsitute the empty columns to be 0,0 in the flat file instead of the empty placeholders, does this import? ...

if you were to remove all records from the file but the first record, does the first record import?