SSIS Excel

Question

SSIS Excel

ajolson1964

SSC Veteran

Points: 224
More actions
August 26, 2010 at 8:47 pm

#239485

I know this is going to sound like a weird question but I do have a reason for asking it.
Is there a way to set up a SSIS package to take the contents of a worksheet in one excel 2007 file and place it into the another excel 2007 file, but have it start on Row 8 of the destination file? I can get it to copy over to the file but it always starts at row 1 and I need the information to start at row 8. Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

Set up a named range in the second excel spreadsheet. Insert into the named range, not the tab (tabs end in $; named ranges don't).

Edit: you can also specify the column/rows after the tab name; I think it goes like so: Sheet1$:A8.G9

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

ajolson1964 SSC Veteran Points: 224 More actions · Answer 2

Would this be a Create Table statement in Execute File Task such as

CREATE TABLE [Losses$A10:AE10]?

WayneS SSC Guru Points: 95460 More actions · Answer 3

This is getting into the realm where I'd have to start using Google/Bing to find the answer... so I'll leave that exercise to you. I know I've seen it out there somewhere... I just don't remember how it was done.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

ajolson1964 SSC Veteran Points: 224 More actions · Answer 4

Ok thanks. Oddly enough I think I got it working... Guess when you do it wrong enough you stumble upon the way it works LOL.