Yes

Thanks for your response -- now I took your answer to mean I need to provide access to the folder the dtsx package is located in to the Server or...

Sorry -- I got a bit behind in my response -- (able to respond now due to server being down). No I have not resolved the issue yet and...

Thanks Pablo -- appreciate your suggestions. As of your post I already had my meeting(s) and you were correct I didn't have enough time which I knew going in...

would you have any sample script to get me started preferrably in VB -- I can muddle through C# if not.

Thanks,

Ok guys here is my sample file -- it has about 30k records in it -- the original file has 14 million. The offending column is ValueStr.

Appreciate the extra...

Ok I can see a lot of you are having a look but no one appears to have an answer for this. I have tried all I can think...

Thanks Mathew this worked for me in SQL 2008. I really appreciate you guys providing this information was a great help. Took a little time to wrap my...

So I tried your suggestion of deleting and recreating the subscription and the first time I executed the SP it worked perfectly. The second time I executed it I...

Great article do you have an update for 2008? I have tried to implement this with SSRS 2008 -- I tested in SQL Managemetn studio executing the SP data_driven_subscription...

My admin has installed IIS and now I don't get an error message but a request to log into reporting services. The administrative login isn't working but I notice...

Thanks Luke for the quick response it appears that when the SSRS was configured IIS was not installed on the machine. My admin is doing that now so I...

I appreciate the answer it turns out I required my Administrator to set up the login account for the app I didn't have appropriate rights on the server to do...

Appreciate the responses guys I finally figured it out and feel a little dumb now I have the answer. Apparantly I had exported the file with an extra field...

Sorry not code data and the last numeric field is the Sequence field being referred to in the error