don't use SSIS for it - if the database is on same server just do a straight insert into it - if it is on a different server then use...

the index you were asked to supply is the one on table parts.tradecodecontrol -  index IDZ_ZPLID , not on  ExtractReports.dbo.TPls

the indexes that Des mentioned above would not help you as...

and winscp can be used within c# code - recommended way to use it  - https://winscp.net/eng/docs/library_ssis - or alternatively use it as a process task https://winscp.net/eng/docs/guide_ssis

shrink database is pointless - you do need to do shrinkfile but not using the option truncateonly as that will not move data around the file so it can free...

did you do a shrink database or a shrink file? looks like the first 1 and that is the wrong one to use

same issue - no emails and toolbar gone

this is the 4th thread you create on the same subject - if no one has answered the other 3 then creating a new one is not going to sort...

Good SQL programmers do not use proprietary features like TOP in their code. If your system lives for a few years, there's a good chance it will be moved...

once you add the parameter you can't add it again - but you can update it.

so on your last example where you have the case block you need to instead...

your most welcome and it was no bother at all to help on this.

and we all learn something everyday mainly when we help others.

ok. issue is the row separator

you defined it as \r - but it really is \n\r so the way the code is there will be a few records with hex...

I've added some print statements to the following - run it again and the filename before the error will be the one failing - would need to look at that...

try the following - untested

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER Procedure [dbo].[import_dailytracing] @filepath varchar(500), @pattern varchar(100), @tablename varchar(100)

As

Begin
-- these 2 should always be set in ALL sp's
-- ...

your issue is the blank lines at the end of the file - if this is always how you get them you have 3 options (in order of preference)

1 -...

both files worked for me

if object_id('dbo.TestTracingImportSP') is not null
drop table dbo.TestTracingImportSP

create table dbo.TestTracingImportSP
(
[Initial] varchar(200)
,[Number] varchar(200)
,[Location City] varchar(200)
,[State] varchar(200)
,[Month] varchar(200)
,[Day] varchar(200)
,[Time] varchar(200)
,[L or E] varchar(200)
,[Event] varchar(200)
,[Train ID] varchar(200)
,[Destination...