Issue with data not being loaded to dbo.FileData

[ralveshsdyn]

Hello i have 2 issues, the first one i solved by adding "_auto/' in the stored procedure:

"DECLARE @BulkFile NVARCHAR(MAX) = 'csv/_auto/' + @sourceFileName;"

Else i would get an error of file not found or no rights. And it makes sense since the files are in the "_auto" folder inside csv container right?

Another issue that i cant solve is that data from file is not loaded to dbo.FileData.
Theres no errors at all in console and data is added to in "dbo.File" table, but nothing in dbo.FileData.

Any ideas? Thanks

[ralveshsdyn]

After some research i see the problem is probably in the .fmt file.
If i dont use a format file and instead specify " FORMAT = 'CSV' " i can bulk import stuff, but if i use it then 0 rows get affected.
Any ideas?