Solved

HOW TO USE AN SSIS PACKAGE TO IMPORT FLAT SOURCE FILES

Posted on 2008-10-09
1
194 Views
Last Modified: 2012-05-05
Hi there

I created an SSIS package for mssql in visual basics and i am goin to be getting more files in every week where i have to keep importing the file and creating each column on my own using fixed width

Is there anyway i can use the package to so that i can just import the fole with the same fixed width

let me know please thanks

Luke
0
Comment
Question by:LukeConey
1 Comment
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 150 total points
ID: 22686067
yes.  If the weekly files maintain the same format & name, but run the package again.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Want an individual results display div 8 46
SQL Syntax 6 41
Data encryption options between SQL DBs 3 31
SQL syntax question 6 43
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question