Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Single file excel file upload to sql destination Expand / Collapse
Author
Message
Posted Wednesday, July 30, 2014 2:28 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:08 AM
Points: 26, Visits: 96
Hi,
I have a file which changes every week @C:\TEMP(data and filename both) schema remains the same all the time. I want to import this data to sql and save it to archive folder.
I will have only one file in temp as the executed file goes to archive. The folder becomes empty.
Please suggest.
I have tried for each loop for this but doesn't seem to work. I am using visual studio 2005 and my excel files are in 97-2003 version(.xls)
Post #1597971
Posted Tuesday, August 5, 2014 6:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 12:19 PM
Points: 86, Visits: 220
your question is not clear,

I can understand two questions.

How can I view / why my files are not visible once it is processed from the package. ?

How can I import an repository file into DB and then move the file to an archieve file ?

kindly reply back which is your question. or give your question clearly as it is not now.
Post #1599668
Posted Tuesday, August 5, 2014 6:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 13,046, Visits: 10,815
susmitha117 (7/30/2014)
Hi,
I have a file which changes every week @C:\TEMP(data and filename both) schema remains the same all the time. I want to import this data to sql and save it to archive folder.
I will have only one file in temp as the executed file goes to archive. The folder becomes empty.
Please suggest.
I have tried for each loop for this but doesn't seem to work. I am using visual studio 2005 and my excel files are in 97-2003 version(.xls)


How come the for each doesn't work?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1599669
Posted Tuesday, August 5, 2014 6:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:08 AM
Points: 26, Visits: 96
hi
sorry for not being clear. I am trying to build a ssis package where after imported to sql table the excel file should go to archive folder(to have a history of processed files). My source file is excel and destination is mssql.
I have solved this issue by using file system task after my data flow task.

Appreciate your reply
Thanks
Post #1599671
Posted Tuesday, August 5, 2014 7:03 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 12:19 PM
Points: 86, Visits: 220
yes, that is the solution I too thought, and make sure you give "Operation"="move" in the file system task editor and overwrite destination set to true.

Thanks,
Prabhu
Post #1599674
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse