Using the conditional split is a good start.

Route the insert rows to an OLE DB Destination and write them directly into the destination talbe (make sure to use the fast...

VegasL (9/12/2013)

---

Hello,

I am trying to group by the aggregate results by combining multiple tables, below is what I have, but it is not aggregating as it should. Appreciate the help.

Here...

dm_tapas (9/13/2013)

---

Thank you,

The job is running since 3 years,,, last 2 weeks it got failed. Nothing has been changed compare to earlier.

some body suggested to delete and recreate the job.....

If you want a copy of the remote database, use a backup as HanShi mentioned. Use a copy only backup though to not break the backup chain.

Copy-Only Backups

If you want...

Not necessarily. If each query returns different metadata, you can't use a dataflow.

An OLE DB Source needs metadata for the columns. Stored procedures don't have fixed metadata.

Using stored procedures inside an OLE DB Source component

I'd suggest to use a table valued function,...

Too bad SQL Server doesn't support...

That's what they want you to believe.

This is pretty easy in SSIS:

you loop over the files with a for each loop, pick up the query and use bcp with the queryout option to write it to...

Very nice question to close off the week.

And kudos for mentioning the default language, so there's less whining in the discussion 😀

Whisper9999 (9/12/2013)

---

Koen Verbeeck (9/12/2013)

---

You can always install the 2005 and 2008 clients to manage their respective servers.

They can operate side-by-side.

Although at the end I would just use the 2012 SSMS...

You can always install the 2005 and 2008 clients to manage their respective servers.

They can operate side-by-side.

Although at the end I would just use the 2012 SSMS to manage everything.

Loner (9/12/2013)

---

I am using SQL Server 2008 SSIS.

I used to have a DTS package using Dynamic property task so when I move from development to QA and to production, I...

1) No

2) No

You need BIDS 2005 to edit and save SSIS 2005 packages, BIDS 2008 for 2008 packages and SSDT 2010/2012 for SSIS 2012 packages.

Not to call you lazy, but a 1-minute Google search would provide you with the answer. The first result when entering datediff into google gives the Technet documenation page.

Heck, just...