If you thought the flat file import is touchy, you should try the Excel one... 🙂

Anything peculiar that you export?

What is the format of the excel file? .xls or .xlsx?

Grant Fritchey (7/29/2013)

---

It's all http://www.youtube.com/watch?v=0pRUGsB1qGY all the time,...

tbraithwaite (7/29/2013)

---

Thanks Koen,

I think I may have found a solution. Both instances run OK, but you need to use SSMS 2008 to manage the SSIS 2008 instance and...

I like the new look.

I think what the article means is that you cannot install for example SSIS 2012 twice on the same machine, but you can install SSIS 2008 and 2012 on the...

There's a great answer in this thread:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6c7a482a-59fc-4cc8-b8cf-fc02e7c79174/pls-help-how-to-backfill-the-data-since-some-day

😉

Instead of a data flow, you need an Execute SQL Task as Daniel mentioned.

Just put an INSERT INTO <table> before all your queries in your source table and execute it...

You'll need the 32-bit set-up. (although BIDS is a 32-bit program, so in theory the 64-bit set-up should be able to install it. But it can't run as it is...

This blog post explains the concept on how you can achieve this using a recursive CTE:

Using recursive CTE for a hierarchical relationship[/url]

You could try to work with relative paths:

Relative Paths in SSIS

SSRS needs a SQL Server database, so installing it "as a new installation" means also installing SQL Server again as a seperate instance.

Personally I would add it as a new...

How about some DDL for the tables, some sample data and desired output?

Please read the first link in my signature on how to post questions on forums. It will get...

Tsk tsk, first question of the week, and it's about XQuery (ugh). And even a trick question (double ugh).

Barf. Brainfart! :-D:hehe: