Last post Jun 06, 2008 03:27 PM by fred51523
Jun 06, 2008 03:27 PM|fred51523|LINK
I want to create a integration service from an visual studio environment
1 i need to retrieve a txt fiel from FTP connection on to my local machine
2. I need to import the data from the text file to a sql server 2005
3 . I also need to schedule it recursively
i created a visual studio new project ---> integration service project ----> added a Bulkinsertcopy control on to design view -----> defined the connection to the database -----> defined destination table ----> defined source file
Right clicked on the bulk insert copy and executed the task
the bulk insert box is turning yellow to red and saying that the task has been excuted
But when i chek my sql server 2005 table
no data is inserted
--i have defined comma , as the column delimniter and ; as the row delimiter
the flatfile or text file also uses the same as
Please let me know ........
Iam a newbie to SSIS (As you can see from the above[8-|]
Any help is appreciated ......