i have attached the query and the index usage above. hope that helps in identifying the issue.

The query plan was 3 months. I have also attached the index usage and the actual query.

Table Structure For Subordertrans and shipmentSTL are state transitions below.

ID, SUborderid, ...

All of them are stored in MSDB

Is the maximum length of the query restricted to 128 characters ?

Ian Scarlett (5/10/2011)

---

I think we need to see table and index structures, because in your environment, I wouldn't expect dropping and creating indexes on 3 million rows to take anywhere...

I'm not sure you understood the...

Hi OPC,

thanks for responding. as i said earlier, the ssis is fairly simple package and has been optimized to the best.

6 . Already mentioned.

- How...

This is just plain wrong. If TableA and TableB are the same tables, you might end up deleting all the rows.

Furthermore, the constraint somecolumn='something' isn't present in your query.[/quote]

I think...

Koen (da-zero) (1/13/2011)

---

This is just plain wrong. If TableA and TableB are...

Better in terms of performance only. The table has no indexes and is mainly used for writing and less selectivity.

Control-M is a scheduler and it cannot schedule the job deployed in SQL Server.

You can use the SQL agent to do the job.

I would suggest you to deploy...

Well, you need to have a data flow task which will load the source to staging. Map the columns and load into the staging schema.

In the second data flow,...

All you can do to make it work is declare different variables for servername, path etc and then construct the dynamic file name by appending the variable names.

In the...

Learn the hottest technology of the year online at your home, after work from the experts.

Visit http://expertMSBItraining.com to learn more.

Guaranteed training which can materialize to Microsoft Certification and...

thanks so much dude