July 7, 2010 at 2:01 pm
Hi,
I have few .txt and .csv file which I want to import into database "DB1". I'm using SSIS to do this.
Actually I want to import multiple files from a folder into the database. There is data import\export Wizard, but I only want to use SSIS and develop a package that imports multiple files with different columns at one time into the database so that I can create various reports from the tables.
Can you guys give me any ideas how to do that ?
July 7, 2010 at 6:50 pm
Novicejatt (7/7/2010)
I only want to use SSIS
Are you sure you posted in the right forum? SSIS was new to SQL Server 2005. SQL Server 2000 has DTS.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 14, 2010 at 1:25 am
hey can you use dts method in sql 2000
or if u want please post in the sql server 2005 filed in the Forums
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply