Michael,

Here's a link on how to post your problem so that we can quickly help you. We need to see table definitions (I cannot open your .rar file),...

I'm not sure that's it. I created a table w/ a column name Col2/Name and I was able to BCP into it just fine.

Can you post your table structure and a couple sample lines of the input file? This is most likely a data problem in your file with the / character...

Try putting a Sort transformation directly before your SCD Transformation. Inside the Sort, configure it to sort on the PK value and check the 'Remove rows with duplicate sort...

I think 2 data flows is the way to go here. With what Elliot said in terms of how SSIS batches the rows through the pipeline, you can't do...

How many rows will you be importing from your flat file?

You can use the XML source component inside the same data flow as your flat file source. ...

What does your expression look like?

It looks like you are now calling a Stored Procesure from your SQL Source? If so, you don't need an expression, you...

You mentioned that you have an error, would you mind sharing that with us?

Is this a one-time clean up task? If so, I'd scrap the idea of modeling out in SSIS. Write a query to return the dupes, cut and paste...

BOT is on the right track here. In addition, you don't want to use a data flow task to read your connection parameters into a recordset destination. Instead,...

That doesn't make sense. Adding characters to a file because it is too big! How do you go about truncating a self-describing file?

You can't do this with the...

Rowan (8/23/2009)

Please note that you don't necessarily need to use staging tables becasue of complex queries. Moving a pacakge that uses a staging table to not need one should not...

No, I sure can't. I've seen some articles over the last 6 months or so comparing the two...

I'd use OPENXML instead of Xquery.

DECLARE @x xml

SET @x =

'

'

DECLARE @iDoc int

EXEC sp_xml_preparedocument @idoc OUTPUT, @x

SELECT *

FROM OPENXML (@idoc, '/DATA/ROW',2)

WITH (

ObjectID int './@ObjectId'

)

EXEC sp_xml_removedocument @idoc

A couple of things. First, the format file that the example creates does not match the data file. The format file has "\t" for the field terminator. ...