Ted Krueger (5/14/2009)

---

I don't know of any tools to do so. There are some for VB.NET to C# but most always require some "help". I may have time...

Thanks for your help Ted!

Thanks for your reply !

Is it possible to convert VBscript into MS Visual C# 2008 ?

Thanks

Thanks!

I created a workaround solution and used the system record counter to generate my primary key.

Thanks

Changing to -1 did not work, but changing to text format worked!

Many thanks for your assistance 😀

I have searched the internet for a solution, but no luck.

This seems very easy, but for some reason poorly documented.

Has anyone else experienced this ? What is a workaround solution...

It loads the first file in the folder, then goes to the sixth file in the folder then stops ?

Any suggestions ?

I got it working by deactivating the delimiter but thanks anyway!

I have a new issue with the Foreach loop function.

I have no idea why it is failing and i get...

Is deactivating the delimiter the solution ?

Thanks

Worked like a charm.

Many Thanks !

Loaded 14586 text files of between 30k and 35k in 2 min 55 seconds.

I owe you some beers 😀

I added a new variable and still get the same issue ?

What am i missing?

Thanks

alter procedure [dbo].[usp_ImportMultipleFiles] @filepath varchar(max),

@pattern varchar(max), @TableName varchar(max)

as

set quoted_identifier off

declare @ID int

declare @ID2 int

declare...

I am trying to load 299 resumes and it only loads 101. Why ?

Thanks

It seems to count the number of text files correctly but for some reason only loads a much smaller amount ?

(300 row(s) affected)

(1 row(s) affected)

(299 row(s) affected)

(101 row(s) affected)