IOT Virtual Conference - Register now to book your ticket and get updates
x
WIN Surface Laptop 4, i7 Processor, 16GB RAM, 512GB SSD
x
CONGRATULATIONS! C# Corner Q1, 2021 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
Shriwitha
2k
2
128
SSIS packege to load CSV file in new sql table every time it runs.
Feb 24 2021 9:42 PM
Hello,
I am new to SSIS.I need to create a SSIS package where CSV is the source file and SQL table is the destination.
Users place CSV file in a shared location once in a week, for every run (on a weekly basis) it needs to create a new dynamic SQL table in DB.Table name will be date extension along with the file name.
Can any one help me with the steps to achieve this?
Thanks in advance,
Reply
Answers (
2
)
How to update comment with statment havemulti status where i have more
Get the columns names from a column