SQL2005 SSIS - Won't Allow Text Delimiters

Jul 11, 2006

W2k3 server, SQL 2005.
@@version = Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Standard Edition on Windows NT 5.2
(Build 3790: Service Pack 1)

I'm trying to set up my first SSIS package to import a flat file to a
database table. The connection manager will not allow a text
qualifier.

My data is comma delimited, with doublequotes around each field. If I
enter " as the text qualifier, then I get the error "The preview sample
contains embedded text qualifiers ("). The flat file parser does not
support embedding text qualifiers in data. Parsing columns that
contain data with text qualifiers will fail at run time." The data in
Columns view shows as just one column rather than multiple columns.

If I leave the text qualifier as None, then the data in Columns view
shows as just one column again.

I've tried with more than one datafile, including a short sample file
that I set up manually. All files get the same error.

Has anyone else seen this problem?

Thanks much for any assistance!

View 14 Replies


ADVERTISEMENT

Import Text File With Multiple Delimiters

Jun 5, 2007

I have a text file that I'd like to import into a SQL 2005 table. The file is tab delimited, which is easy enough to import, but I'd like the final field broken into multiple fields as well. The final field is space delimited. I've had no luck at being able to get this done. Has anyone done this?

View 5 Replies View Related

SQL 2012 :: Parsing Out Data String With Text Delimiters

Nov 5, 2014

I'm trying to parse out a line of data that is separated by the text "atc1.", "atc2." etc.

For example,

[atc1.123/atc2.456/atc3.789/atc4.xyz/]

If I only want the data after atc2., then I could search the string for "atc2." and collect all the characters afterwards. But how can I make sure to trim off all the data after "atc3." to make sure I'm only collecting "456" from the example above?

View 2 Replies View Related

How To Export To A Fixed Width Flat Text File With Row Delimiters?

Aug 28, 2007

We're having issues exporting a set of data from SQL to a fixed width flat text file by just doing a right click on the DB, then choosing Tasks > Export Data. You can not specify a row delimiter when you choose a Fixed Width format. The only way around this that we've found is to specificy char(13) and char(10) at the end of the SQL select statement. Without row delimiters you end up with 1 giant record rather than 20,000 regular sized records. Is there any other way around this that we're missing?


Using Ragged Right is not an option either since the record lengths will be inconsistent if the last field doesn't contain a consistent length to the data.


Thanks,
Mike

View 16 Replies View Related

Loading Flat File With Embedded Column, Text Delimiters And Newline

Jun 14, 2007

I have the misfortune of converting a DTS package to SSIS that loads a flat file that has a text fields that can contain embedded text delimiters ("), column delimiters (,) and even new lines (CR+LF i.e.,hex 0D 0A) in it. A sample line from the file is posted here, remember this is just one line though it shows as three lines, since the third field has embedded new line in it:



4,"Sam","EVP; MARKETING PRODUCT MANAGER ""Level I"",
Internet Sales / HELP
8005551212",100



If you open in excel it handles it perfectly showing four fields, as below, and this is what I want ( I cannot get it aligned right in the posting, just save the above line in *.csv and open to see what it should be):



4 Sam "EVP; MARKETING PRODUCT MANAGER ""Level I"", 100
Internet Sales / HELP
8005551212"



Now, SSIS errors on the embedded text delimiters and breaks into two or three lines based on which option I chose. I have tried few options based on postings in the forum:
a). Using undouble and undoubleout: Does not work when there are embedded column delimiters (,) in the text field
b). Modified undouble script posted by lvovg at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1718225&SiteID=1. Handles the embedded column delimiters (,) perfectly, but the embedded new lines (CR+LF i.e.,hex 0D 0A) are breaking it.
Since, I am using the ragged right format to read from the file then use transform script on the line by lvovg, the line is already broken by the ragged right format at the embedded new lines, hence does not work.



Right now I am stuck. Can someone please help (anyone from MS) ? I am already baffled at the amount of coding required to convert a very basic ( and working ) flat file load DTS package to SSIS. I am willing to persist bit longer to convert this to SSIS, before I give up and stick with DTS and wait for a fix / workaround.




Thanks.

View 7 Replies View Related

Problem Importing Text Files With Binary Zeros (0x00) Via SSIS(SQL2005). It Is All Fine When Using DTS(SQL2000) Though.

Apr 24, 2008

Hi.

There is a "text" file generated by mainframe and it has to be uploaded to SQL Server. I've reproduced the situation with smaller sample. Let the file look like following:
A17 123.17 first row
BB29 493.19 second
ZZ3 18947.1 third row is longer
And in hex format:
00: 41 31 37 20 20 20 20 20 ”‚ 31 32 33 2E 31 37 20 20 A17 123.17
10: 66 69 72 73 74 20 72 6F ”‚ 77 0D 0A 42 42 32 39 20 first row™ͺ—™BB29
20: 20 00 20 34 39 33 2E 31 ”‚ 39 20 20 73 65 63 6F 6E 493.19 secon
30: 64 0D 0A 5A 5A 33 20 20 ”‚ 20 20 20 31 38 39 34 37 d™ͺ—™ZZ3 18947
40: 2E 31 20 74 68 69 72 64 ”‚ 20 72 6F 77 00 69 73 20 .1 third row is
50: 6C 6F 6E 67 65 72 ”‚ longer

I wrote "text" in quotes because sctrictly it is not pure text file - non-text binary zeros (0x00) happen sometimes instead of spaces (0x20).

The table is:

CREATE TABLE eng (


src varchar (512)

)

When i upload this file into SQL2000 using DTS or Import wizard, the table contains:

select src, substring(src,9,8), len(src) from eng
< src ><substr> <len>
A17 123.17 first row 123.17 25
BB29 493.19 22
ZZ3 18947.1 third row 18947.1 35

As one can see, everything was imported, including binary zeros. And though SELECT * in SSMS truncates strings upon reaching 0x00's, still all information is stored in tables - SUBSTRINGs show that.

When i upload this file into SQL2005 using SSIS or Import wizard the result is following:
< src ><substr> <len>
A17 123.17 first row 123.17 25
BB29 4
ZZ3 18947.1 third row 18947.1 25

This time table is half-empty - all characters behind binary zeros in respective rows are lost.

I stumbled upon this problem while migrating my DTSes to SSIS packages. Do you think there is some workaround, or i need to turn on some checkbox or smth else could help? Please...

View 8 Replies View Related

Uploading Pdf Files In SQL2005 And Performing Full Text Search

Jun 2, 2007

Can anyone show me how to upload a pdf file to SQL 2005 and perform a Full Text Search on it and to extract record based on a word in the pdf. I have looked all over the web and I couldn't get any thing working as mentioned in other forums. Please mail me a small example if possible on salman.anwar@wmich.edu ASAP.

View 1 Replies View Related

Delimiters

Jun 16, 2008

Dear gurus,

my problem is below,pls give me solution

if i give the values like

@A='test1@test.com;test2@test.com;test3@test.com;test4@test.com;'


i want to get like this

mail_id
--------
test1@test.com
test2@test.com
test3@test.com
test4@test.com


thanks in advance,



cool...,

View 2 Replies View Related

Importing Pervasive SQL Into SQL2005 Via SSIS

Aug 28, 2006

In SQL 2000, I had a working DTS package that would import a Pervasive SQL database into SQL 2000 (There is a good reason, provided on request). The column type definitions came over just fine in SQL 2000 with a few minor changes.

In SQL 2005 (SSIS), i create a Data Source via the Connection Manager (Provider: .Net ProvidersOdbc Data Provider) to the Pervasive database (System DSN, <database_odbc>). I then create a Data Destination via the Connection Manager (Provider: Native OLE DBSQL Native Client) to the SQL database. Both databases reside on the same machine.

I've created a DataSource Reader and used the sql command, "select * from ARCustomer" as an example. The issue is with "data types" for the columns. They don't come close to resembling the results that i had in SQL 2000 DTS.

Is there another method or parameter setting that will preserve the "data types" for the columns being imported from the Pervasive database.

This has been a real stumbling block and any help would be truly appreciated. Thanks in advance for your assistance ... Bernie

View 5 Replies View Related

What Are Object Delimiters

Oct 6, 2014

What are object delimiters ?how and why they are used?

View 1 Replies View Related

MS SQL2005 Express Ed + SSIS Installation Problem

Jun 22, 2007

Hi,

I have tried to install SSIS going steps msdn2 using "mssql setup" but my "ssis" option is not available for installation.

Pls, help!

View 4 Replies View Related

Need To Convert This SQL2000 DTS Validation Code To SQL2005 SSIS

Aug 8, 2006

Hello,



How do I convert VBSCRIPT code in a DTS package which is used for data validation to SQL 2005 SSIS?



Thanks,



Michael

View 2 Replies View Related

Copy Objects With SSIS Dtsx Sql2005-&&>sql2000

Jan 27, 2008

Hi experts.

Challenge: Datapumping. To copy daily production data from N x 100 SQL 2k servers to one central SQL2k5 server.
Sometimes copying task might demand transferring schema objects like temp tables and procedures from sql2005 to sql2000.

Since system organisation is different, what would be the best approach ?

Thanks
Grega

View 3 Replies View Related

Sql2005 SSIS - Doesn't Transfer The PKs And Indexes Of Tables

Jul 23, 2007

Hello,



I created ssis package to transfer tables from one DB to another.

However, I don't find the option where I can make that the transfer with the indexes and pks of the tables. in sql2000 I had this option.



appriciate your help.



Kubyustus



View 9 Replies View Related

Production SQL2005 Std, And Missing SSIS (easy Question)

Feb 27, 2008



IS this procedure exactly correct?

http://support.microsoft.com/kb/913967

Line 10 does not say go to advanced but that is the only place I see Integration Services to install.
Can't make a Maint. Plan for backups because the server is missing SSIS..
Thanks.

View 1 Replies View Related

Importing Flat File Which Has No Delimiters

Mar 20, 2008

Hi,

I have a flatfile which is of the following format. I want to import this data into the sql server 2005 database.
The alphabets at the start of each line represents the type of record. The data are position specific.



XYZQ20214646001V0608
A1249220AUGPSEA D11I0000
BCA030552050000C1234567841234412000
CFO093441050000C0895632175223652000
D100C5D0AA00C5D366
D200C5D92E00C5DB9F
E002720AUGSEA 0NRT 008D00000001 00C5D0E600C5D348N0000000000000
0000000 00000000CA0000FO0000
F002622AUGNRT 0SEA 008F00000002 00C5D96A00C5DB81N0000000000000
0000000 00000000CA0000FO0000


for ex in Record A, the following are the values that are based on column length
1 - (col length is 1)
249 (col length is 3)
20AUG (col length is 5) etc..
P
SEA
D
1
110000

View 2 Replies View Related

How To Refresh Transformation In SQL2005 SSIS (I'm Trying To Transfer Random Sql Table Into Dbf)

Jun 13, 2007

Im from Russia, sorry if my english is not very good.

Here's the case:

1)-------------------------------
I made a DTS-package in sql2000 that transfers the [sql table] into [dbf file] via jet4.
First i create (in delphi) the empty dbf with the same name and columns same as in sql table.
Second, I run my DTS with variables - source and destination table names

In DTS there is source, destination and transformation . After I send the Variables(table names)
, the transformation "arrow" needs to be "refreshed" to make column names in both tables correspond each other. For that in transformation I chose ActiveXScript Mode and wright VB Script:

'**********************************************************************
' Visual Basic Transformation Script
'************************************************************************

' Copy each source column to the destination column
Function Main()

dim i

For i = 1 To DTSSource.Count
DTSDestination(i) = DTSSource(i)
next

Main = DTSTransformStat_OK
End Function

And it works

2)------------------------------
I want to do same thing in sql2005 SSIS but don't figure out how...
I managed to make a package that recieves (in variables) table names and runs correctly.
But after I change those variable names into any other it crashes -
Description: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

Of cource this happens 'cause I didn't "refresh" the transformatoin (and maybe also source and dest), but I don't know how.

Anyone can help ?!

View 8 Replies View Related

How Do You Specify Special Characters As Flat File Delimiters?

Mar 15, 2006

I have a flat file that has fields delimited by tilde {~} and rows delimited by {CR}{LF}. The problem is, my source is spitting out the {NULL} (&H00) at the end of the row.

The data displays correctly in the pre-viewer (with a non-print symbol at the end of the last field), but gives an error when I try to run the package.

Example:

€œdata€?~€?data€?~€?data€?{NULL}{CR}{LF}

I can process the row in c# using:

€œ
€?

as the row delimiter. What is the equivalent notation for SSIS?



Thanks,

View 6 Replies View Related

Replacing Active X/VBscript Used In SQL2000 Data Transformations To SQL2005 SSIS

Nov 1, 2006

Hi

I am new to SSIS and have the following problem. I used the following script to clear data in columns of any CR/LF/Commas and char(0)'s. Can I just transfer this to SSIS and how exactly do I do that? Any help or advice would help.

Function Main()

Dim x

For x=1 to DTSSource.count

If Isnull(DTSSource(x)) = False Then

DTSDestination(x) = replace(replace(replace(Replace(DTSSource(x) , chr(13),""),chr(10),""),chr(0),""),","," ")

Else

DTSDestination(x) = DTSSource(x)

End If

Next

Main = DTSTransformStat_OK


End Function

Andre

View 8 Replies View Related

Column &&amp; Row Delimiters To Read Flat Files Into SQL Table

May 6, 2008



Hi,

I have a package that reads a fixed width flat file data into a single CHAR column in an sql server 2005 table.

In the "Columns" tab of the Flat File Connection Manager, I set the RowDelimiter value to {LF} and nothing for the ColumnDelimiter (since I read the entire row from the flat file into a single column in my sql table).

However, in the "Advanced" tab, the ColumnDelimiter Misc property shows {LF}. This was working fine for me.

The problem I was facing was with some files which were recently identified to have rows containing a special character (probably ASCII ZERO) in the middle of the row. So, now if the record was having 400 characters and the 200 th character had this special character, the package was writing the first 200 characters into the sql table and ignoring the rest of the characters.

I am sure that the special character was ASCII ZERO - I wrote a script to read each character in the line and find the ascii code for it.

Has anyone faced this problem ever. If so, pls let me know your solution or any ideas that can help sort this problem. Your help would be much appreciated.

Thanks!!

View 5 Replies View Related

Splitting A String By A Delimiter, But Ignoring Multiple Delimiters

Oct 22, 2007

Hi,

I have a function which takes a string and a delimter. It then splits the string by the delimter and returns a table of resultant strings:


CREATE FUNCTION [dbo].[vs_SplitTags] (@sep char(1), @s varchar(512))

RETURNS table

AS

RETURN (

WITH Pieces(pn, start, stop) AS

(

SELECT 1, 1, CHARINDEX(@sep, @s)

UNION ALL

SELECT pn + 1, stop + 1, CHARINDEX(@sep, @s, stop + 1)

FROM Pieces

WHERE stop > 0

)

SELECT pn,

SUBSTRING(@s, start, CASE WHEN stop > 0 THEN stop-start ELSE 512 END) AS s

FROM Pieces

)




This works very well, other than instances of the delimter are, themselves, considered to be results. For example:

SELECT * FROM vs_SplitTags(' ', 'foo bar') AS result
returns:
pn s
1 foo
2 bar


which is exactly the result I would want.

However,
SELECT * FROM vs_SplitTags(' ', ' foo bar ') AS result -- There are spaces before 'foo' and after 'bar'
returns
pn s
1
2 foo
3 bar
4

And
SELECT * FROM vs_SplitTags(' ', 'foo bar') AS result -- There are two spaces between 'foo' and 'bar'
returns
pn s
1 foo
2
3
4 bar


I want the function to ignore whitespace altogether, be it a single space or multiple spaces. Other than to delimit the boundries between words, of course.

In other words, all three examples above should produce the same result:
pn s
1 foo
2 bar

How can I do this? Any thoughts much appreciated...

View 5 Replies View Related

SQL Server 2012 :: Retrieve String Between Two Delimiters For Multiple Occurrences?

Oct 21, 2015

How can we get the result set as TESTING1,TESTING2 from below

DECLARE @MyString varchar(256) = '$I10~TESTING1$XYZ$I10~TESTING2$~'
Basically i need to get all the substrings which are in between $I10~ and $

View 6 Replies View Related

How To Use Multiple Delimiters For The Same Flat File Source While Creating The Package

Sep 6, 2007


Hi everyone,


There is a small problem encountered while creating a package in sql
server 2005.
Actually i am using a flat file which has 820 rows and 2 columns which
are seperated by line feed(for ROW) and tab(for COLUMN).after
importing i found that ther are only 800 rows imported into the table.
Ather verifying the input file i found out that there are some null
values in the second column so there is no line feed for those
values.
Can anyone please help me how to give multiple delimiters for the same
input flat file.

View 9 Replies View Related

Sql2005 Database Restore From Another Sql2005 Backup File Error.

Dec 15, 2005

hi

i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :

 

 

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupackup.bak'. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


 

 

 

pls some one can help me ???

 

thanks

chaus

View 62 Replies View Related

Flat File Loading Problem -&&> Messed Up Delimiters And Error Logging Issue

Aug 31, 2007

Hey Everyone,

I have a Data-Flow task embedded in a Sequence Container (does not fail component on error) on the Control Flow panel of the SSIS designer. This data flow task contains a connection to a Flat File Source -> A Data Transformation -> Into an OLE Db Destination.

The problem is that the Flat File isn't always delimited properly -> the client cannot be relied on to do this.

My question is when the delimiters are messed up, how can I capture the offending error row(s) from the Flat File Source?

What I've tried:
1) Set every column in the source flat file on error to: Redirect Row
2) Added a Script Transformation to pull the description and the record id out of the offending row
3) Added an Error file flat file destination to the end of the flow.

The package always fails on the Flat File Source and never Redirects the offending Row to the error output - I never see my onError Script Transformation go Green, Red, or Yellow - SSIS doesn't let it get there.

I'm really new to SSIS so sorry if this is a super basic question.

Here is the Error Text:

[Source - InventTable_csv [1]] Error: The column delimiter for column "RECID" was not found.
[Source - InventTable_csv [1]] Error: An error occurred while processing file "C:------InventTable.csv" on data row 15228.
[DTS.Pipeline] Error: The PrimeOutput method on component "Source - InventTable_csv" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
[DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.

I do have the MaxErrorCount set to 1 on the Data Flow Task but still think I should see my script task execute and a log entry be generated.

Any Ideas?

Matt

View 15 Replies View Related

Can You Open A Database Created In SQL2005 In SQL2005 Express?

Oct 12, 2007



Can you open/use a database created in SQL2005 in SQL2005 Express?

Thanks for the help!

Max

View 4 Replies View Related

SQL2005 Cannot Backup A Restored SQL2000 Database With Unknow Database Full-text Catalog Database

Nov 15, 2007



We replicate a SQL2000 database (DataBaseA) to a SQL2000 database (DataBaseB) by using the Restore function and hasn't change its logical name but only the physical data path and file name. It is running fine for a year. We use the same way to migrate the DataBaseB to a new SQL2005 server with the Restore function and the daily operation is running perfect. However, when we do the Backup of DatabaseB in the SQL2005, it just prompt the error message


System.Data.SqlClient.SqlError: The backup of full-text catalog 'DataBaseA' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)


Please note we left the DataBaseA in the old SQL2000 server.


Please help on how we can delete the Full-text catalog from DatabaseB so we can do a backup


Many Thanks

View 1 Replies View Related

Upgraded SQL2000 To SQL2005, SQL2005 VERY Slow

Dec 27, 2005

I just upgraded my SQL 2000 server to SQL2005. I forked out all that money, and now it takes 4~5 seconds for a webpage to load. You can see for yourself. It's pathetic. When I ran SQL2000, i was getting instant results on any webpage. I can't find any tool to optimize the tables or databases. And when I used caused SQL Server to use 100% cpu and 500+MB of ram. I can't have this.Can anyone give me some tips as to why SQL 2005 is so slow?

View 3 Replies View Related

Sql2005 Standard To Sql2005 Enterprise Edition

Jan 4, 2007

Hi

We have Sql2005 x64 bit standard edition server installed in windows 2003 64 bit editio server,

currently due to buisness requirements we need to have sql2005 x64 bit enterprise edition, please let me know how do i do the upgrade or change.

is it possible to retain all our custom settings in the standard edition after changing to enterprise edition.

This has to be done for our production and very critical, please help



Thanks

Samuel I

View 4 Replies View Related

SSIS - Importing Varchar From Access Into SQL2005 As Varchar

Nov 20, 2006

For the life of me I cannot figure out why SSIS will not convert varchar data. instead of using the table to table method, I wrote a SQL query so that I could transform the datatype ntext to varchar 512 understanding that natively MS is going towards all Unicode applications.

The source fields from Access are int, int, int and varchar(512). The same is true of the destination within SQL Server 2005. the field 'Answer' is the varchar field in question....



I get the following error



Validating (Error)



Messages

Error 0xc02020f6: Data Flow Task: Column "Answer" cannot convert between unicode and non-unicode string data types.
(SQL Server Import and Export Wizard)


Error 0xc004706b: Data Flow Task: "component "Destination - Query" (28)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)


Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)


Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)


DTS used to be a very strong tool but a simple import such as this is causing me extreme grief and wondering of SQL2005 is ready for primetime. FYI SP1 is installed. I am running this from a workstation and not on the server if that makes a difference...

Any help would be appreciated.





View 7 Replies View Related

Install Sql2005 32 Bit After Removing Sql2005 64 Bit

Sep 19, 2007



I am unable to install 32-bit SQL Server Integration Services on the server due to something that was left behind by the 64-bit version.


I've uninstalled SQL Server 2005 64-bit and when I try to install the 32-bit version of Integration Services, I get this error: "Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error descrition: FATAL: Could not find component 'Microsoft.SqlServer.Dts.Task.MessageQueueTask.ServCompMQTask' we just installed."




I can't seem to figure out how to resolve this problem with the COM+ and I can't remember if Integration Services is required.

Can anybody please advise?

View 1 Replies View Related

Migrating Sql2005 Vb Dts Package To Sql2005

Jul 8, 2007

Hello,



I have a vb program that include a dts package that has been saved to vb with sql2000 dts wizard and works very good.



Now that I upgrade my website to sql2005, this vb dts package doesn't work.

The error I get is:



Microsoft Data Transformation Services (DTS) Package

Invalid STDGMEDIUM structure

(Microsoft Data Transformation Services (DTS) Package (80040066): Invalid STDGMEDIUM structure

) (Microsoft SQL-DMO (ODBC SQLState: 42000) (80004005): [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.)



I searched in the internet how to make dts package in sql2005 and save it to vb and found no information about it.

What Can I do to get the vb code of the dts package I create in sql2005 or how do i migrage the sql2000 vb dts package code to sql2005?



Thanks,

Kubyustus









View 4 Replies View Related

What Is The Best Way To Combine Two Text File Into One Text File In SSIS

Mar 20, 2008



Hi,

I am looking for a way to combine two text files into one file. I am thinking of using a batch file (DOS command ) to do it. Any suggestion please?

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved