SSRS - Data Driven Subscription, avoid using special character in filename. There are no special characters

Asked Jan 08 '18 at 22:42

Active Apr 27 '19 at 13:10

Viewed 309 times

I'm using SSRS Data Driven subscriptions to produce 300,000+ word documents (.docx).

The majority are being produced fine however, some are reporting an error of

The filename is invalid. Avoid using special characters such as /\?*<>:|+,[]"&

All the filename are consecutive numbers starting from 10000000. One of them failing, for example, is 10898392, so no special characters and no trailing spaces etc.

I cannot work out why this is happening - any thoughts on this appreciated.

edited Apr 27 '19 at 13:10

Hadi

36,233
13
65
124

asked Jan 08 '18 at 22:42

Nick Lea-Trengrouse

are you sure there are no hidden characters? – Harry Jan 08 '18 at 22:54
Hi Harry, thanks, how do I reveal hidden characters? – Nick Lea-Trengrouse Jan 08 '18 at 23:01
Hi Nick, How do you generate your file names? – Harry Jan 08 '18 at 23:02
Using IDENTITY(10000000,1) on the table, Link Id's are inserted into the table so the ID's are created during the insert – Nick Lea-Trengrouse Jan 08 '18 at 23:25
Are you able to explicitly convert the generated file name into bigint for a test and see if it fails or runs ok? – Harry Jan 08 '18 at 23:33
The process is currently running as part of a dry run migration, I need to wait till it's finished to run a test of it. I'll set the column type to bigint and repopulate it and try it again. Do you know why having it as bigint may solve the problem? Or is it just a hunch (I can work with hunches :)) – Nick Lea-Trengrouse Jan 08 '18 at 23:39
I've had to deal with such stuff before and I work via process of elimination.. just a hunch to be honest.. – Harry Jan 08 '18 at 23:41
Ok, cool. I'll give that a go once it's finished. Thanks. – Nick Lea-Trengrouse Jan 08 '18 at 23:46

SSRS - Data Driven Subscription, avoid using special character in filename. There are no special characters

0 Answers0