Data Import - Header And Trailer Files

Jul 5, 2007

anyone know how to :
detect header row and insert to table a
process data rows and insert to table b
detect trailer row and import to table a

thanks

View 2 Replies

BCP Output With Header And Trailer

Jul 20, 2005

I'm copying data out to a file with pipe delimiters. I would like toadd a header and trailer.Is this possible? If so, please help me with the steps.Also, is it possible to append to a text file while doing the bcp? Ifso, how?

View 1 Replies View Related

Integration Services :: Import Files With Different Header Structures?

Jun 13, 2015

I currently have a directory of csv import files, all of which have the same data structure but different header information.

For example:

File 1
This is header info.
This is header info.
This is header info.
ID,Name, DOB, etc…

File 2
This is header info.
This is header info.
This is header info.
This is header info.
This is header info.
ID,Name, DOB, etc…

The data starts with the column title row, ie ID,Name, DOB.What I need to happen is process that removes all the header rows up to the title row so that all import file structures will be the same.

I was thinking of using a ForEach Loop container that will run a script on each of the files to remove the header.

View 5 Replies View Related

Combine Data And Split Into Separate Txt Files For Each Header/detail Row Groupings

Mar 16, 2006

I��ve created with the help of some great people an SSIS 2005 package which does the follow so far:

1)       Takes an incoming txt file. Example txt file: http://www.webfound.net/split.txt

The txt file going from top to bottom is sort of grouped like this
     Header Row (designated by ��HD��)
          Corresponding Detail Rows for the Header Row
           ��..
     Next Header Row
          Corresponding Detail Rows

     ��and so on

     http://www.webfound.net/rows.jpg

2)       Header Rows are split into one table, Maintenance Detail Rows into another, and Payment Detail Rows into a third table. A uniqueID has been created for each header and it��s related detail rows to form a PK/FK relationship as there was non prior to the import, only the relation was in order of header / related rows below it when we first started. The reason I split this out is so I can massage it later with stored proc filters, whatever��

Now I��m trying to somehow bring back the data in those table together like it was initially using a query so that I can cut out each of the Header / Detail Row sections into their own txt file. So, if you look at the original txt file, each new header and it��s related detail rows (example of a cut piece would be http://www.webfound.net/rows.jpg) need to be cut out and put into their own separate txt file.

This is where I��m stuck. How to create a query to combine it all back into an OLE DB Souce component, then somehow read that souce and split out the sections into their own individual txt files.

The filenames of the txt files will vary and be based on one of the column values already in the header table.

Here is a print screen of my package so far:

http://www.webfound.net/tasks.jpg

http://www.webfound.net/Import_MaintenanceFile_Task_components.jpg

http://www.webfound.net/DataFlow_Task_components.jpg

Let me know if you need more info. Examples of the actual data in the tables are here:

http://www.webfound.net/mnt_headerRows.txt
http://www.webfound.net/mnt_MaintenanceRows.txt
http://www.webfound.net/mnt_PaymentRows.txt

Here's a print screen of the table schema:
http://www.webfound.net/schema.jpg

View 17 Replies View Related

How To Import Data From .html Files

Oct 17, 2007

Hi,

I want to import data from .html files to SQL Server 2005 tables using SSIS. Can somebody help me by directing me on how to achieve this.

I tried to many ways but couldn't succeed.

Any help on this will be very helpful.

Thanks

View 1 Replies View Related

Import Data From Text Files Into SQL Server...?

Jun 6, 2005

Hi,i wanna develop an web-database application with ASP.NET,C#, SQL server 2000.i already have some data whichs been in text format(text file) and now, i want to import the same into my database.the problem is, the text file has got many line breaks and also its not well formated to import it using DTS.Can any one help me out in importing the same.thanks in advance

View 3 Replies View Related

Import Text Files Data Into SQL Server

Feb 17, 2007

I need to extract data from text files (around 200) and import into sql server tables. I tried using SSIS foreach loop container but could not manage it. Can anyone guide me how this can be done?

All help appreciated.

Thanks,

View 4 Replies View Related

How To Import Data From AS400 Files To Sql 2005 Tables?

Apr 18, 2007

Hi All,

I want to Import data from AS400 to Sql2005. From the Sql Management studio I invoke the Import Data wizard. For the source I connect to the ISereis system and for the Destination I select the Sql2005 Database , When I go to the next step i.e select source tables I get the error
"An error has occured which the SQL Server Integration Wizard was not prepared to handle
No error message available,result codeB_E_CANTCANCEL(0*80040E15).(System.Data)" .After this I am unable to proceed further. I am using client Access tool to connect to ISereis

IBM DB2 UDB for isereis IBMDA400 OLE DB Provider

Regds,

Anu

View 2 Replies View Related

Import Data From Two Text Files Into One Database Table

Feb 12, 2008

I am learning SQLServer Integration Services.

I created a file People.txt containing firstName, LastName seperated by a pipe.

------------------content-----------
John | Doe
Mike | James
Adam | Smith
-----------------------------------------

and another one called gender.txt

------------------content-----------
M
---------------------------------------

I will would like to create integration services package that compines each record of the first file with the record of the second file and inserts the result into table.

--------------Result table content------------------

John
Doe
M

Mike
James
M

Adam
Smith
M

-----------------------------------------------------------

Thanks

View 5 Replies View Related

Problem In Maintaining Data Precision During Import From Flat Files.

Nov 19, 2007

In my scenario I have about a dozen of flat files (Text files),that I have to import in SQL Server 2005.
I am using Flat File connection manager to carry out tha task.Flat files contains data generated from oracle.
When I import data from these text files into SQL ,the main problem lies in converting number(p,s) data type column of Oracle(In text file) to numeric(p,s) data type of sql server 2005.

Number(p,s) data type looses all it's digits after decimal to zero during import process.
For example

1.2434234390 (from text file,number(p,s) type of oracle) converts to 12.0000000000 (numeric(p,s)) of sql server 2005.

Is this this any workaround to this problem.I urgently need help.

View 7 Replies View Related

Doing A Data Import Using DTS Wizard In SQL Server 2005 - Being Efficient With 5 Flat Files

Apr 13, 2006

Hi,

I'm a new user of SQL Server 2005. I have the full version installed. I also have SQL Server Business Integration Dev Studio installed. My OS is Windows XP.

I'm importing a series of 5 flat files into a database on one of the SQL Servers we have. My goal is to get 5 different tables (though perhaps I should do one and add an extra field to distinguish each import) into the database for further analysis.

I tried doing an import via DTS Wizard. There are no column names in the flat file so I defined them during the import process (all 58 of them). When I got to the end, I had an option to save the import process as a SSIS (SQL Server Integration Service) Package on:

SQL SERVER (I don't have permission for this)

or

FILE SYSTEM (did this one)

I saved the Package locally in hopes of being able to go back in, change the source file and destination table of the package and quickly get the other 4 flat files imported.

My problems are:

1) I couldn't find how to run the *.DTSX Package file to run in SQL Server Studio (basically reuse the Package with minor changes and saving me having to redefine the same 58 columns on each flat file import)

2) Tried but didn't understand how to run it in SQL Server Bus Intel Dev Studio (i.e. understanding the mapping and getting the data types right so it wouldn't error out)

3) Don't know how to make the necessary changes so that the Package handles the next source file and puts in a new destination table (do I need to do 5 CREATE TABLES so this Package has a place to run to?)

4) Does the Package need to be part of a Project to run (I haven't found how to take an existing Package and make it part of a Project/Solution)?

5) Is there a good book or online resource for just getting the basics of using SQL Server 2005 and SQL Server Business Intelligence Development Studio?

I'm really at a loss after spending a day fruitlessly on it scouring the help files, forums and experimenting around.

Hope somebody can point me in the right direction.

Regards,

Patrick Briggs,
Pasadena, CA

View 7 Replies View Related

Bulk Insert Fails To Import Data Files Created On Unix

Sep 21, 2006

It seems to me that files created on Unix machines with line terminator , or chr(10), cannot be imported using the Bulk Insert statement. Is this a bug, or an oversight by Microsoft? Does this mean that unless one replaces all with
, there is no way to use Bulk Insert to import Unix files? This is a very strange behavior by MSSQL. Even lessor programs such as Excel and Word automatically recognize chr(10) as a line termination character. Am I missing something, or is this just the way MSSQL is?

View 7 Replies View Related

Doing A Data Import Using DTS Wizard In SQL Server 2005 - Being Efficient With 5 Flat Files

Apr 18, 2006

I just spent some time working out how to do a seemingly simple task. I��m sharing the steps I took to do this in hopes it saves other SQL Server 2005 users (especially newbies like myself) time.

My original question posed on several SQL newsgroups was based on this goal:

I'm importing a series of 5 flat files (all with same file layout) into a database on one of the SQL Servers we have using SQL Server 2005 (SQL Server Management Studio) . My goal is to get 5 different tables. I want to do this without having to redo all the layout criteria 4 additional times.

Below are the steps I followed to get a solution (all done in Microsoft SQL Server Management Studio):

Create the Package (data import)

1) Use the SQL Server Import Export Wizard (equivalent to SQL Server 2000 Data Transfer Wizard) to import your first flat file. At the CHOOSE DATA SOURCE window browse for your file.
2) Under the Advanced tab, you can set your Column attributes (��output column width�? or ��data type�? to name a few). I highlighted all the columns and selected ��string [DT_STR]�? for data type. To avoid truncation errors, I selected 255 for output column width. You can name the columns whose data you are most concerned with (I did import all the available fields).
3) After choosing a server destination you will have a ��SELECT SOURCE TABLES AND VIEWS�? window pop up. Under the ��Mapping�? column you can choose to tweak your mapping further editing in SQL (see Edit SQL button). I didn��t.
4) The ��SAVE AND EXECUTE PACKAGE�? will pop up. The ��Execute Immediately�? box should be checked and you should check the ��Save SSIS Package�? (SQL Server Integration Services). When you do, select ��File System�? for where to save this import-file-package to.
5) Click OKAY for the Package Protection Level and the ��SAVE SSIS PACKAGE�? window will appear. Browse for a path on your local computer to save to.

Modify Package (data import) for Next Use

6) In SQL Server Management Studio, browse for the Package and open it.

Preparation for SQL Task �� box

7) You should see a screen that shows two boxes (��Preparation for SQL Task�?) and (��Data Flow Task�?).
8) Right click on the former and select ��Edit�?.
9) On the ��SQL Statement�? row, click into the right column and select the ��? box
10) Change the destination table (the table you will create with this package) to a meaningful name and click OK.
11) Click OK for the ��SQL Task Editor�?

Data Flow Task - box

12) Right click on the ��Data Flow Task�? box and select ��Edit�?.
13) Three boxes will appear ��SourceConnectionFlatFile�?, ��Data Conversion 1�?, and ��Destination - <whatever table name your original data import went to>�?. Below them is a section that displays ��Connection Managers�?

SourceConnectionFlatFile - editing

14) The first thing you will want to do is change the import source to a new flat file. You do this by going below the boxes under the ��Connection Managers�? window and right clicking on ��SourceConnectionFlatFile�? and then selecting ��Edit�?
15) Browse for the new ��File Name�? and select it.
16) A ��Microsoft SQL Server Management Studio�? window will pop up asking you if you want to ��keep or reset the existing metadata�?. The metadata is just your column definitions and choosing ��YES�? to keep this makes sense if you are doing data imports on files with the same file layout.
17) Still in the ��Flat File Connection Manager Editor�? window, change the ��Connection Manager Name�? to something meaningful (I add <_> at the end and then the name of the table the flat file is going to) and click OK.

SourceConnectionFlatFile �� box (editing)

18) Right click on the ��SourceConnectionFlatFile�? box and select ��Edit�?.
19) Your newly named ��Flat File Connection Manager�? should appear in select box.
20) Click OK, right click again on the ��SourceConnectionFlatFile�? box and select ��Show Advanced Editor�?.
21) Under the ��Connections Manager�? tab, your newly named ��Flat File Connection�? should appear (the prior step is necessary for the advanced editor to recognize your change).
22) Under the ��Component Properties�? tab, on the ��Name�? row, click into the right column and rename to something meaningful (notice the ��Identification String�? row description changes too once you click out of the ��Name�? row)
23) Under the ��Column Mappings�? tab, just confirm you are mapping your flat file fields (��Available External Columns�?) to a destination table��s fields (��Available Output Columns�?).
24) Under the ��Input and Output Properties�? tab you can check in ��Flat File Source Output�? to make modifications to either your ��External Columns�? or your ��Output Columns�? �� you shouldn��t need to for a simple import.
((NOTE: any changes you make here would likely need to be consistent with the column properties found under the ��Connection Manager Window�? for the ��SourceConnectionFlatFile�? as well as the ��Data Conversion 1�? box under the ��Data Flow Tasks�? window, so exercise caution
25) NOTE: This process has worked for me by making my source columns all ��string [DT_STR]�? data type and the output columns all ��Unicode String [DT_WSTR]�? data type.

Data Conversion 1 �� box (editing)

26) There is nothing you need to do here. By right clicking on the ��Data Conversion 1�? box and selecting ��Edit�?, you can see and change the data type of the output columns (the ones in the table your importing the flat file to). There are probably more edits one can do but they��re beyond what I��ve learned.

Destination - <whatever table name your original data import went to> �� box (editing)

27) Right click on the ��Destination - <whatever table name your original data import went to>�? box and select ��Show Advanced Editor�?.
28) Select the ��Component Properties�? tab.
29) Select the right column at the ��Name�? row and change the name to something meaningful (ie. related to the source file name or the table name you��re importing to).
30) Select the right column at the ��Identification String�? row and it will update to this change.
31) Select the right column at the ��OpenRowSet�? and change it to the name of the table you are importing your flat file to (this should be consistent with table name under step 10).
32) Click OK
33) Select FILE and select ��Save As��? and then give your package a new name that��s meaningful (this will be helpful if you have to rerun the import of the flat file later).

Run (execute) the Revised Package (data import)

34) Go back to SQL Server Management Studio and open the Object Explorer
35) Connect to an ��Integration Services�? component. This should essentially be a local instance (not sure where it is on the local computer or in SQL Server Management Studio on the local computer).
36) In ��Object Explorer�? go down to your ��Integration Services�? object and expand it.
37) Expand ��Stored Packages�?
38) Right click on ��File System�? and select ��Import Package�? and an ��IMPORT PACKAGE�? window will appear
39) For ��Package Location�? choose ��File System�? and then browse for the ��Package Path�?
40) Click into the ��Package Name�? and it defaults to your Package��s file name.
41) Click OK and the Package is imported.
42) Right click on the newly imported Package and select ��Run Package�?
43) An ��Execute Package Utility�? window appears
44) Select ��Execute�? and the package runs.

View 1 Replies View Related

HELP!!! Cannot Import SSIS Package Files From .dtsx Files

Oct 8, 2007

Brief overview...Running SQL Server 2003 Server Enterprise 64 bit - All Service Packs and patches current
SQL Server 2005 Enterprise Edition 64 bit Build Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

I cannot import any SSIS packages nor crete any new folders under stored packages. I hve googled the news groups and looked at BOL to no avail. HELP!!!!

View 20 Replies View Related

Bulk Import With Header In Text File

Nov 28, 2005

I would appreciate some help on a procedure that I have. Using BulkInsert, I would like to import records from a text file. The issue Ihave is the file contains a header - '1AMC_TO_Axiz' and a footer'1AMC_TO_Axiz2". Using a format file, I can get the import to work byediting the file and removing these two entries. Is there a way tosetup the format file to skip these two entries? My file currentlylooks like this:7.0161 SQLCHAR 0 50 "|" 1 keyMemberNo2 SQLCHAR 0 10 "|" 2 fldEffdate.................16 SQLCHAR 0 10 "
" 16 fldNewRecordThanksCharles

View 3 Replies View Related

Header Rows To Skip On Flat File Import/Export

Aug 29, 2006

Just attempting to import a simple tab delimited text file into my SQL Server 2005 database using the SQL Server Import and Export wizard. Column names are specified within the first line of the file. The Header Rows to Skip field value is listed as 0, but the wizard indicates that "The field, Header rows to skip, does not contain a valid numeric value".

Why isn't zero (0) a valid numeric value? I don't want to skip any rows. PLUS, I get the same error when trying to export to a text file although the header rows to skip field does not exist. I can increase the number to 1 or more, but the wizard will skip part of my data .. unacceptable.

What am I missing here? I installed SP1 of SQL server 2005, but that did not help.

Thanks in advance.

View 1 Replies View Related

FOR EACH Loop To Export Files Based On Header Record

Dec 21, 2006

Hey guys,,

Well im new at this SSIS stuff and i have something that i am trying to do, but cannot get it to work.. Ill try to explain, and if anyone can help me or point me in the right direction it would be much appriciated..

I have 2 tables, one header table. and one lines table. This is a one - to -many relationship.. ie 1 header, many lines.. This is a Order Header, and Order Lines table setup.. Order header has Order numbers and and email address field that link to the lines table by order number. I also have a view which links all this info together.

I would like to export a excel file (preferable named from the order number column - but that can come later) for each order number in the header table. The excel file will contain the details from the View that was created. I want this to loop through all the header records in the header table and create a excel file for each one..

Down the track i want to add a send mail task to this and pass the email address to a variable so i can use it in the send mail task.. But ill get the main part working first..

Anyhelp would be more than helpful.. I tried to set this up, but i am stuck on the enumerator part..

thanks again, scotty

View 3 Replies View Related

How Do I Check If The Trailer Row Is The Last Row?

Jun 5, 2007

Hello,

I need to import and validate a flat text file. The text file has a header and a trailer row. I have been able to implement everything except the following requirement:

I should check if the header row is the very first row of the file and if not, fail the import. I should also check if the trailer row is the very last row of the file and if not fail the import. The header and trailer rows themselves have a different format than the actual content rows and are not imported into the database, so I cannot do the check there.

Any help is appreciated.

Thanks,

Rosen

View 1 Replies View Related

SQL Server 2008 :: Bulk Import And Create New Table Based On Header Fields Of Imported File (XLXS)

Sep 11, 2015

I have a record in an Excel format (Excel 2010) and I would like to bulk import that into SQL Server 2008 and also while importing, SQL Server will automatically create a new table based on the header fields or row of the source file.

I am not sure if SQL Server 2008 has this capabilities.

View 0 Replies View Related

18258: Dbswritecheck: Read Of First Trailer Failed

Mar 15, 1999

I'm getting the above message when doing the nightly backup via a scheduled task. It's been working fine until this weekend when we ran out of disk space. I freed up space and still get this message when running manually.

Your help is appreciated

View 4 Replies View Related

Integration Services :: Adding Trailer Record To End Of A File?

Apr 27, 2011

I have an SSIS package which takes a SQL Query and generates a PIPE (|) delimited flat file. Simple enough. However, I also need to add a Trailer record at the bottom of the file (footer). To make this happen I could either do a UNION ALL on the same query script or what I've done is to create another query with the Trailer record and using the Merge component simply merged and appended the trailer record at the botton of the actual file.

The issue, however, is that the trailer record is always including extra PIPES at the end of the trailer. According to business, this wouldn't load properly at our vendor side due to the extra pipes in the trailer record as it'll be seen as additional columns.

Is there anyway to get rid of those extra pipes at the end of the trailer?

Trailer record should look like this:

TRAILER|A|B|C|D|

As of now, the appended Trailer record looks like this (additional pipes for each column in the main query script):

TRAILER|A|B|C|D|||||||||||||||||

View 4 Replies View Related

Import Files

Dec 18, 2001

Hi i have a question.
How can i import dump from a text file , to an exsiting database, i�m will not useing DTS, i what to use BULK cmd in sql queryanalyser etc.

Need help

/Fredrik

View 1 Replies View Related

Import CSV Files To SQL

Mar 28, 2003

I have SQL 2000 running under windows 2000 server.

Question:
I'm receving CSV files from the field.
I would like to built SQL database from daily CSV files. I've been doing this manually :( however, is there anyway I can do this task automactically so that once new daily CSV file ~200KB appear in the folder, progarm automatically insert recent file to SQL database...:) Do I need to write VB progarm for this? Please help...

View 4 Replies View Related

Import Xml Files

Jul 4, 2007

I have created a stored procedure to handle xml data.
One of the inputs to this procedure is xmldata which is basically the contents of the xml in a file.
Now I would like to create a SSIS package that takes the xml files from the network and uses this SP.
Should I have a file system task inside a for loop container?
How do I get started on this please?
Thanks

View 2 Replies View Related

Import Xml Files

Jul 4, 2007

View 2 Replies View Related

SQL Server Import And Export Wizard Fails To Import Data From A View To A Table

Feb 25, 2008

A view named "Viw_Labour_Cost_By_Service_Order_No" has been created and can be run successfully on the server.
I want to import the data which draws from the view to a table using SQL Server Import and Export Wizard.
However, when I run the wizard on the server, it gives me the following error message and stop on the step Setting Source Connection

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)
- Setting Source Connection (Error)
Messages
Error 0xc020801c: Source - Viw_Labour_Cost_By_Service_Order_No [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
(SQL Server Import and Export Wizard)

Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)

- Setting Destination Connection (Stopped)

- Validating (Stopped)

- Prepare for Execute (Stopped)

- Pre-execute (Stopped)

- Executing (Stopped)

- Copying to [NAV_CSG].[dbo].[Report_Labour_Cost_By_Service_Order_No] (Stopped)

- Post-execute (Stopped)

Does anyone encounter this problem before and know what is happening?

Thanks for kindly reply.

Best regards,
Calvin Lam

View 6 Replies View Related

Import Data From MS Access Databases To SQL Server 2000 Using The DTS Import/Export

Oct 16, 2006

I am attempting to import data from Microsoft Access databases to SQL Server 2000 using the DTS Import/Export Wizard. I have a few errors.

Error at Destination for Row number 1. Errors encountered so far in this task: 1.
Insert error column 152 ('ViewMentalTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 150 ('VRptTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 147 ('ViewAppTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 144 ('VPreTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 15 ('Time', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.

Could you please look into this and guide me
Thanks in advance
venkatesh
imtesh@gmail.com

View 4 Replies View Related

Import Multiple XML Files At Once

Jul 17, 2007

Hi,
I have about 300-400 XML files I want to load in my SQL database (2005). The following code will load one (1) file. How do i do a mulitple collections?
INSERT INTO MEL (DATA) SELECT * FROM OPENROWSET (BULK'C:TempCHAPTER1.xml', SINGLE_BLOB) AS TEMP Thanks,

View 4 Replies View Related

Automatic Import CSV Files

Mar 22, 2001

Dear all,

I'm new to SQL server. I would like to ask how to do the following. Now I have many CSV files in a directory, which are uploaded through ftp from my client computers daily. How can I automatically import those CSV files to the SQL server? Can I do it by a script or a stored procedure or something else?

Your help would be much appreciated.

Thanks,
Roland Lee

View 2 Replies View Related

Import Text Files

Aug 30, 1999

Hi ppl,
I'm trying to import a fixed lenght text file into a sql 7.0 table using the SQL command "BULK INSERT".

The text file is fixed length and end with a carriage return and linefeed. Fields aren�t delimited.

Wich definition of the "FIELDTERMINATOR" should i use ?

I need some Help here!!!
Thanks.

View 1 Replies View Related

How To Import Excel Files

Apr 23, 2007

I have data in excel files I want to import it to existing SQL Server database. I can use SQL Server built in import tool but before Importing, the data needs to be validated. What is the best way to do this?

Thanks

View 1 Replies View Related

Import Multiple Txt Files

Sep 3, 2007

I have 8GB of text files which are basically log files from the past few years.
There is 24 text files per directory which are labeled for every day (so they are not all in 1 folder).
It would make reading them much easier if I could import them to SQL but I only seem to be able to import 1 at a time? (with the wizards :eek: )

Surely there is a way to mass import without all the costly applications that google searches give me?
cheers :P

View 5 Replies View Related

Import Files Do Not Exist

Jan 22, 2004

I have a job that calls about 5 DTS's. Each DTS imports a text file. The problem is that some of the files may not be there every day. How do I exit the DTS without an error if the file does not exist, but I want my job to keep running...

View 1 Replies View Related