dji (8/17/2011)

---

Following some great advice on another post I made about importing flat files. I took the leap and started with SSIS packages, probably the best SQL decision I ever...

Save yourself from Excel hell and output to CSV instead. Then (apart from max row issues) it doesn't matter which version of Excel...

Maybe change your query to return 'true' (has data) or 'false' (no data) instead and build your precedence constraint accordingly.

spin (8/16/2011)

---

my laughing gland has burst and i can see a long stint in intensive care ahead. 😛

i mean something like..

select * from openquery('select * from thisTable where date >=...

Is it Informix? You might do better in a Unix db forum ...

Randy Doub (8/15/2011)

---

I have a table with one varchar(1000) column of pipe delimited data. The contents are exported to a .txt file for import to another system via SSIS....

Ah indeed. No doubt that fact would have become obvious very rapidly during development. I knew it was too early for me to have been...

Wow, Jesus monitors this forum too?

:hehe:

No problem, happy beetling.

Sure - I...

Dates don't quite work that way. Try this:

select * from Sales.SalesOrderHeader

where OrderDate between '2004-01-01' and '2004-12-31'

In fact, because dates in SQL Server generally have a time component, this may be...

Something like this might do it:

select t1.MonthYear, t1.Location, Coalesce(t1.Metric1, t2.Metric1) Metric1, Coalesce(t1.Metric2, t2.Metric2) Metric2

from t1 join t2 on t1.MonthYear = t2.MonthYear and t1.Location = t2.Location

sudhakar.siram (8/11/2011)

---

i have one excel file that file contain 5 sheets.how to load all sheets at a timeto my destination in one data flow task

hi guys give solution to my...

Please explain why you want to use a 'temp variable' rather than a table variable. What do you think the difference is?

Paul?

Please provide sample source data & an idea of what the required results are (follow the link in my signature for advice on how best to ask for help).