I made the following changes in order to get the information into tables:

CREATE PROCEDURE dbo.ImportEqFiles

/**********************************************************************************

Purpose:

Given a valid file path and the "LIKE" filter for file names, import...

Anybody able to help me on this?

Hi Jeff, can you guide me on the next steps? Thanks!

Any new instruction on the next steps? Thanks!

Yes Jeff, for one of the questions (header related).

I am getting used to manipulate and adapt the code for treating the header that you provided, I am able now to...

Hi Jeff,

Hope you are recovered now. I got done last lesson you gave me. This is the working code:

DROP PROCEDURE dbo.GetFileTest

GO

CREATE PROCEDURE dbo.GetFileTest

/**********************************************************************************************************************

Purpose:

Give...

It's helpless, I have been trying to find the problem several times for the last 7 days but I can't find it because I have my limitation, if I haven't,...

Can anyone help me on this?

Any new instruction? Thanks!

Hi Jeff,

The file I sent last time is "urso47Test02.csv" and I am running EXEC dbo.GetFileType01 'c:\temp\sm\urso47Test02.csv'.

The first 2 columns has brackets on its contents, I thougth you were talking...

Another try:

DROP PROCEDURE dbo.GetFileType01

GO

CREATE PROCEDURE dbo.GetFileType01

/**********************************************************************************************************************

Purpose:

Give a full path/filename/extension, load the file according to the specs for "FileType01".

Usage Example:

EXEC dbo.GetFileType01 'C:\Temp\urso47Test01.txt'

Dependencies:

...

My last try:

DROP PROCEDURE dbo.GetFileType01

GO

CREATE PROCEDURE dbo.GetFileType01

/**********************************************************************************************************************

Purpose:

Give a full path/filename/extension, load the file according to the specs for "FileType01".

Usage Example:

EXEC dbo.GetFileType01 'C:\Temp\urso47Test01.txt'

Dependencies:

1....

As we don't have square brackets in the file uploaded, I tried removing them all, but it didn't work.

Making some changes, I realized that dots get gray, separated words get...

Hi Jeff,

First of all, Happy New Year! Out here it still 21:55... Hope you are having a great time with your family!

Based on the first file you created for me...

Hi Jeff,

I did it all over again several times and finally it worked.

1- I ran the "CREATE PROCEDURE dbo.ImportEqFiles" > "Command(s) completed successfully.".

2- I ran the EXEC dbo.ImportEqFiles 'C:\Temp\eq_files', 'Eq_sample_%.csv'...