If you can create SQL Agent Jobs on the DB server, there is no logical reason why they should not let you load your SSIS package onto the DB server...

Randy Doub (2/20/2013)

---

I read elsewhere that since a flat file is a text file, if you use a Text Qualifier it will be applied to every column.

So here's what works......

I use script tasks in the OnError events of executables to store the error messages for sending an alert email at the end of the job (I also use a...

update tablename

set column = stuff(column,1,1,'')+'0'

where column like '009_';

[sarcasm]Simply set the date bucket parameter to weekly and the range filter from June 2011 to today.[/sarcasm]

Sorry, feeling a bit :hehe::w00t:

Truly...

Create a dates table (with weeks in it)

Add a data...

ajreynolds (2/20/2013)

---

I occasionally have need to export data from a MSSQL database to a file, copy the file to another server on a different network, then import the data from...

Have you tried not just logging on as the SQL Agent user, but also opening excel to initialise the office system for that user?

Well, if the import file is invalid because it contains unquoted separators in the data, you will always struggle.

You should get the producer of the data to remove invalid characters...

have you captured a trace of that new C# code running?

Is this a one-off import or are you setting up a repeatable process?

Maybe what you really need to do is post the C# code as that seems to be calling wrong...

Because you are declaring a parameter for the sp_executesql to use, but not actually using it in the query to execute...

You can either change the last line to this:

execute sp_executesql...

here

Edit. Removed As hadn't seen whole thread. #stupidtablet

Thanks.

Paul White - yet again you have impressed!! Very few people out there appreciate how powerful SQLCLR can be...