Any ideas please? this is failry urgent

I have a mixture of VB and SSIS packages doing these jobs....

BUT i want to get away from all of this, I have non tech people working on my team...

Thanks for the suggestions.

I am currently using VBScripts to copy & move files, this works well but I now have about 32 files and associated scripts which are scheduled through...

Ok I think i found out why, it was using spaces between the names.... I duno... either way its select is working now.

Thanks for your help!!!!!!!!!!!!!!!!!!!!!!

Its is very strange!!!!!

I can see, edit, open the table but i cant run a select against it!

:crazy:

Thanks, the [] worked.

I cant seem to rename the CREATE TABLE bit in my SSIS...

Once I run the first set to create the table with new name.."tblTransaction".

I run the insert...

Thanks,

I used the Import wizard... looks like it has worked...well 50/50

Its created a table called 'File-Name-Of-My-ExcelFile$'

And in the same format as above i.e. including the - & $

When I do...

Right I have done what you have suggested and it worked:

The following is my TEST flat file:

borg_code,active_flag,bfun_code,bodd_group_code,clty_code,cmpy_code,credit_man_flag,crr_netting_flag,dflt_prio_code,

dispatch_days,lndring_review_date,money_lndring_status,registered_indicator,statement_ind,swift_names_reqd_flag,thresh_risk_pcnt,

tmsn_mech_code,old_ref_code

ABC 9001,N,TRD,,,INVESTEC_UK,N,N,,,,,,,N,,,

ABC 9002,N,TRD,,,INVESTEC_UK,N,N,,,,,,,N,,,

ABC 9003,N,TRD,,,INVESTEC_UK,N,N,,,,,,,N,,,

ABC 9004,N,TRD,,,INVESTEC_UK,N,N,,,,,,,N,,,

ABC 9005,N,TRD,,,INVESTEC_UK,N,N,,,,,,,N,,,

ABC 9006,N,TRD,,,INVESTEC_UK,N,N,,,,,,,N,,,

ABC ...

Columns = 18

Rows = 547

Would it be worth looking into Format File to Bulk Import Data?

Ok so the following error is occuring even before I finish setting up the flat file to OLE DB connection.

Within Flat File Connection Manager I have selected:

Format: delimited

Text qualifier: "

Header...

Thanks Chris,

I will start from scatch then come back...

I have open the csv file in wordpad, no " or ' apart from those used as column deliminators.

Example data:

"ABC 9001","N","TRD","","","IN_UK","N","N","","","","","","","N","",""

"ABC 0001","N","TRD","","","IN_UK","N","N","","","","","","","N","",""

"ABC 0002","N","TRD","","","IN_UK","N","N","","","","","","","N","",""

"ABERD9001","N","TRD","","","IN_UK","N","N","","","","","","","N","",""

"ABERD0009","N","TRD","","","IN_UK","N","N","","","","","","","N","",""

"ABERD0037","N","TRD","","","IN_UK","N","N","","","","","","","N","",""

Thanks,

I have checked the csv file, i do not have any rows with " or '

Thanks Chris,

Im a bit lost now...

You say I got an embedded single or double quotes in an input string which I'v designated as an output column.

Im a bit new...

What does the following error mean?

TITLE: Microsoft Visual Studio

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

The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding text qualifiers in data. Parsing columns...