Right, you got it! Our posts crossed. I didn't know whether your detination table already existed or was being created as part of the Data Flow. Looks like you're on...

Presumably you are importing the data for your text file into a database table, yes? If so, when...

Ryan Keast (1/3/2014)

---

Theses are the errors I receive after I run the SSIS after creating a second field in the database which is the primary key.

The field I have created...

Yep, good idea, you could use a Conditional Split transform with a condition like 'LEFT(columnname,1) != "T"

If you've got hundreds of thousands of rows in your text files, it might...

Off the top of my head, you could import all the rows including the Trailer row (but not the Header row) into a staging table that contains all the columns...

The equivalent of indexes in an OLAP Cube are Aggregations. Far from degrading performance, correctly-designed Aggregations can improve performance tremendously (be careful not to have too many though).

Chris Webb has...

Hmm. Ok, does the package have any Package Configurations active, e.g. stored in an XML file or database table? If so, have you checked that you have the necessary permissions...

Sounds very strange!

Is your source query just a 'standard' SQL command or is it derived from a variable and/or expression? Is the SSIS package running as a SQL...

Off the top of my head I think that one or more Conditional Split components might be able to help here; you can route data down different paths depending on...

Is there a reason why you want to do this using a Script Task rather than creating an Event Handler and using the built-in Send Email Task?

Robert Sheldon has written...

Hi,

What is the ProtectionLevel of the SSIS package set to? If it is 'Protect All With User Key' then only the User who created the package will be able to...

Hello Rob,

I assume that you cannot use or don't want to use Transactional Replication or Change Data Capture against your Source System database(s)? (Note: CDC is only available from SQL...

How about number 1709? ;-). The point I am making Kevin, as you...

Can you please state clearly what the problem is?

Thanks

Lempster

Thought I should update this post! I decided to go with a Bridge or 'Factless Fact' table to meet my requirement.