Here is an option:

[font="Courier New"]CREATE TABLE #tmp

(POLE_ID INT, DATE1 DATETIME, DATE2 DATETIME, DIVISION CHAR(1), IGNORE BIT)

INSERT #tmp VALUES (1,'1/1/2008',NULL,'E',0)

INSERT #tmp VALUES (1,1/2/2008,NULL,'E',0)

INSERT #tmp VALUES (1,NULL,NULL,'E',1)

INSERT #tmp VALUES (2,1/1/2008,NULL,'N',0)

INSERT #tmp VALUES...

Tables, by definition, have no order.

If you care about the order of the data, you need to include an ORDER BY clause in any queries you run.

Keep in mind that the SQL Server Destination component will only work if the package is running on the destination server. It is a local-only destination component because of...

You cannot use CROSS APPLY, but the functionality you get from a CROSS APPLY can always be achieved without using it.

If you can post the query with the CROSS...

I have also had some copy and paste issues.

Copying and pasting in the data flow has been pretty sketchy for me. Copying and pasing components in the control flow...

If you really wanted to split the processing into multiple data flows, you could just copy your current data flow and filter the source data so they included mutually-exclusive data...

You have not really given much information, but you can usually delete pretty much anything in Excel by selecting it and pressing the "delete" key.

I recommend you include a bit...

Ok, what's up with this?

http://www.sqlservercentral.com/Forums/Topic608877-149-1.aspx

Even ignoring the fact that he is trying to do something in Excel and is posting to a SQL 2005 forum, this is still a pretty...

If I am understanding you correctly, you want to be able to redirect all of your packages to a different server easily.

Look up "Package Configurations" in books online.

The setup is...

Yes.

There is a Slowly Changing Dimension transformation that is designed specifically to insert or update records based on a key. It is ok for tables less than 1000 records.

You...

It may simple be a language issue with that last post, but I did not follow at all.

Great Lynn, take "should I use identity columns for a primary key" - a subject that will on it's own cause rage-full people to spew out angre messages and combine...

This is a pretty big topic for a forum discussion. I would recommend you find a book on database design.

Integer / Identity columns are often used for primary keys...

No.

Integration Services is it's own application. You don't even need to have a connection to a SQL Server.

You are somewhat wrong.

SSIS can use a lot of memory. For example, use an OLEDB source for a billion records and then a SORT component. This will cause...