September 28, 2017 at 11:28 pm
Hello,
Thank you for your reply. Problema. Is that the Soure file is excel, not sql. So I cannot build a sql task
September 29, 2017 at 5:53 am
river1 - Thursday, September 28, 2017 11:28 PMHello,Thank you for your reply. Problema. Is that the Soure file is excel, not sql. So I cannot build a sql task
What is the target?
September 29, 2017 at 5:58 am
river1 - Thursday, September 28, 2017 11:28 PMHello,Thank you for your reply. Problema. Is that the Soure file is excel, not sql. So I cannot build a sql task
In that case, the right way to do this is to import that data directly into a staging table with rows and columns intact.
Then you can write a query to transform the data in that staging table into something you can actually use. Alternatively,
you may be able to just use the staging table as a source for a reporting query that delivers the data to an SSRS report.
I don't recall you mentioning an Excel source in your initial post, so please try to be more thorough in your problem descriptions,
as that will help us help you more quickly. Had we known it was an Excel source, we could have avoided several posts
back and forth. As we are not right there beside you, we can't know what you don't tell us...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 3 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply