Please don't cross post. Answered here and you'll need to install the drivers mentioned.

crazy_new (2/4/2015)

---

I don't want to export from SQL, I want to import to SQL from the excel file. I have now created a format file but it still say starting...

I'm not aware of this metadata being held anywhere, but if you are regularly backing up your SSAS database (which you should be!) via a SQL Server Agent job or...

Rich Parsons (2/2/2015)

---

This was helpful, so thanks.

I needed to use a Derived Column transform, then a Sort, and undo the IsSorted and SortKeyPosition, before the Merge Join would work. ...

ramana3327 (1/26/2015)

---

Currently the backups are residing in one server but database has to restore in another server.

I have to get that backup files to separate server and then restore...

You're welcome!

You'll need to use variables to store the date of each backup and then use those variables together with precedence constraints to route your logic accordingly. You don't need to...

Jeff Moden (1/16/2015)

---

Also, I question the word "portable" here. Admittedly, my experience in SSIS is practically nil but I have seen what some folks have gone through to move...

Jeff Moden (1/15/2015)

---

Shifting gears on this same subject, let's have some fun and do a cooperative exploratory on a very typical spreadsheet import problem.

I've attached a spreadsheet (Sample Spreadsheet for...

I'm with you on that one Jeff, but I have to disagree...

Do all the tasks run in parallel or serially?

If you are just exporting whole tables and then importing then into SQL Server, SSIS might not be the best tool to...

Koen Verbeeck (1/13/2015)

---

You're right. It will scan only 16,483 rows, as mentioned in this KB article. I have no idea how I got that 60,000 number in my head. I...

ps_vbdev (1/14/2015)

---

Ok i understand. Think im getting my head round this after a bit of confusion. CDC will only provide a performance improvement at the extract stage, once the changed...

I'm not sure about that Phil, but I would guess so. There are 3rd party tools that can assist...for a price obviously. About the package upgrading: it's not permanently upgraded...

aliasghar.09 (1/9/2015)

---

Hi Experts,

A newbie here. So please be kind 🙂

I have 2 Tables namely Item & Item Entries. relation is Item.No = ItemEntries.No. In Item Entries Table I have Columns...