Nimesh_Parikh (5/31/2013)

---

Team,

I know I am asking very silly question, But We have put all our efforts to develop SSIS 2012 solution and now customer requirement changes and they wants to...

Bicentennial? A bit older than I would have expected 😛

:hehe:

Great!

Conditional Split is the task you need. Add it after the derived column from the previous post. Send all NULLs to one output and everything else to the other. Then...

Great, thanks for posting back.

Nomvula (5/30/2013)

---

hi guys

i have excel souce with data that i need to import into oledb destination, here's an example of my the import

INVOICE DESCRIPTIONPOSTING DATE

Posted ...

Maybe try something like

Isnull([Month 01]) && Isnull([Month 02]) etc

Also, for future info, I've reformatted this (thanks Redgate, but there are free alternatives) and put it in tags. See how much easier it is to read:

select count(tvid)

...

Using your code, adapted slightly:

declare @StartDate date = '20130501'

--Wednesday

declare @EndDate date = '20130507'

...

var05 (5/29/2013)

---

Ya you are right... List of ids to be pulled from one table and pass it to a query as a filter...

The problem is both the tables dont reside...

var05 (5/29/2013)

---

Thanks both!

Say I have a table in SQL where in I add and remove the employee names.

My Execute sql task will pick up the employees in that ABC sql...

var05 (5/29/2013)

---

Hi All

I would like to know how to pass a paramater from Execute SQL task to OLE DB source

I have an execute sql task returing a full result query....

Put both result sets in database tables and run some queries so that you can understand what the extra rows look like. Then, maybe, you can...

KoldCoffee (5/28/2013)

---

Phil, you've always been spot on for me in the past, so I was :w00t: and :ermm: and :crazy:. and a little bit wondering if it had more to...